Select the correct answer.
Which query will give the following result when it is applied on Table 1?
Name
Frank
Age
Gender
20
male
Table1
Name
Age
Gender
Mary
22
female
Joe
24
male
Kate
21
female
Frank
20
male
A.
SELECT Table1.name FROM Table1 WHERE (Age = 20)
B.
SELECT "Name", "Age" FROM "Table1" WHERE ("Gender" = 'male')
C.
SELECT "Name", "Age", "Gender" FROM "Table1" WHERE ("Age" = 20) (88)
D. SELECT "Name", "Age", "Gender" FROM "Table1" WHERE ("Gender" = "male" AND "Age" = 20)
E.
SELECT FROM Table1
