PROJECT WITH TSQL

User database NETFLIX Analysic data with question:

1. The Minimum length of films
2. The Total revenue of company
3. Number of films for rend in company
4. What are the different ratings of films. Kind of ratings
5. Number of films with length between 60 and 90 min
6. Number of film rentals by customer “Jennifer Davis”
7. Number of rentals for each film
8. Number of films per rating, sort resulset using descending order by counted films
9. Number of films per category
10. Show categories which include over 60 movies
11. Sort films which have a length > 170 minutes, along rating ASC and length DESC
12. Who are the actors who acted the most movie
13. Number of customers per city per country
14. Total revenue per month and year
15. Total revenue per film category
16. What Number of films rented over 30 times
17. What (best sellers) the most rented film(s)
18. What films rented over the average number of rentals
19. Show customer_id and email of Canadian customers
20. Show films which length >= 184 minutes

Link nộp bài: Public