User talk:Gfilis

From SQLZOO
Jump to: navigation, search

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.