SQL fails in so many ways to support the relational model adequately—it suffers from so many sins of both omission and commission … Here are a few: duplicate rows, nulls, left-to-right column ordering, … – CJ Date, An Interview with Chris Date, July, 2005, O’Reilly.

As in the last unit, work through the following materials writing one sample query for each mechanism using the modified version of the movies database (see code/06sql/guide06.sql).

  1. Advanced SQL (Section 7.1, continued) — Write sample queries that:

    1. Implement an inner join (Section 7.1.6).

    2. Implement an outer join (Section 7.1.6).

    3. Use an aggregate function (Section 7.1.7).

    4. Use grouping (Section 7.1.8).