New entry about database

Problem 2

Consider the following schema of a video-rental enterprise:

Member (m-ID, m-Name, m-city, age);

Movie ( movie-Title, director-ID, movie-Year, movieGenre );

Director( director-ID, dir-Name, dir-city);

Rents( movie-Title, m-ID, dateBorrowed, dateReturned);

Write the respective SQL statement for processing each of the following queries:

Q1: What is the average age of the members in each city;

Q2: Retrieve the names of all the customers who are older than 25 years and have borrowed movies directed by Spielberg.

Q3: Find the total number of movies directed by each director who lives in New York.

Q4: Retrieve the names of the members from Chicago who have rented all the movies directed by Coppola after 1970.