For the questions below, consider the following schema used in a DVD store.
DVDs(Did, title, dname, rating, pstudio, resolution)
Customer(Cid, name, address, age, balance)
Rented(Cid, Did)
Most attributes are self-explanatory. dname is the director who directed the given title/movie. pstudio is the production studio that made the movie. resolution is 720p or 1080p (stored as varchar).
Write the following queries in SQL:
a. Find the DVD titles released by Miramax that are available in both the 720p and 1080p resolution.
b. Find the DVD IDs (Did) of those titles that have not been rented at all.
c. Find the titles of 1080p DVDs that have been rented by all the customers.