(Solved): WPC 300 Hands On Assignment - 7 Total score: 25 out of 25 points...
Hands On Assignment - 7
Maximum points: 25
Go to: sql.wpc-is.online
Create a word document and provide screenshots of all SQL queries and the corresponding results while answering the following questions. Use the “Sakila” sample database to answer all the questions using an appropriate single SQL query in each case. For each question, you must show the 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.
- How many films are there in the database with a PG rating? Show one screen shot (with partial list of films) to support your finding. [2.5 pts]
2. List the first name and last name of all actors that have their first name “Julia”. [2.5 pts]
3. What is the longest duration of the movies in the database? List film(s) that have that longest duration [2.5 pts]
- Count the number films for each film rating and show them in a table? [2.5 pts]
- List the names of the actors whose first name start with the letter “C” [2.5 pts]
- List the film titles that have a replacement cost of more than $29. Show one screen shot (with partial list of titles) to support your finding. [2.5 pts]
- How many customers are inactive (active=0) in the database? Show the list of their first and last name. [2.5 pts]
- How many films are there with special feature included on the DVD only as “Trailers”? Show one screen shot (with partial list of titles) to support your finding. [2.5 pts]
What was the total payment amount processed by staff member Jon Stephens? [2.5 pts]
How many non-English movie titles are there in the database? [2.5 pts]