select * from language order by language_id desc; select title, rating from movie; select movie_id from movie where star_rating = 5; select movie_id, sum(actor_payment) as Total Cost from movie_actor group by movie_id having sum(actor_payment) <50000 order by movie_id; select language_id, min(star_rating) as Min Star Rating from movie where rating = `PG` group by language_id; select t3.first_name, t3.last_name, t2.actor_payment from movie t1 JOIN movie_actor t2 JOIN actor t3 where t1.movie_id = t2.movie_id and t2.actor_id = t3.actor_id and t1.movie_id = 359 order by t3.first_name; select category_name from category where movie_id IN (select movie_id from movie_actor where actor_id = (select actor_id from actor where first_name = `Helen`)) group by category_name order by category_name; select t2.title, t2.rating, count( ) as `Number of Actors` from movie_actor t1 JOIN movie t2 ON t1.movie_id = t2.movie_id group by t1.movie_id having count( )>12 order by t2.rating asc, t2.title desc; select t2.movie_id as movie_id from actor t1 JOIN movie_actor t2 ON t1.actor_id = t2.actor_id where (first_name = Sandra and last_name = `Kilmer`) INTERSECT select t2.movie_id from actor t1 JOIN movie_actor t2 ON t1.actor_id = t2.actor_id where (first_name = Reese and last_name = `Kilmer`); select star_rating, length, title, rating from movie t1 where t1.length = ( select max(length) from movie t2 where t2.star_rating = t1.star_rating) order by star_rating;
©