Database Exercises
Sakila database/t3
  1. List all films (title) and their length.
  2. List the first and last names of actors in alphabetical order.
  3. Show all films with a rental duration greater than 5 days.
  4. Find all customers with the first name 'John'.
  5. Display all films (title) in the 'Action' category.
  6. List all actors and the films they appeared in.
  7. Display customers and the staff members assigned to them.
  8. List all categories and the number of films in each category.
  9. List all customers and their rentals.
  10. Display all film rentals, including customer names and film titles.
  11. Calculate the average rental duration of all films.
  12. Show the number of customers for each city.
  13. Count the number of films rented by each staff member.
  14. Count the number of rentals for each customer and order them in descending order.
  15. Display the average length of films in each category.
  16. Find films longer than the average film length.
  17. List customers who have not made any rentals.
  18. Find films with more than 5 copies available for rent.
  19. Show categories that have more than 30 films.
  20. List customers who have made more than 20 rentals.
  21. Add a new customer 'Jane Doe' to store 1.
  22. Update all films with a rental duration of more than 7 days to 7 days.
  23. Add a new film 'The Great Adventure' with a 3-day rental duration.
  24. Update a customer's address when they move to a new address.
  25. Delete customers who have made no rentals.
  26. List all films that do not belong to any category.
  27. Show the total rental revenue for each category.
  28. Calculate the total length of all films.
  29. List staff members who have handled at least one rental.
  30. Find customers who made a rental on a specific date (e.g., '2005-05-31').



Toggle Menu

Copyright © Pekka Alaluukas / 2024
email