Table: le_mans_results
Columns: rnd
circuit
lmp1_winning_team
lmp2_winning_team
flm_winning_team
gt1_winning_team
gt2_winning_team
results

Question: How many results did the GT1 Winning Team No. 50 Larbre Compétition on the Algarve circuit?
SQL: SELECT COUNT("results") FROM le_mans_results WHERE "circuit" = 'Algarve' AND "gt1_winning_team" = 'No. 50 Larbre Compétition'

Question: How many winning teams are there on LMP2 if Gabriele Gardel Patrice Goueslard Fernando Rees was the GT1 Winning Team on the Algarve circuit?
SQL: SELECT COUNT("lmp2_winning_team") FROM le_mans_results WHERE "gt1_winning_team" = 'Gabriele Gardel Patrice Goueslard Fernando Rees' AND "circuit" = 'Algarve'

Question: Who was the GT2 Winning Team if Greg Mansell Leo Mansell was the LMP1 Winning Team?
SQL: SELECT "gt2_winning_team" FROM le_mans_results WHERE "lmp1_winning_team" = 'Greg Mansell Leo Mansell'

Question: What was the maximum round where Marc Lieb Richard Lietz was on the GT2 Winning Team?
SQL: SELECT MAX("rnd") FROM le_mans_results WHERE "gt2_winning_team" = 'Marc Lieb Richard Lietz'

Question: How many won the LMP1 on round 4 if No. 42 Strakka Racing was the LMP2 Winning Team?
SQL: SELECT COUNT("lmp1_winning_team") FROM le_mans_results WHERE "rnd" = 4 AND "lmp2_winning_team" = 'No. 42 Strakka Racing'

Question: In what round did Mike Newton Thomas Erdos Ben Collins won the LMP2?
SQL: SELECT "rnd" FROM le_mans_results WHERE "lmp2_winning_team" = 'Mike Newton Thomas Erdos Ben Collins'