Scenario:

EliteVideo is a startup company providing concierge DVD kiosk service in Kennesaw, GA.

For each problem, you need:

1. the problem statement

2. the SQL query that solved the problem

1) List the names of all members that rented a video.

2) List the name of all movies that had a video indate of March 2, 2018. Sort by movie title.

3) List the details (member names, date rented, rental fee and due date) for every rental.

4) List the movie title for all new releases

5) What movies are currently at a standard price or discounted?

6) List all members [last name] and date they rented a movie but also include those who have never rented a movie.

7) How many video copies of Time to Burn does EliteVideo have?

8) How many video copies of each movie (list the name) does EliteVideo have?

9) List name of members and the movie titles they

10) What movie(s) did Lewis Rosales rent?

11) What were the total rental fees for each member by mem_number

12) What were the total rental fees for each member by member last name?

13) What were the total rental fees for members {report Mem_num} who total fees were greater than $5 change the output label to FeesMoreThan5$

14) What was the highest fee paid by each member [report last name and fee].

15) What are the movie titles, due dates and return dates for movies that have not been returned?

*** You only need the SQL statements

FIGURE P8.47 THE CH08MOVIECO ERD DETAILRENTAL MEMBERSHIP RENTAL PK,FK1 PK,FK2 | RENT NUM VIDNUM PK RENT NUM MEM FNAME H MEM LNAME MEM_STREET MEM CITY MEM STATE MEM ZIP MEM BALANCE DETAIL FEE DETAIL DUEDATE DETAIL RETURNDATE DETAIL DAILYLATEFEE RENT DATE FK1 MEM NUM MOVIE VIDEO PK MOVIE NUM PK VID NUM PRICE VID INDATE FKI | MOVIE NUM MOVIE TITLE MOVIE YEAR MOVIE COST MOVIE GENRE PK PRICE CODE PRICE DESCRIPTION PRICE RENTFEE PRICE_DAILYLATEFEE FK1 PRICE CODE FIGURE P8.47 THE CH08MOVIECO ERD DETAILRENTAL MEMBERSHIP RENTAL PK,FK1 PK,FK2 | RENT NUM VIDNUM PK RENT NUM MEM FNAME H MEM LNAME MEM_STREET MEM CITY MEM STATE MEM ZIP MEM BALANCE DETAIL FEE DETAIL DUEDATE DETAIL RETURNDATE DETAIL DAILYLATEFEE RENT DATE FK1 MEM NUM MOVIE VIDEO PK MOVIE NUM PK VID NUM PRICE VID INDATE FKI | MOVIE NUM MOVIE TITLE MOVIE YEAR MOVIE COST MOVIE GENRE PK PRICE CODE PRICE DESCRIPTION PRICE RENTFEE PRICE_DAILYLATEFEE FK1 PRICE CODE