CREATE TABLE player (player_id VARCHAR2, name_first VARCHAR2, name_last VARCHAR2)
CREATE TABLE salary (salary NUMBER, player_id VARCHAR2, year VARCHAR2)

How much did the the player with first name Len and last name Barker earn between 1985 to 1990 in total?
SELECT SUM(T1.salary) FROM salary AS T1 JOIN player AS T2 ON T1.player_id = T2.player_id WHERE T2.name_first = 'Len' AND T2.name_last = 'Barker' AND T1.year BETWEEN 1985 AND 1990
SELECT SUM("T1"."salary") FROM "salary" "T1" JOIN "player" "T2" ON "T1"."player_id" = "T2"."player_id" AND "T2"."name_first" = 'Len' AND "T2"."name_last" = 'Barker' WHERE "T1"."year" <= 1990 AND "T1"."year" >= 1985