Grouping by multiple columns
Can we group observations based on multiple columns? For example, we can group all cars by year and engine size and find the most expensive within these.
To group by multiple columns use the same approach as for sorting by multiple columns: just put it within GROUP BY statement separated with a comma. The query for the example above will look like this:
123SELECT year, enginesize, AVG(price) FROM audi_cars GROUP BY year, enginesize
Swipe to start coding
From the audi_cars table calculate the maximum, average, and minimum price for each model manufactured in different years.
Soluzione
Cambia al desktop per esercitarti nel mondo realeContinua da dove ti trovi utilizzando una delle opzioni seguentiGrazie per i tuoi commenti!
single
Chieda ad AI
Chieda ad AI
Chieda pure quello che desidera o provi una delle domande suggerite per iniziare la nostra conversazione
Awesome!
Completion rate improved to 2.63Awesome!
Completion rate improved to 2.63Grouping by multiple columns
Can we group observations based on multiple columns? For example, we can group all cars by year and engine size and find the most expensive within these.
To group by multiple columns use the same approach as for sorting by multiple columns: just put it within GROUP BY statement separated with a comma. The query for the example above will look like this:
123SELECT year, enginesize, AVG(price) FROM audi_cars GROUP BY year, enginesize
Swipe to start coding
From the audi_cars table calculate the maximum, average, and minimum price for each model manufactured in different years.
Soluzione
Cambia al desktop per esercitarti nel mondo realeContinua da dove ti trovi utilizzando una delle opzioni seguentiGrazie per i tuoi commenti!
single
Awesome!
Completion rate improved to 2.63Grouping by multiple columns
Scorri per mostrare il menu
Can we group observations based on multiple columns? For example, we can group all cars by year and engine size and find the most expensive within these.
To group by multiple columns use the same approach as for sorting by multiple columns: just put it within GROUP BY statement separated with a comma. The query for the example above will look like this:
123SELECT year, enginesize, AVG(price) FROM audi_cars GROUP BY year, enginesize
Swipe to start coding
From the audi_cars table calculate the maximum, average, and minimum price for each model manufactured in different years.
Soluzione
Cambia al desktop per esercitarti nel mondo realeContinua da dove ti trovi utilizzando una delle opzioni seguentiGrazie per i tuoi commenti!
