REVIEW 1

SQL (Core) - SQL Review: Simple SELECT Queries

Prereq: None | Progress: 0%

SQL Review: Simple SELECT Queries

Put your SELECT, WHERE, ORDER BY, and LIMIT skills to work on a real-world dataset: north_american_cities.

SELECT column, another_column FROM mytable WHERE condition(s) ORDER BY column ASC/DESC LIMIT num_limit OFFSET num_offset;

💡

Expressions can save post-processing time. Use clear aliases like AS gross_sales_millions so output columns are self-explanatory.

› north_american_cities

☐ 1. List all the Canadian cities and their populations

☐ 2. Order all the cities in the United States by their latitude from north to south

☐ 3. List all the cities west of Chicago, ordered from west to east

☐ 4. List the two largest cities in Mexico (by population)

☐ 5. List the third and fourth largest cities (by population) in the United States and their population

⚡ Practice Console

SELECT * FROM movies;

No results. Run query to fetch data.

5 rows