Table: lehto_race_results
Columns: year
entrant
class
chassis
engine
tyres
rank
points

Question: What is the rank of the cadillac northstar lmp02 chassis?
SQL: SELECT "rank" FROM lehto_race_results WHERE "chassis" = 'cadillac northstar lmp02'

Question: What is the entrant for the audi 3.6l turbo v8 engine and ranked 3rd with 163 points?
SQL: SELECT "entrant" FROM lehto_race_results WHERE "engine" = 'audi 3.6l turbo v8' AND "rank" = '3rd' AND "points" = 163

Question: What is the rank with more than 123 points, an audi r8 chassis, and a lmp900 class?
SQL: SELECT "rank" FROM lehto_race_results WHERE "points" > 123 AND "chassis" = 'audi r8' AND "class" = 'lmp900'

Question: What is the engine for the bmw motorsport entrant with 123 points before 2004?
SQL: SELECT "engine" FROM lehto_race_results WHERE "year" < 2004 AND "entrant" = 'bmw motorsport' AND "points" = 123