GROUP BY statement

Engine types

Report a typo

We have the cars table which, among others, has columns such as name, engine_type and max_speed.

Write a query that groups cars by engine type and finds the maximum speed for each type of engine. Do not order the data.

Write an SQL statement

Create a free account to access the full topic