Using the following tables write SQL queries for questions 1-4. STAR (StarN

Using the following tables write SQL queries for questions 1-4.

STAR (StarNo StarName BirthPlace StarBorn)

MOVIE (MovieNo MovieTitle YearMade MType Crit MPAA Noms Award DirNo)

MOVSTAR ( MovieNo StarNo)

MEMBER ( MMBNo MMBName MMBAddr MMBCty MMBSt NumRent Bonus JoinDate)

DIRECTOR (DirNo DirName DirBorn)

TAPE (TapeNo MovieNo PurDate TimesRent MMBNo)

1. List the DirNo and StarNo who were associated with the same number of movies. List also the number of movies for each DirNo StarNo pair.

2. List MMBName of the member who joined the earliest.

3. List DirNo of director(s) who have not directed any comedy movie.

4. List the titles of movies that belong to the MType with the most number of movies.