Question: please using oracle sql!!! Use only the following tables: movie table movie_id title year budget gross plot_summary customer_target cust_id is_target genre genre_id name activity activity_id

please using oracle sql!!!

Use only the following tables: movie table

movie_id

title

year

budget

gross

plot_summary

customer_target

cust_id

is_target

genre

genre_id

name

activity

activity_id

name

movie_fact

cust_id

movie_id

genre_id

time_id

recommended

activity_id

rating

sales

1. What are the title and plot description of the movie that lost the most money? (How much money was lost is, to me, budget - gross.)

2. What is the name of one movie that has the most genres associated with it? Your query should take into account that several different movies

might have the same name.

3. What are the different genre names of the movie found in the previous question? Please assume that only one movie has this name.

4. For each possible genre, how many movies with that genre are there, and what is the gross amount for the top-grossing movie of that genre?

5. How many movies received ratings under two (or more) different genres from a given customer?

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!

please using oracle sql!!! thanks using movie_fact table 1.by invoking a PL/SQL stored procedure with an OUT parameter. The PL/SQL procedure is to use a cursor that scans through all rows in the fact...

Consider the Company Database given in the handout. This Database contains 6 relations, namely: EMPLOYEE, DEPARTMENT, DEPT_LOCATION, WORKS_ON, PROJECT and DEPENDENT. Each table is defined in the...

please do this on oracle live sql and show how to do it with final andwers. thank you Solmaris Condominium Group Use SQL to complete the following exercises. 1. Create a table named VACATION_UNIT....

I am using Oracle SQL and am new to it. I have seven tables, one of them is a subtable of two of the others. I need to do the following queries: 1. List all Patients and what Bed they are assigned to...

Please help with the following: PLZ help with the following: Using Oracle SQL Developper Or Oracle SQL LIVE Answer the following question. 1.Translate the ER diagram into a relational schema in the...

Regardless the kinds of information systems we propose, the chance is high that we will need a web presence (web site) to interact with end users, and back end database to process end users' request....

Directions:- Use SQL Server 2017 . See the images below and under TAL distributors write queries to perform steps 1 and 2 and 3. In Step 1 - name your table as Sales_Rep_Lastname. (The Last name in...

Using SQL complete Exercise 9 a. Wh -SOL for the following triggers en inserting a row in TAL PERSO the RESERVATION table, add the NUM PERSONS value to RESERVATIo value for the appropriate trip...

Use SQL and Colonial Adventure Tour database to complete the following Exercises SQL Functions and Procedures total number of persons for that the s in PL/SQL or T-SQL for the following triggers: e...

PLZ help with the following: Using Oracle SQL Developper Or Oracle SQL LIVE Answer the following question. For the following: The faculty and students (we refer to them in our system as clients) can...

Determine expressions for the impedance of the following admittances: (b) (0.001 -j0.002)S, S. (a) 0.004/30S, (c) (0.05+j0.08)

Comparative advantage watch the video outsourcing is bad for America. Navigate to the threaded discussion below and make your initial post, a. Define the terms globalization, comparative advantage,...

For an independent project, which of the following capital budgeting analysis techniques payback period, NPV , IRR or profitability index will always have the same accept / reject decision, and why....

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

12-5 As a manager or user of information systems, what would you need to know to participate in the design and use of a DSS or an ESS? Why?

12-2 How do information systems support the activities of managers and management decision making?

12-4 How do different decision-making constituencies in an organization use business intelligence, and what is the role of information systems in helping people working in a group make decisions more...