SQL Tasks

Find all movies released after the year 2000.

Find the movie with the director 'James Cameron'.

Find movies that won Oscars between 2000 and 2013.

Find all movies that belong to the genre 'Drama' and were released after 2000.

Find Oscar Movies with release years not between 1995 and 2007.

List the first five movies alphabetically by title.

Show only the first 3 movies when sorted by title.

List all unique directors in the oscar_movies table.

Show the last four movies released, starting with the newest one.

Show the next five movies in alphabetical order after skipping the first 5.

Find all universities founded before 1850.

Show all UK universities with more than 20,000 students, sorted by student count from largest to smallest.

Show all unique countries that have top universities, sorted alphabetically.

Retrieve only the country of every university in the top_universities table.

Find the 3 universities with the most students, showing their name, country, and student count.

Retrieve the title of each book along with the author's first and last name.

Show the book title, author's full name, and publication year for all books.

Find all books written by authors from the UK, showing the book title and author's last name.

Show the 5 most recently published books with author last names, sorted from newest to oldest.

Display book titles with author names, sorted alphabetically by the author's country.

Find all orders that don't have company information assigned, showing order number and amount.

Display every company along with their orders. Include companies even if they haven't placed any orders.

Show each company's name and the total count of their orders, including companies with zero orders.

Find all companies that haven't placed any orders yet, showing only company names and industries.

Display every order with company information. Include orders even if company data is missing.

Show order amounts in USD and convert to Euros using exchange rate 0.85.

Display company names in original format, uppercase format, and lowercase format using aliases.

Show order numbers with their original amounts and calculated amounts including 10% tax.

Show company names, countries, order numbers, and order amounts using table aliases (c for companies, o for orders).

Show company names and calculate how many years old each company is (use 2025 as current year).

Find the highest and lowest individual product prices in the sales data.

Find the average quantity of items sold per transaction.

Show total sales count, total revenue, average price, minimum quantity, and maximum quantity in one query.

Calculate the total revenue by multiplying quantity by price for all sales.

Find the total number of sales transactions in the database.

Show each customer region and the total number of sales in that region.

Find product categories that have more than 5 total sales, showing category name and sales count.

Display each product category and its total revenue (quantity × price) using data from both tables.

Show each customer region with the average sale amount (quantity × price) for that region.

Show suppliers with total profit over $1000, displaying supplier name, country, and total profit (selling price - cost price).