Table: norisring_race_2
Columns: class
team
driver
chassis_engine
laps

Question: Which chassis-engine had 77 laps?
SQL: SELECT "chassis_engine" FROM norisring_race_2 WHERE "laps" = 77

Question: What is the class of team liqui moly equipe, which has less than 71 laps?
SQL: SELECT "class" FROM norisring_race_2 WHERE "laps" < 71 AND "team" = 'liqui moly equipe'

Question: What is the team of driver klaus ludwig, who is class c1 and has more than 77 laps?
SQL: SELECT "team" FROM norisring_race_2 WHERE "class" = 'c1' AND "laps" > 77 AND "driver" = 'klaus ludwig'

Question: Who is the driver of the chassis-engine porsche 956 gti?
SQL: SELECT "driver" FROM norisring_race_2 WHERE "chassis_engine" = 'porsche 956 gti'

Question: What team has a porsche 956 b chassis-engine with less than 79 laps?
SQL: SELECT "team" FROM norisring_race_2 WHERE "chassis_engine" = 'porsche 956 b' AND "laps" < 79