I am trying to List cheapest prices for each movie including the distributors He

Question

I am trying to List cheapest prices for each movie including the distributors Here's what I have so far. Please let me know what I'm missing. select distinct movies.title, movie_distributors.distributor_name, Min(unit_price) as lowest_price from movies inner join distributed_movie_list on movies.MOVIE_ID = distributed_movie_list.movie_id inner join movie_distributors on distributed_movie_list.distributor_id = movie_distributors.distributor_id where distributed_movie_list.movie_id = movies.movie_id and distributed_movie_list.distributor_id = movie_distributors.distributor_id group by movies.title, movie_distributors.distributor_name;

Explanation / Answer

the on is missing in your sql syntax and grup by clause is not required in this case.

Below query should give you the correct result:

select distinct movies.title, movie_distributors.distributor_name, Min(unit_price) as lowest_price from movies
inner join on distributed_movie_list on movies.MOVIE_ID = distributed_movie_list.movie_id
inner join on movie_distributors on distributed_movie_list.distributor_id = movie_distributors.distributor_id
where distributed_movie_list.movie_id = movies.MOVIE_ID and distributed_movie_list.distributor_id = movie_distributors.distributor_id;

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.