SQL Tasks
⚡ You can solve SQL problems as a guest or log in with your Google account!
1 Get Oscar Movie Titles
Retrieve only the title of every movie in the oscar_movies table.
2 Get Oscar Movie Directors
Retrieve only the director of every movie in the oscar_movies table.
3 View All Oscar Movie Data
Retrieve all information about each Oscar movie using the asterisk wildcard.
4 Choose Three Columns
Retrieve the title, genre, and year of each Oscar movie.
5 Pick Two Columns
Retrieve both the title and director of each Oscar movie.
1 Movies After 2000
Find all movies released after the year 2000.
2 Find Specific Director
Find the movie with the director 'James Cameron'.
3 Exclude Certain Years
Find Oscar Movies with release years not between 1995 and 2007.
4 Movies Between Years
Find movies that won Oscars between 2000 and 2013.
5 Drama Movies Only
Find all movies that belong to the genre 'Drama' and were released after 2000.
1 Sort Movies Alphabetically
List the first five movies alphabetically by title.
2 Find Unique Directors
List all unique directors in the oscar_movies table.
3 Skip and Show Movies
Show the next five movies in alphabetical order after skipping the first 5.
4 Get Top Movies Only
Show only the first 3 movies when sorted by title.
5 Sort Movies by Newest
Show the last four movies released, starting with the newest one.
1 Find Old Universities
Find all universities founded before 1850.
2 Get University Countries
Retrieve only the country of every university in the top_universities table.
3 UK Universities Only
Show all UK universities with more than 20,000 students, sorted by student count from largest to smallest.
4 Largest Universities
Find the 3 universities with the most students, showing their name, country, and student count.
5 List Unique Countries
Show all unique countries that have top universities, sorted alphabetically.
1 Find UK Author Books
Find all books written by authors from the UK, showing the book title and author's last name.
2 Show Books with Authors
Retrieve the title of each book along with the author's first and last name.
3 Recent Books Only
Show the 5 most recently published books with author last names, sorted from newest to oldest.
4 Sort Books by Author Country
Display book titles with author names, sorted alphabetically by the author's country.
5 Get Book Publication Details
Show the book title, author's full name, and publication year for all books.