Sektion 6. Kapitel 7
single
Challenge: The most expensive transmission + engine size combinations
Stryg for at vise menuen
Opgave
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.
Løsning
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående mulighederVar alt klart?
Tak for dine kommentarer!
Sektion 6. Kapitel 7
single
Spørg AI
Spørg AI
Spørg om hvad som helst eller prøv et af de foreslåede spørgsmål for at starte vores chat
