Write the following queries in SQL

1) List all movieIDs and movie titles. If the movie is playing in a movie theater, also list the theater's ID and the show date.

2) For each theaterID, find the number of different movies that are playing at that theater on 11 / 9 / 2018. The user is only interested in information about theaters that are playing more than three movies on 11 / 9. (List both theater IDs and counts of movies in output.)

USE SIMPLIFYING ASSUMPTIONS THAT comparisons on "date" or "timestamp fields WORTH WITH basic, etc. boolean operators. This is not the case in many DBMS products