Sunday Movie

From WikiStuff

SELECT p.person, COUNT(m.picker) as selected
FROM  movies m
 inner join people p
  on m.picker = p.pid
GROUP BY m.picker
order by selected desc;