I think More Join Operations question #15 might have a problem. I get "Wrong answer. Some of the data is incorrect." with the following query:
select m.title,count(c.actorid) '#actors' from casting c join movie m on m.id=c.movieid where m.yr=1978 group by m.title order by m.id
I believe it should give me the correct response.