Database: dog_kennels
Question: Count the number of dogs of an age below the average.
SQL:
SELECT count(*) FROM Dogs WHERE age  <  ( SELECT avg(age) FROM Dogs )