Have a Question ?

Home / Answered Questions / WPC 300 / wpc-300-hands-on-assignment-7-oct-2020-update-maximum-points-25-q-937

(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


We have an Answer from Expert View Expert Answer

Expert Answer


We have an Answer from Expert
Buy This Answer $15

-- OR --

Subscribe To View Unlimited Answers
Subscribe $12 / Month