contestada

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

Respuesta :

7gabier

Answer:

D: Age = '21'

Explanation:

Where gender = male, age = 21

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

Otras preguntas