Select the correct answer. which query will give the following result when it is applied on the original table? result table: name age joe 24 frank 20 original table: table1 name age gender mary 22 female joe 24 male kate 21 female frank 20 male a. select * from “table1” where (“name” = ‘joe’ and “name” = ‘frank’) b. select * from “table1” where (“gender” = ‘male’) c. select “name”, “age” from “table1” where (“gender” =‘male’) d. select “name”, “age” from “table1” where (“name” = ‘joe’ and“name”=‘frank’) e. select * from table1