Question

Which SELECT statement produces the given output?

Name Height
Thomas
57.5
Joyce
51.3
a. select Name Height
from
where age=12
order by Height;

b. select Name, Height
from
where age=12
order by Height desc;

c. select Name Height
from
where age=12
order by desc Height;

d. select Name, Height
from
where age=12
order by desc Height;

Answer 1

The correct SQL statement is 'select Name, Height from where age=12 order by Height;' as it selects names and heights in ascending order for records where the age is 12.

Step-by-step explanation:

The student has asked which SELECT statement produces a specified output with names and heights, where the heights are not in descending order. Considering the output and the requirement for the data to be ordered by height in ascending order, the correct SQL statement is:

select Name, Height from <table_name> where age=12 order by Height;

This statement selects the Name and Height columns from a table (the actual table name has been omitted in the question) where the age column equals 12. The results are then ordered by the Height column in ascending order by default, as there is no DESC (descending) keyword specified.