QUESTION 1
-----------------------------
Rewrite the query in Question 4.1.2 using the EXISTS operator.


-----------------------------
QUESTION 2

The question below and all other questions are regarding the OMDB database as described in Assignment 2. Write one SQL query for the question below and questions 4.1.2 and 4.1.3.

Are there any members who do not have an email address? Return the total count of such members.

-----------------------------
QUESTION 3

Explain the following query in English.
select *
from Actor A1
where birthplace='Mexico'
    and actorID in (select actorID
      from Cast
      where mvid <> all (select mvid
        from MovieInfo
        where studio='Paramount Picture'));


-----------------------------
QUESTION 4

Are there any directors with the same name. List the directorID and name of these directors. Your output should not have redundant information. You must write a join query.


-----------------------------
QUESTION 5

Fix the syntax errors in the SQL query below and explain the query in English.
select *
from movieinfo natural join cast
where mvid not in (sleet *
	from genre);