Table schema:
CREATE TABLE Dogs (age INTEGER)

Question: How many dogs have an age below the average?
SQL: SELECT COUNT(*) FROM Dogs WHERE age < (SELECT AVG(age) FROM Dogs)