ShubhamS32

# Write a query in SQL to find the name of all reviewers who have rated their ratings with a NULL value.
select rev_name from reviewer , rating
where reviewer.rev_id = rating.rev_id
and rev_stars IS NULL;

#Write a query in SQL to list the first and last names of all the actors who were cast in the 
#movie 'Annie Hall', and the roles they played in that production.
select a.act_fname ,a.act_lname , mc.role
from actor a , movie_cast mc , movie m 
where m.mov_id = mc.mov_id