Table: dukes_stats
Columns: rider
matches
rides
bonus_pts
total_points

Question: What was Bob Jameson's lowest bonus where he had less than 15 rides?
SQL: SELECT MIN("bonus_pts") FROM dukes_stats WHERE "rider" = 'bob jameson' AND "rides" < 15

Question: How many rides did it take to get less than 3 bonus pts in no more than 7 matches?
SQL: SELECT MIN("rides") FROM dukes_stats WHERE "bonus_pts" < 3 AND "matches" < 7

Question: What is the total for 34 matches with 111 rides, but no more than 15 bonus points?
SQL: SELECT AVG("total_points") FROM dukes_stats WHERE "matches" = 34 AND "rides" = 111 AND "bonus_pts" > 15

Question: How many rides did it take Ray Day to get 274 points in total with less than 3 bonus points?
SQL: SELECT COUNT("rides") FROM dukes_stats WHERE "total_points" < 274 AND "rider" = 'ray day' AND "bonus_pts" > 3

Question: Which rider had less than 342 points in no more than 76 rides in 7 matches with more than 2 bonus points?
SQL: SELECT "rider" FROM dukes_stats WHERE "total_points" < 342 AND "rides" < 76 AND "matches" = 7 AND "bonus_pts" > 2