Answers for "in movie database display the actor name who has not acted in any movie"

SQL
0

movie database sql queries

`select Title 
   from Movie m 
   JOIN
   (select MovieID, Rating 
   from Ratings 
   order by
   Rating)
   as r on 
   m.MovieID = r.MovieID
   limit 20;`
Posted by: Guest on September-19-2020
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

Code answers related to "SQL"

Browse Popular Code Answers by Language