database for movie in sql queries 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 Title from Movie m  
inner join (select top 20 MovieID,sum(Rating) Rate from Ratings group by movieid having count(UserID)>39 order by sum(Rating) DESC) tbl
on m.MovieID=tbl.MovieID
order by tbl.Rate desc

Tags:

Sql Example

Related