learning SQL with practice (sqlbolt.com)

Learning SQL (Day 1). Keeping it practical.

3 core things I learned today:

1. Filtering (WHERE)
   SELECT city FROM north_american_cities WHERE country = 'Canada';

2. Sorting (ORDER BY)
   SELECT city FROM north_american_cities ORDER BY population DESC;

3. Limiting results (LIMIT + OFFSET)
   SELECT city FROM north_american_cities ORDER BY population DESC LIMIT 2 OFFSET 2;

Key insight:
SQL is not hard — translating the problem correctly is the real skill.