Learn SQL Aggregate Functions 9/10 Need Help


#1

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(*)


#2

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