Part 10-Project Help


#1

Im stuck at part 10 of aggregate functions, can anyone help??

This is the question:

Return the total number of downloads for apps that belong to the Games category.


#2

Can you please tell us what have you done so far ?


#3

Sure, what I have so far:

select count(*)
from fake_apps;


#4

Did you try sum() function for downloads?

also can you please post the lesson link ?


#5

https://www.codecademy.com/courses/learn-sql/projects/fakeapps


#6

I think I found the correct syntax:

select count(*)
from fake_apps
where price=0;


#7

I'm very sorry :frowning: i can't access this link.It's only for pro user what i'm not.

so i don't know what does the instruction want?therefore it's impossible for me to tell whether it's correct or not according to the instruction.


#8

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.