CREATE TABLE results (fastestlapspeed NUMBER, raceid VARCHAR2)
CREATE TABLE races (name VARCHAR2, year NUMBER, raceid VARCHAR2)

What are the maximum fastest lap speed in races held after 2004 grouped by race name and ordered by year?
SELECT MAX(T2.fastestlapspeed), T1.name, T1.year FROM races AS T1 JOIN results AS T2 ON T1.raceid = T2.raceid WHERE T1.year > 2014 GROUP BY T1.name ORDER BY T1.year
SELECT MAX("T2"."fastestlapspeed"), "T1"."name", "T1"."year" FROM "races" "T1" JOIN "results" "T2" ON "T1"."raceid" = "T2"."raceid" WHERE "T1"."year" > 2014 GROUP BY "T1"."name" ORDER BY "T1"."year"