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.
Solução
Obrigado pelo seu feedback!
single
Pergunte à IA
Pergunte à IA
Pergunte o que quiser ou experimente uma das perguntas sugeridas para iniciar nosso bate-papo
Resumir este capítulo
Explicar o código em file
Explicar por que file não resolve a tarefa
Awesome!
Completion rate improved to 2.63More aggregate statistics!
Deslize para mostrar o 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.
Solução
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixoObrigado pelo seu feedback!
single
