Sorting and filtering

Select the first three episodes from every season of “IT Crowd”, except the first season.

Note

We assume that you already created tables in step Creating a table and populated them with data in step Adding data to a table.

SELECT
   series_id,
   season_id,
   episode_id,
   CAST(air_date AS Date) AS air_date, 
   title
FROM episodes
WHERE
   series_id = 1      -- List of conditions to build the result
   AND season_id > 1  -- Logical AND is used for complex conditions
ORDER BY              -- Sorting the results.
   series_id,         -- ORDER BY sorts the values by one or multiple
   season_id,         -- columns. Columns are separated by commas.
   episode_id
LIMIT 3               -- LIMIT N after ORDER BY means
                      -- "get top N" or "get bottom N" results,
;                     -- depending on sort order.
COMMIT;