Question: write SQL queries to answer the following questions. All questions pertain to our movies database 1. How many people are in the database? 2.What is

write SQL queries to answer the following questions. All questions pertain to our movies database

1. How many people are in the database?

2.What is the average age of people in the database?

3. Who is the youngest person in the database? 4. How many films were released in 2019? 5.What was the average gross of movies released between 2010 and 2019 (including 2010 and 2019)?

6. How many actors have played the role of Mufasa?

7.What is the average age of female directors and actresses in the database?

Bonus function 1. Write a query that calculates someone's age without using the defined "AGE)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

link for more detail on database below: http://sqlzoo.net/wiki/More_JOIN_operations Data Sciences SQL Test 1. You will have 2 hours to complete this test. At the end of the 2 hours, please send all...

Database Section A Application-Based Question(s) 50 Marks S Question 1 Oracle databases use structured query language (SQL) for writing and querying data. Consider the Table 1 below: Table 1:...

1. Based on the tables we used in SQL Exercise Part 3 (i.e., CEOs, Companies, Countries), write SQL queries to answer the following questions. Please include both your SQL query and result...

mysql questions. All questions are linked. Even if the pictures are blurry please help write the commands for the questions at least QUNSTION: Pandai Sdn Bhd is a company that runs a tuition center...

LQuery-Spring 2018 Extra Credit (Protected View)- Word This is an extra credit assignment, which is designed to let you have a hands-on experience writing advanced SQL query statements -subqueries...

Write SQL queries that answer the following questions. Make sure you compose a query that does not use literal values determined by perusing the tuples. Also, remember some queries may generate an...

/* Database Systems, Coronel/Morris */ /* Type of SQL : MySQL */ Drop schema if exists sales; Create schema Sales; Use sales; DROP TABLE IF EXISTS vendor; CREATE TABLE VENDOR ( `V_CODE` int not null,...

Using the James River database, write SQL scripts to answer the following questions: List all the customers in Alphabetical Order Create a distinct list of artists - First and Last Names How many...

I do not understand what needs to be done, I've tried to watch the video with no luck. can you help, please? import into MysqL 2A. Under Server Administration on the Home window select the server...

Hudson: Lisa: Fred: Jake: We've made a lot of progress researching various ERP vendors. However, ERP software for car dealerships is still fairly expensive for a small dealership like ours. Combine...

The controller for Dohini Manufacturing Company felt that the number of purchase orders alone did not explain the monthly purchasing cost. He knew that nonstandard orders (for example, one requiring...

Presented below are a set of financial ratios provided for Recharge Ltd. The company manufactures cycle components to put on racing cycles. Return on Assets Return on Equity Debt to Assets Days...

Coronado Manufacturing is in the process of setting a selling price on a new product it has just developed. The following data is available from the accounting department based on a budgeted volume...

The session met stated objectives. True False

C If you were a member of the city council, would you have reacted to the story differently if the speaker had presented it as a thirdhand account? Why or why not?

D How will your group react to this revelation?

Do you think that Jolies focus on resilience and individuals would be as crucial in a more collectivist culture?