Question: Write a query to display the rental number, rental date, video number, movie title, due date, and return date for all videos that were returned

Write a query to display the rental number, rental date, video number, movie title, due date, and return date for all videos that were returned after the due date. Sort the results by rental number and movie title (result shown inFigure).

Rent Num |Rent Date Vid Num Movie Title Detail DueDate Detail ReturnDate 1003 02-Mar13 54325 The Cesar Family Christmas 1003 02-Mar-13 61369 What He Doesnt Know 1003 02-Mar13 61388 Where Hope Dies 004 02-Mar-13 44392 Beatnik Fever 1004 02-Mar-13 34367 Richard Goodhope 04-Mar-13 06-Mar-13 06-Mar-13 05-Mar-13 05-Mar-13 09-Mar-13 09-Mar-13 09-Mar-13 07-Mar-13 07-Mar-13

Step by Step Solution

★★★★★

3.34 Rating (169 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

SELECT RENTALRENTNUM RENTDATE VIDEOVIDNUM MOVIETITLE ... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

358-CS-DB (663).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Write a query to display the minimum balance, maximum balance, and average balance for memberships that have a rental (result shown in FigureP7.92). Minimum Balance Maximum Balance Average Balance 15...

Write a query to display the membership number, last name, and total rental fees earned from that membership (result shown in Figure.). The total rental fee is the sum of all of the detail fees...

Write a query to display the first name, last name, street, city, state, and zip code of any customer who purchased a Foresters Best brand top coat between July 15, 2013, and July 31, 2013. If a...

Write a query to display the rental number, rental date, video number, movie title, due date, return date, detail fee, and number of days past the due date that the video was returned for each video...

Write a query to display the rental number, rental date, movie title, and detail fee for each movie that was returned on or before the due date (result shown in Figure). Rent Num Rent Date Movie...

PLZ help with the following: Using Oracle sql commands do the following Questions using subqueries CREATE TABLE MEMBERSHIP ( MEM_NUM CHAR(3) CONSTRAINT MEMBER_MEM_NUM_PK PRIMARY KEY, MEM_FNAME...

PLZ help with the following: using oracle sql command Use subqueries when necessary CREATE TABLE MEMBERSHIP ( MEM_NUM CHAR(3) CONSTRAINT MEMBER_MEM_NUM_PK PRIMARY KEY, MEM_FNAME VARCHAR(30) NOT NULL,...

PLZ help with the following: Using Oracle command sql Use Sub queries CREATE TABLE MEMBERSHIP ( MEM_NUM CHAR(3) CONSTRAINT MEMBER_MEMNUM_PK PRIMARY KEY, MEM_FNAME VARCHAR(30) NOT NULL, MEM_LNAME...

Answer the following SQL questions with the provided SQL script: a. Find all movies with a cost less than or equal to the average movies cost b. Write a query to display all the movies that have...

Begin for c in (select table_name from user_tables) loop execute immediate ('drop table '||c.table_name||' cascade constraints'); end loop; End; / CREATE TABLE MEMBERSHIP ( MEM_NUM CHAR(3) CONSTRAINT...

From each of the following pairs, choose the nuclide that is radioactive. (One is known to be radioactive, the other stable.) Explain your choice. a. b. c. 136

Bill Company and Ted Company both use predetermined overhead rates to apply manufacturing overhead to production. Bills is based on machine hours, and Teds is based on materials cost. Budgeted...

Given someone with a gross income of $ 1 2 0 , 0 0 0 and nondiscretionary expenses of $ 3 2 , 0 0 0 , discretionary expenses of $ 1 0 , 0 0 0 and capital expenditures on leisure items of $ 5 , 0 0 0...

9. a. These are the stages in the preparation of a salt from a metal carbonate, but they are in the wrong order. Arrange them correctly by numbering them in the order in which they occur. A Look for...

Victoria Ephanor manages a small product distribution company. Because the business is growing fast, Ephanor recognizes that it is time to manage the vast information pool to help guide the...

David Suker, the inventory manager for a marketing research company, wants to study the use of supplies within the different company departments. Suker has heard that his friend, Ephanor, has...

ROBCOR, Inc., whose sample data are contained in the database named Ch13_P4.mdb, provides "on demand" aviation charters using a mix of different aircraft and aircraft types. Because ROBCOR has grown...

Determine the increase or decrease in cash for Rinky Supply Company for last year, given the following information. (Assume no other changes occurred during the past year.) Decrease in marketable...

Chapter 9 homework 2. What value is in the dominator in each of the equations of the z and t test? Is this mathematically the only thing that is different between the two equations? 4. What does a...

A researcher wants to estimate the mean number of hours a college accounting graduate spends studying for the CPA exam. The researcher wants to be within 1.75 hours of the actual number. If she wants...