Table: race_results_121
Columns: year
team
co_drivers
class
laps
pos
class_pos

Question: What is the position for years under 1999?
SQL: SELECT "pos" FROM race_results_121 WHERE "year" < 1999

Question: What is the average year for Team Oreca?
SQL: SELECT AVG("year") FROM race_results_121 WHERE "team" = 'team oreca'

Question: Which team had a class position of 5th?
SQL: SELECT "team" FROM race_results_121 WHERE "class_pos" = '5th'

Question: What is the class having a year under 2010 and a class position of 5th?
SQL: SELECT "class" FROM race_results_121 WHERE "year" < 2010 AND "class_pos" = '5th'