Skip to content

Instantly share code, notes, and snippets.

@backpackerhh
backpackerhh / core-set.sql
Last active March 17, 2024 05:03
SQL - Movie-Rating Query Exercises
-- 1. Find the titles of all movies directed by Steven Spielberg.
SELECT title
FROM Movie
WHERE director = 'Steven Spielberg';
-- 2. Find all years that have a movie that received a rating of 4 or 5, and sort them in increasing order.
SELECT DISTINCT year