aggregate

SELECT category, ROUND(AVG(downloads), 0), ROUND(AVG(price), 1)
FROM fake_apps
WHERE price > 0
GROUP BY category
ORDER BY category;

SELECT price,
   ROUND(AVG(downloads)),
   COUNT(*)
FROM fake_apps
GROUP BY price
HAVING AVG(downloads) > 1000;

SELECT name, category, AVG(downloads)
FROM fake_apps
WHERE price > 0
GROUP BY name, category
ORDER BY name;