  select title, count(rents.videoid) as manyrented from video, rents where
  rents.videoid=video.vid
  group by title having count(rents.videoid)>0
  order by title;  