Filtering group size
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.
1234SELECT 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.
Swipe to start coding
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.
Løsning
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående mulighederTak for dine kommentarer!
single
Spørg AI
Spørg AI
Spørg om hvad som helst eller prøv et af de foreslåede spørgsmål for at starte vores chat
Awesome!
Completion rate improved to 2.63Awesome!
Completion rate improved to 2.63Filtering group size
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.
1234SELECT 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.
Swipe to start coding
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.
Løsning
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående mulighederTak for dine kommentarer!
single
Awesome!
Completion rate improved to 2.63Filtering group size
Stryg for at vise menuen
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.
1234SELECT 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.
Swipe to start coding
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.
Løsning
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående mulighederTak for dine kommentarer!
