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…

Try,

WHERE category = 'Games';
1 Like

That worked, thanks!

1 Like

Man! The CAPITAL G in “Games” got me!!!

1 Like

Hello! Why did you use SUM and not COUNT?

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