Skip to content
Intermediate SQL
  • AI Chat
  • Code
  • Report

    • Intermediate SQL

    Here you can access every table used in the course. To access each table, you will need to specify the cinema schema in your queries (e.g., cinema.reviews for the reviews table.

    Spinner
    DataFrameavailable as
    df
    variable
    /*-- Which titles in the `reviews` table have an IMDB score higher than 8.5?
SELECT film_id
FROM cinema.reviews
WHERE imdb_score > 8.5; */


/*--Select all titles from Germany released after 2010 from the `films` table.
SELECT title
FROM cinema.films
WHERE country = 'Germany' AND release_year > 2010; */


/*--Calculate a count of all movies by country using the `films` table.
SELECT COUNT(country)
FROM cinema.films; */