(Solved): WPC 300: Hands On Assignment - 7 | Oct 2020 Update | Maximum points: 30...

WPC 300
Hands On Assignment - 7
Maximum points: 30

October 2020 Update: includes screenshots
 

Question 1                                         3 pts 
How many films are there in the database with a PG rating, 

• 108
• 94
• 194
• None of the answer selections are correct 

Question 2                                        3 pts 
List the first name and last name of all actors that have their first name "Julia". Submit a screenshot of the query results. 
 Upload     Choose a File  

Question 3                                         3 pts 
What is the SQL query to find the longest duration of the movies in the database? 

• Select title, length from film order by desc;
• Select film, title order by length desc; 
• Select title , title film desc; 
• Select title, length from film order by length desc; 

Question 4                                      3 pts 
Count the number films for each film rating and show them in a table? Submit a screenshot of the query results. 
Upload             Choose a File 

Question 5                                   3 pts 
Which of the following names in the database is an actor whose first name start with the letter "C"? 

• Cameron Hunt
• Cuba Olivier
• Chris Berry
• Charly Wray 

Question 6                                  3 pts 
How many film titles are there in the database that have a replacement cost of more than $29? 

• 59
• 32
• 53 
• 34 

Question 7                      3 pts 
How many customers are inactive in the database? (Hint: Use active = 0 to count inactive customers) 

• 51
• 43
• 31
• 15 

Question 8                          3 pts 
How many films are there with special feature included on the DVD only as "Trailers"? 

• 34 
• 54 
• 27 
• 72 

Question 9                          3 pts 
What query would you use to compute the total payment processed by staff member, Jon Stephens? 

• from payment, select sum(amount) where payment_id=2
• none of the answers selects are correct
• select payment, select sum(amount) where payment.staff_id=2;
• select sum(amount) from payment where payment. staff_id=2;

Question 10                    3 pts 
How many non-English movie titles are there in the database? 

• 10
• 21
• None of the answer selections are correct 
• 0