Question 10 fake apps


#1

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?


#2


#3

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


#4

Tracking down the lesson...

Try,

WHERE category = 'Games';

#5

That worked, thanks!


#6

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


#8

Hello! Why did you use SUM and not COUNT?


#9

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