Answers for "movie database sql"

SQL
0

movie database sql queries

select director -- directors who have worked with star X
from movies
where movie_id in
(
    select movie_id  --All movies in which star X has acted
    from stars_in_movies
    where star_id = "X"
)
Posted by: Guest on September-19-2020
0

movie database sql queries

select Title from Movie m JOIN 
(select MovieID, Rating from Ratings order by Rating DESC limit 20) as r
on m.MovieID = r.MovieID;
Posted by: Guest on September-19-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language