12.5 LAB - Select tall horses with subquery The Horse table has the following columns:
• ID - integer, primary key
• RegisteredName - variable-length string
• Breed - variable-length string
• Height - decimal number
• BirthDate - date
Write a SELECT statement to select the registered name and height for only horses that have an above average height Order the results by
height.
Hint: Use a subquery to find the average height.
365686 24095363
LAB
ACTIVITY
12.5.1: LAB - Select tall horses with subquery
5/10
Main. sal
Load default template
1 -- Your SQL statements go here
2 SELECT RegisteredName, Height
3 FROM Horse
WHERE Height>
(SELECT AVG (Height)
FROM Horse
ORDER BY Height);