Learn SQL Aggregate Functions 9/10 Need Help

Hi im currently stuck on this problem. Any help would be appreciated. Also any explanation would be appreciated as well.

Here is the problem below

Suppose we have the query below:

Select price, ROUND(AVG(downloads))
FROM fake_apps GROUP BY price;

Certain price points don’t have very many apps, so the average is less meaningful.

Add a HAVING clause to restrict the query to prices where the total number of apps at that price point is greater than 9.

Hint: The total number of apps at each price point would be given by COUNT(*)

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