Contenido del Curso
SQL Basics
SQL Basics
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:
SELECT year, enginesize, AVG(price) FROM audi_cars GROUP BY year, enginesize
Tarea
From the audi_cars table calculate the maximum, average, and minimum price for each model manufactured in different years.
Tarea
From the audi_cars table calculate the maximum, average, and minimum price for each model manufactured in different years.
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones¿Todo estuvo claro?
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:
SELECT year, enginesize, AVG(price) FROM audi_cars GROUP BY year, enginesize
Tarea
From the audi_cars table calculate the maximum, average, and minimum price for each model manufactured in different years.
Tarea
From the audi_cars table calculate the maximum, average, and minimum price for each model manufactured in different years.
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones¿Todo estuvo claro?
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:
SELECT year, enginesize, AVG(price) FROM audi_cars GROUP BY year, enginesize
Tarea
From the audi_cars table calculate the maximum, average, and minimum price for each model manufactured in different years.
Tarea
From the audi_cars table calculate the maximum, average, and minimum price for each model manufactured in different years.
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones¿Todo estuvo claro?
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:
SELECT year, enginesize, AVG(price) FROM audi_cars GROUP BY year, enginesize
Tarea
From the audi_cars table calculate the maximum, average, and minimum price for each model manufactured in different years.
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opcionesCambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones