Question 10 fake apps


I have tried rewriting this a few ways and can't seem to get it. The question asks for the sum of all downloads in the games category.
I have:
SELECT category, SUM(downloads) FROM fake_apps
WHERE category = 'games';

It populates the columns but no results in the rows. Am I missing something?



Woops, I was reading a different question and it got jumbled in my head. It should be games. I'll correct it, thanks!


Tracking down the lesson...


WHERE category = 'Games';


That worked, thanks!


Man! The CAPITAL G in "Games" got me!!!


Hello! Why did you use SUM and not COUNT?


Because it is the sum of all the counts in each category, perhaps?