学ぶ Filtering group size

セクション 5. 章 7

single

メニューを表示するにはスワイプしてください

Sometimes in real life, you can meet the situation where you have significant differences between two characteristics. For example, the average rate for one item is 5, and for another is 4.6. Without any further analysis looks like that the first item is better, but what if the first item received 2 rates and the second more than a thousand? We need to be ready to this effect.

For example, let's calculate the average price for each model having at least 10 cars in each group.


              1234
            
SELECT model, AVG(price)
FROM audi_cars
GROUP BY model
HAVING COUNT(*) > 10

To calculate the number of observations in each group you can use the known COUNT(*) statement.

タスク

スワイプしてコーディングを開始

From audi_cars calculate the average price for each engine size (enginesize column). Take into account only groups containing at least 7 observations and sort the resulting table by average price in ascending order.

解答

実践的な練習のためにデスクトップに切り替える下記のオプションのいずれかを利用して、現在の場所から続行する

すべて明確でしたか？

フィードバックありがとうございます！

セクション 5. 章 7

single

AIに質問する

何でも質問するか、提案された質問の1つを試してチャットを始めてください