Fake_apps - Bug with query results? Questions 15 & 18


#1


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


For some reason, I get a single result when querying the categories for questions 15 and 18. Example of output:

15.
category COUNT(*)
News 200

18.
name category MAX(price)
Anzoom Health & Fitness 14.99


Here is the code used:
SELECT category, COUNT(*) FROM fake_apps;
SELECT name, category, MAX(price) FROM fake_apps;


Replace this line with your code.


#2

Return the name of each category


SELECT category, COUNT(name) FROM fake_apps
GROUP BY category;

SELECT name, category, MAX(price) FROM fake_apps
GROUP BY category;