Lesson 3 Practice Exercise Solutions

SELECT * FROM states WHERE pop2018 > 10000000;

SELECT * FROM cities WHERE capital = 1;

SELECT * FROM states WHERE name LIKE 'New%';

SELECT * FROM cities WHERE name LIKE '%z%';

SELECT * FROM states ORDER BY pop2018 DESC;

SELECT * FROM states ORDER BY sub_region, name;

SELECT * FROM states WHERE pop2018 > 10000000 AND sub_region = 'Pop';

SELECT * FROM cities WHERE stateabb IN ('US-NY','US-NJ','US-PA');

SELECT state, (white::double precision/total) * 100 AS pctwhite FROM census2020;

SELECT sub_region, Sum(pop2018) FROM states GROUP BY sub_region;

SELECT states.name, census2020.total, states.geom

    FROM states INNER JOIN census2020

    ON states.name = census2020.state;

SELECT states.sub_region, Avg(census2020.male)

    FROM states INNER JOIN census2020

    ON states.name = census2020.state

    GROUP BY states.sub_region;