Sensorial Intake
SELECT MV.venue_id, MV.title, COUNT(M.title_id) as movies_seen FROM movie_venues MV LEFT JOIN movies M USING(venue_id) WHERE MV.venue_id = GROUP BY MV.venue_id