sql code for movie database code example

Example 1: movie database sql queries

select first_name,last_name
  from stars_in_movies inner join stars
 where movie_id=%s and star_id=id;

Example 2: movie database sql queries

select first_name,last_name
  from stars_in_movies inner join stars
 where (movie_id=%s and movie_id=%y) and star_id=id;