Table: supersport_2011
Columns: round
country
circuit
date
pole_position
fastest_lap
winning_rider
winning_team
report

Question: what is the circuit where the fastest lap is sam lowes and the winning rider is luca scassa?
SQL: SELECT "circuit" FROM supersport_2011 WHERE "fastest_lap" = 'Sam Lowes' AND "winning_rider" = 'Luca Scassa'

Question: what is the round wher the fabien foret had the fastest lap and david salom was the pole position?
SQL: SELECT "round" FROM supersport_2011 WHERE "fastest_lap" = 'Fabien Foret' AND "pole_position" = 'David Salom'

Question: who had the fastest lap for round 1?
SQL: SELECT "fastest_lap" FROM supersport_2011 WHERE "round" = 1

Question: what is the pole position for france?
SQL: SELECT "pole_position" FROM supersport_2011 WHERE "country" = 'France'

Question: what is the maximum round and fabien foret had the pole position?
SQL: SELECT MAX("round") FROM supersport_2011 WHERE "pole_position" = 'Fabien Foret'