Table: norisring_race
Columns: class
team
driver
chassis_engine
laps

Question: How many Laps did Bob Wollek have?
SQL: SELECT AVG("laps") FROM norisring_race WHERE "driver" = 'bob wollek'

Question: How many Laps did Team Primagaz Competition have?
SQL: SELECT "laps" FROM norisring_race WHERE "team" = 'primagaz competition'

Question: What Team had 40 Laps in C1 Class?
SQL: SELECT "team" FROM norisring_race WHERE "class" = 'c1' AND "laps" = 40

Question: What Team has Bob Wollek as a Driver with 76 Laps in C1 Class?
SQL: SELECT "team" FROM norisring_race WHERE "class" = 'c1' AND "laps" = 76 AND "driver" = 'bob wollek'

Question: How many Laps does GP Motorsport Team have?
SQL: SELECT SUM("laps") FROM norisring_race WHERE "team" = 'gp motorsport'