Question: Using SQL Queries, obtain the next information The customers who rent more movies (TOP 20) The movies titles rented by the customer with more rents

Using SQL Queries, obtain the next information The customers who rent

Using SQL Queries, obtain the next information

The customers who rent more movies (TOP 20)

The movies titles rented by the customer with more rents

The movies titles that have never been rented

LANGUAGE LANGUAGE_ID NUMBER (22) PK NAME CHAR(20) LAST_UPDATE TIMESTAMP STAFF PAYMENT STAFF ID NUMBER(22) PK PAYMENT_ID NUMBER(22) PK FIRST NAME VARCHAR2(45) CUSTOMER_ID NUMBER(22) FK LAST_NAME VARCHAR2(45) STAFF ID NUMBER(22) FK ADDRESS_ID NUMBER(22) FK RENTAL_ID NUMBER (22) N FK PICTURE BLOB N AMOUNT NUMBER(52) EMAIL VARCHAR2(50) N to PAYMENT_DATE TIMESTAMP STORE_ID NUMBER(22) FK LAST_UPDATE TIMESTAMP ACTIVE NUMBER(22) USERNAME VARCHAR2(16) PASSWORD VARCHAR2(40) N LAST_UPDATE TIMESTAMP +6 INVENTORY INVENTORY_ID NUMBER(22) PK 0 FILM_ID NUMBER(22) FK STORE_ID NUMBER(22) FK LAST UPDATE TIMESTAMP RENTAL RENTAL_ID NUMBER(22) PK RENTAL_DATE TIMESTAMP INVENTORY_ID NUMBER(22) FK CUSTOMER_ID NUMBER(22) FK RETURN_DATE TIMESTAMP N STAFF_ID NUMBER (22) FK LAST_UPDATE TIMESTAMP FILM ACTOR ACTOR_ID NUMBER(22) FILM_ID NUMBER (22) PK PK CUSTOMER TITLE VARCHAR2(255) FIRST NAME VARCHAR2(45) CLOB LAST_NAME DESCRIPTION N VARCHAR2(45) STORE CUSTOMER_ID NUMBER(22) PK RELEASE_YEAR LAST UPDATE TIMESTAMP VARCHAR2(4) N STORE_ID NUMBER(22) FK LANGUAGE_ID NUMBER (22) FK STORE_ID NUMBER (22) PK FIRST NAME VARCHAR2(45) ORIGINAL_LANGUAGE_ID NUMBER (22) N FK MANAGER_STAFF_ID NUMBER (22) FK LAST_NAME VARCHAR2(45) RENTAL_DURATION NUMBER (22) ADDRESS_ID NUMBER (22) FK EMAIL VARCHAR2(50) N RENTAL_RATE NUMBER(4,2) LAST UPDATE TIMESTAMP ADDRESS_ID NUMBER(22) FK LENGTH NUMBER(22) N ACTIVE FILM_ACTOR CHAR(1) REPLACEMENT_COST oa NUMBER(5,2) CREATE_DATE DATE ACTOR_ID NUMBER(22) PK FK RATING VARCHAR2(10) N LAST_UPDATE TIMESTAMP FILM_ID NUMBER (22) PK FK SPECIAL FEATURES VARCHAR2(100) N LAST UPDATE TIMESTAMP SO HLAST_UPDATE TIMESTAMP ADDRESS ADDRESS_ID NUMBER (22) PK ADDRESS VARCHAR2(50) CITY ADDRESS VARCHAR2(50) N CITY_ID NUMBER(22) PK CATEGORY FILM_CATEGORY DISTRICT VARCHAR2(20) CITY VARCHAR2(50) CITY_ID NUMBER(22) FK CATEGORY_ID NUMBER (22) NUMBER(22) PK FK PKI FILM_ID COUNTRY_ID NUMBER(22) FK POSTAL_CODE VARCHAR2(10) N NAME CATEGORY_ID NUMBER (22) PK FK LAST UPDATE TIMESTAMP VARCHAR2(25) PHONE LAST_UPDATE TIMESTAMP VARCHAR2(20) LAST_UPDATE TIMESTAMP LAST_UPDATE TIMESTAMP COUNTRY COUNTRY_ID NUMBER(22) PK COUNTRY VARCHAR2(50) LAST_UPDATE TIMESTAMP N

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!

Deliverable 1 : Database system using Oracle DBMS Study the scenario and complete the questions that follow: Video Reservation Database System A local video rental service has contacted you to...

Study the scenario and complete the questions that follow: Video Reservation Database System A local video rental service has contacted you to develop a database to electronically facilitate a...

Video Reservation Database System A local video rental service has contacted you to develop a database to electronically facilitate a streamlined reservation and rental process. The database assist...

Study the scenario and complete the questions that follow: Video Reservation Database System A local video rental service has contacted you to develop a database to electronically facilitate a...

1 . 1 Data Definition Language operationsa. Using SQL queries, create the five ( 5 ) identified tables from the scenario including ALL related Primary and Foreign constraints where appropriate. ( 1 5...

Report Format: Your report should include: II. Executive Summary (1 page in length). The Executive Summary is a concise overview of the report. The Case Study Report should be written from the...

CASE 11 Netflix in 2012: Can It Recover from Its Strategy Missteps? Arthur A. Thompson The University of Alabama hroughout 2010 and the first six months of 2011, Netflix was on a roll. Movie...

Morton Company's contribution format income statement for last month is given below. Sales (47,000 units M $28 per unit) Variable expenses Contribution margin Fixed expenses $1,316,000 921, 200...

Note whether the aqueous solution of each of the following salts will be acidic, basic, or neutral. a. Na2S b. Cu(NO3)2 c. KClO4 d. CH3NH3Cl

Does one want a high or low value for the diffraction limit explain

Process Monitoring: From Figure A, if the main root cause of the problem has been identified originated from the blockage in pipe 3, can the problem be rectify directly by opening the valve 3?...

Explain why the following statements are false. a. The aggregate-demand curve slopes downward because it is the horizontal sum of the demand curves for individual goods. b. The long-run...

Suppose that the economy is currently in a recession. If policymakers take no action, how will the economy change over time? Explain in words and using an aggregate-demand/ aggregate-supply diagram.

Suppose the U.S. economy begins in long-run equilibrium. Concerns about global climate change cause the government to significantly restrict the production of electricity from fossil fuels. Because...