Question 1
1 markThe table Ride, shown in the figure, stores details of the rides at a theme park. A query must list the rides with the lowest minimum height first.
Which clause should be used at the end of the query?
Choose your answer.
- ORDER BY MinHeight DESC
- ORDER BY MinHeight ASC
- ORDER BY RideName ASC
- WHERE MinHeight ASC
Model answer
ORDER BY MinHeight ASC
Explanation
ASC sorts from the smallest value to the largest, so Monkey Mayhem (90 cm) would be listed first and Sky Spinner (140 cm) last. DESC would put the highest minimum height first, ORDER BY RideName sorts alphabetically by name, and WHERE is used to filter records, not to sort them.
Mark scheme
-
1 mark
ORDER BY MinHeight ASC
Mark is for AO2 (apply). If more than one option is given, 0 marks.