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 $($ascending$).$

Hint: Use a subquery to find the average height.

$539766\mathrm{.}3055218\mathrm{.}93zqy7$

LAB

ACTIVITY

$4\mathrm{.}11\mathrm{.}1$: LAB $-$ Select tall horses with subquery

$\frac{0}{10}$

Main.sql

Load default template...

$1--$ Your SQL statements go here