Select Statements

SELECT COUNT(*),
    CASE
        WHEN population > 69785627.0800 THEN "Above Average Pop"
        ELSE "Below Average Pop"
    END AS def_of_avgPop
FROM countries_by_population
GROUP BY def_of_avgPop