Course Content
SQL Basics
SQL Basics
6. Practicing
Challenge: Unique combinationsChallenge: Average Q-series cars priceChallenge: The cheapest new A-series carsChallenge: Relation between engine size and fuel consumptionChallenge: Mileage and manufacture year - is there relation?Challenge: Average price for each model and yearChallenge: The most expensive transmission + engine size combinations
Challenge: The most expensive transmission + engine size combinations
Task
Swipe to start coding
From the audi_cars table calculate the average price for each combination of transmission and enginesize. Round average price to 0 decimals (convert to integer). Filter to only those groups having at least 10 cars within. Sort the results in descending order by average price and extract only the first 5 rows.
Solution
Switch to desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
Thanks for your feedback!
Section 6. Chapter 7
Challenge: The most expensive transmission + engine size combinations
Task
Swipe to start coding
From the audi_cars table calculate the average price for each combination of transmission and enginesize. Round average price to 0 decimals (convert to integer). Filter to only those groups having at least 10 cars within. Sort the results in descending order by average price and extract only the first 5 rows.
Solution
Switch to desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
Thanks for your feedback!
Section 6. Chapter 7
Switch to desktop for real-world practiceContinue from where you are using one of the options below