Course Content
SQL Basics
SQL Basics
The cheapest combination
Let's try to use acquired knowledge to solve the following problem!
Task
From the audi_cars table extract all the combinations of fueltype + transmission. Round price to 2 decimals and order using it in ascending order.
Task
From the audi_cars table extract all the combinations of fueltype + transmission. Round price to 2 decimals and order using it in ascending order.
Switch to desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
The cheapest combination
Let's try to use acquired knowledge to solve the following problem!
Task
From the audi_cars table extract all the combinations of fueltype + transmission. Round price to 2 decimals and order using it in ascending order.
Task
From the audi_cars table extract all the combinations of fueltype + transmission. Round price to 2 decimals and order using it in ascending order.
Switch to desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
The cheapest combination
Let's try to use acquired knowledge to solve the following problem!
Task
From the audi_cars table extract all the combinations of fueltype + transmission. Round price to 2 decimals and order using it in ascending order.
Task
From the audi_cars table extract all the combinations of fueltype + transmission. Round price to 2 decimals and order using it in ascending order.
Switch to desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
Let's try to use acquired knowledge to solve the following problem!
Task
From the audi_cars table extract all the combinations of fueltype + transmission. Round price to 2 decimals and order using it in ascending order.
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