Have a Question ?

Home / Answered Questions / WPC 300 / wpc-300-assignment-assignment-2-q-375

(Solved): WPC 300 Assignment|Assignment 2...


 

 

WPC 300 (Hybrid Course)

Assignment-2

Maximum points: 25


October 2020 update is HERE click to view 


                           

Student Name:  _[Mary Alfansha ]___________________ Class Day &Time:__[Monday & 9.15 AM]_
 

Go to:  sql.wpc-is.online

UserName: wpc300student

Password: Da7aB8isGr8!

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.

Questions:

  1. 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]
  4. Count the number films for each film rating and show them in a table?  [2.5 pts]
  5. List the names of the actors whose first name start with the letter “C”  [2.5 pts]
  6. 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]
  7. How many customers are inactive (active=0) in the database? Show the list of their first and last name. [2.5 pts]
  8. 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]
  9. What was the total payment amount processed by staff member Jon Stephens? [2.5 pts]
  10. How many non-English movie titles are there in the database? [2.5 pts]


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 $20 / Month