Table: sidecarcross_2008_2
Columns: position
driver_passenger
equipment
bike_no
points

Question: What is the lowest Bike No, when Driver / Passenger is Joris Hendrickx / Kaspars Liepins, and when Position is less than 4?
SQL: SELECT MIN("bike_no") FROM sidecarcross_2008_2 WHERE "driver_passenger" = 'joris hendrickx / kaspars liepins' AND "position" < 4

Question: What is the average Position, when Bike No is greater than 8, and when Points is less than 240?
SQL: SELECT AVG("position") FROM sidecarcross_2008_2 WHERE "bike_no" > 8 AND "points" < 240

Question: What is the lowest Postion, when Bike No is greater than 10, when Driver / Passenger is Nicky Pulinx / Ondrej Cermak, and when Points is greater than 244?
SQL: SELECT MIN("position") FROM sidecarcross_2008_2 WHERE "bike_no" > 10 AND "driver_passenger" = 'nicky pulinx / ondrej cermak' AND "points" > 244

Question: What is the highest Points, when Position is less than 4, when Equipment is Zabel - VMC, and when Bike No is less than 1?
SQL: SELECT MAX("points") FROM sidecarcross_2008_2 WHERE "position" < 4 AND "equipment" = 'zabel - vmc' AND "bike_no" < 1

Question: What is the average Bike No, when Driver / Passenger is Joris Hendrickx / Kaspars Liepins, and when Position is greater than 4?
SQL: SELECT AVG("bike_no") FROM sidecarcross_2008_2 WHERE "driver_passenger" = 'joris hendrickx / kaspars liepins' AND "position" > 4