3. The Student database has the following Relation Schema:

• PRICE (Code, Description, RentFee, DailyFee)
• MOVIE (MovieNo, Title, Year, Cost, Genre, Code)\
• VIDEO (VideoNo, InDate, MovieNo)
• DETAILRENTAL (RentNo, VideoNo, Fee, DueDate, ReturnDate, DailyFee)
• MEMBERSHIP (MemberID, Name, City, State, Balance)
• RENTAL (RentNo, Date, MemberID)

Using the above schema, write SQL queries that will answer/process the following:

1. Find the movies which cost more than the average movie cost. Show movie title, year and cost. Append the dollar sign ($) at the beginning of the movie cost. (2 marks)

2. Find the price type which has the maximum number of movies. Show price code, price description and the number of movies of that type. (2 marks)

3. View to show all the members and movies they rented. Show movie title, dates of rent, due and return. (4 marks)