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.
Рішення
Все було зрозуміло?
Дякуємо за ваш відгук!
Секція 6. Розділ 7