Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Lära Filtering group size | Grouping
SQL Basics

bookFiltering 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.


              
1234

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

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

Uppgift

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

Switch to desktopByt till skrivbordet för praktisk övningFortsätt där du är med ett av alternativen nedan
Var allt tydligt?

Hur kan vi förbättra det?

Tack för dina kommentarer!

Avsnitt 5. Kapitel 7
single

single

Fråga AI

expand

Fråga AI

ChatGPT

Fråga vad du vill eller prova någon av de föreslagna frågorna för att starta vårt samtal

close

Awesome!

Completion rate improved to 2.63

bookFiltering 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.


              
1234

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

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

Uppgift

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

Switch to desktopByt till skrivbordet för praktisk övningFortsätt där du är med ett av alternativen nedan
Var allt tydligt?

Hur kan vi förbättra det?

Tack för dina kommentarer!

Avsnitt 5. Kapitel 7
single

single

close

Awesome!

Completion rate improved to 2.63

bookFiltering group size

Svep för att visa menyn

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
copy

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

Uppgift

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

Switch to desktopByt till skrivbordet för praktisk övningFortsätt där du är med ett av alternativen nedan
Var allt tydligt?

Hur kan vi förbättra det?

Tack för dina kommentarer!

some-alt