Question

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

Answer 1

Answer:

D: Age = '21'

Explanation:

Where gender = male, age = 21

Answer 2

Query D will give the result table..

We will check each query one by one, then

• Query A doesn't show what to select from table.
• Query B doesn't show what to select from table.
• Query C shows to select name and age from table but with gender search.

• Query D shows to select name and age from table by the name of Joe and Frank.

• Query E doesn't show what to select from table.

So, from above terms, it is clear that Query D will give the result table.

Learn more: https://brainly.com/question/22033875