(Solved): WPC 300 Homework Assignment HOA-7 Mysql Assignment...
WPC 300
Hands on Assignment-7
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:
- 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] 194 films with PG rating
- List the first name and last name of all actors that have their first name “Julia”. [2.5 pts]
- What is the longest duration of the movies in the database? List film(s) that have that longest duration [2.5 pts]
- The longest duration is 185
- 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]
Expert Answer
WPC 300
Hands on Assignment-7
Maximum points: 25
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:
- 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]
- List the first name and last name of all actors that have their first name “Julia”. [2.5 pts
- 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]
33927.04
- How many non-English movie titles are there in the database? [2.5 pts]
Buy This Answer $15
-- OR --
Subscribe $20 / Month