SELECT count(*) FROM Dogs WHERE age  <  ( SELECT avg(age) FROM Dogs )
How many dogs have an age below the average?
SELECT count ( * ) FROM Dogs WHERE age < ( SELECT avg ( age ) FROM Dogs )
select count ( * ) from dogs where age < ( select avg ( age ) from dogs )
How many dogs have an age below the average ?