Using MySQL SELECT commands answer the questions listed below. Your answers should produce the example results displayed after each question. Submit via the D2L drop box the final SQL script for each problem. All questions are worth 2 points each. The initial script for creating the schema used for this assignment is on D2L as Tiny Video. The schema name produced is tiny_video. A diagram can be found on the last page of this assignment. (Please note this is a different schema then your previous assignments)

1. Write a query to display the movie title, movie genre, price description, and price rental fee for all movies.

.

2.

Write a query to display the movie title and movie year for all movies that have a price.

3. Write a query to display the movie title, movie year, and movie cost for all movies that have a cost between $44.99 and $49.99.

4. Write a query to display the minimum balance, maximum balance, and average balance for memberships that have had a rental.

5. Write a query to display the membership name (concatenate the first name and last name with a space between them into a single column) membership address (concatenate the street, city, state, and zip code into a single column with spaces and commas in the appropriate spots as in the example below).

tite What He Doesn't Knovw COMEDY Standard The Cesar Family Christmas FAMILY Richard Goodhope Beatnik Fever Smokey Mountain Wildlife Where Hope Dies Time to Burn 2.50 4.00 DRAMA New Release 4.00 COMEDY New Release 4.00 2.00 2.00 2.00 New Release ACTION Discount DRAMA Discount