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;