This is an individual assignment
Create a word document and provide screenshots of all SQL queries and the corresponding results while
answering the following 10 questions. Use the “Sakila” sample database to answer all the questions
using appropriate SQL queries. For each question, you must show the correct SQL query and the
screenshot of the results from your SQL query (similar to what you see on your lab handout) to
receive full credit.
1. How many PG rating films are there in the database? List their titles. [10 pts]
Solution:
2. List first name and last name of all actors that have their first name “Julia”. [10 pts]
Solution
3. Which film(s) in the database has (have) the longest duration? What is the longest duration?
[10 pts]
Solution
4. How many films are there in the database for each film rating? [10 pts] List them.
Solution
5. Name the actors whose first name start with letter “C” [10 pts]
Solution:
6. How many films are there in the database that have their replacement cost more than $29? List
the titles and their replacement cost. [10 pts]
Solution
7. How many customers are inactive (0) in the database? List their first and last name. [10 pts]
Solution
8. How many film titles are there in the database with special feature included on the DVD as
“Trailers”? List these titles. [10 pts]
Solution:
9. What was the total payment processed by staff member, Jon Stephens? [10 pts]
Solution
10. How many non-English movie titles are there in the database? [10 pts]