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)