Skip to content

Instantly share code, notes, and snippets.

View sheriffsaka's full-sized avatar

Saka Sheriff A. sheriffsaka

View GitHub Profile
@ShubhamS32
ShubhamS32 / Movie_Queries_1.sql
Last active February 17, 2023 13:54
Some Queries Based on Movie.sql
# 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