More aggregate statistics!
Can we calculate more than one aggregate statistic while grouping? Surely we can!
For example, from the audi_cars table, we can calculate the maximum price and tax for each year.
123SELECT AVG(price) AS "avg_price", AVG(tax) AS "avg_tax", year FROM audi_cars GROUP BY year
Please note, while grouping you can put non-aggregated function within
SELECTstatement only if it figures withinGROUP BY, otherwise - it has to be aggregated.
Also note, that in the example above without aliases (
AS) there will be two columns with identical names, which is unacceptable in SQL.
Another note: you can use aggregate functions for ordering after
GROUP BYstatement. It will filter based on calculations within groups.
Swipe to start coding
From the audi_cars table find out the minimum and the maximum prices for each model. Sort in descending order by minimum price.
Solution
Merci pour vos commentaires !
single
Demandez à l'IA
Demandez à l'IA
Posez n'importe quelle question ou essayez l'une des questions suggérées pour commencer notre discussion
Génial!
Completion taux amélioré à 2.63More aggregate statistics!
Glissez pour afficher le menu
Can we calculate more than one aggregate statistic while grouping? Surely we can!
For example, from the audi_cars table, we can calculate the maximum price and tax for each year.
123SELECT AVG(price) AS "avg_price", AVG(tax) AS "avg_tax", year FROM audi_cars GROUP BY year
Please note, while grouping you can put non-aggregated function within
SELECTstatement only if it figures withinGROUP BY, otherwise - it has to be aggregated.
Also note, that in the example above without aliases (
AS) there will be two columns with identical names, which is unacceptable in SQL.
Another note: you can use aggregate functions for ordering after
GROUP BYstatement. It will filter based on calculations within groups.
Swipe to start coding
From the audi_cars table find out the minimum and the maximum prices for each model. Sort in descending order by minimum price.
Solution
Passez à un bureau pour une pratique réelleContinuez d'où vous êtes en utilisant l'une des options ci-dessousMerci pour vos commentaires !
single
