Hello, I’m a little confused by the group by exercise in aggregate functions.
how come when you do:
select category, sum(downloads) from fake_apps;
It shows the total downloads (for all categories I think 3,322,760) but it lists it next to ONLY productivity under category? I thought that if you select category it would list all the different categories, not just “productivity”?
question 2: once you do
select category, sum(downloads)
from fake_apps
group by category;
then it shows all the different categories, including productivity which had 117,811 downloads but in the previous pic was showing 3,322,760? maybe I’m not understanding. it won’t let me post a second picture.
thank you very much!!