1. Learn
  2. /
  3. Projects
  4. /
  5. Applying SQL to Real-World Problems

Connected

Exercise

Using existing data

You are interested in identifying and storing information about films that are family-friendly. To do this, you will create a new table family_films using the data from the film table. This new table will contain a subset of films that have either the rating G or PG.

Instructions 1/2

undefined XP
    1
    2
  • Write a query to select all records & column from the film table which have a rating of G or PG.