SELECT count(*) ,  gender FROM Person WHERE age  <  40 GROUP BY gender
How many people are under 40 for each gender?
SELECT count ( * ) , gender FROM Person WHERE age < 40 GROUP BY gender
select count ( * ) , gender from person where age < value group by gender
How many people are under 40 for each gender ?