SQL Tasks

⚡ Log in to become a Top User by solving SQL problems!

Lesson 1 - Task 1

Find a title from every Oscar movie.

Try it Yourself
Lesson 1 - Task 2

Find the genre of every movie.

Try it Yourself
Lesson 1 - Task 3

Find the title and genre of each movie.

Try it Yourself
Lesson 1 - Task 4

Find all the information about each Oscar movie.

Try it Yourself
Lesson 1 - Task 5

Find the title and director of each movie.

Try it Yourself
Lesson 1 - Task 6

Find the movies that are longer than 150 minutes.

Try it Yourself
Lesson 2 - Task 1

Find the movie with the director is ‘James Cameron’

Try it Yourself
Lesson 2 - Task 2

Find movies that won Oscars in years between 2000 and 2013

Try it Yourself
Lesson 2 - Task 3

Find movies which years not between 1995 and 2007

Try it Yourself
Lesson 2 - Task 4

Find all films from years between 2000 and 2013, and length_minutes more than 2 hours

Try it Yourself
Lesson 2 - Task 5

Find all the information about the first 5 Oscar movies

Try it Yourself
Lesson 2 - Task 6

Find movies that belong only to the genre 'Drama' and year > 2000

Try it Yourself
Lesson 3 - Task 1

List all unique directors. Goal: Retrieve a list of all directors in the table, ensuring there are no duplicates and …

Try it Yourself
Lesson 3 - Task 2

Show the last four movies released. Goal: Return the 4 most recent Oscar-winning movies, starting with the newest one.

Try it Yourself
Lesson 3 - Task 3

List the first five movies alphabetically. Goal: Show the first 5 movie titles in alphabetical order.

Try it Yourself
Lesson 3 - Task 4

Show the next five movies in alphabetical order. Goal: Skip the first 5 titles (alphabetically) and return the next 5.

Try it Yourself
Lesson 3 - Task 5

Return the longest movie by runtime. Goal: Find the movie and its runtime with the longest duration.

Try it Yourself
Lesson 3 - Task 6

List all unique release years. Goal: Display a list of all years in which Oscar-winning movies from the table were …

Try it Yourself