Course Content
SQL Basics
SQL Basics
Challenge: Average price for each model and year
Task
From the audi_cars table calculate the average price for each combination of model and year. Round average price to 0 decimals (so make it integer). Sort values by year.
Task
From the audi_cars table calculate the average price for each combination of model and year. Round average price to 0 decimals (so make it integer). Sort values by year.
Switch to desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
Challenge: Average price for each model and year
Task
From the audi_cars table calculate the average price for each combination of model and year. Round average price to 0 decimals (so make it integer). Sort values by year.
Task
From the audi_cars table calculate the average price for each combination of model and year. Round average price to 0 decimals (so make it integer). Sort values by year.
Switch to desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
Challenge: Average price for each model and year
Task
From the audi_cars table calculate the average price for each combination of model and year. Round average price to 0 decimals (so make it integer). Sort values by year.
Task
From the audi_cars table calculate the average price for each combination of model and year. Round average price to 0 decimals (so make it integer). Sort values by year.
Switch to desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
Task
From the audi_cars table calculate the average price for each combination of model and year. Round average price to 0 decimals (so make it integer). Sort values by year.
Switch to desktop for real-world practiceContinue from where you are using one of the options belowSwitch to desktop for real-world practiceContinue from where you are using one of the options below