Challenge: The most expensive transmission + engine size combinations
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
Thanks for your feedback!
single
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Awesome!
Completion rate improved to 2.63Challenge: The most expensive transmission + engine size combinations
Swipe to show menu
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 belowThanks for your feedback!
Awesome!
Completion rate improved to 2.63single
