Database: dog_kennels
Question: How many dogs have an age below the average?
SQL:
SELECT count(*) FROM Dogs WHERE age  <  ( SELECT avg(age) FROM Dogs )