Table: shimizu_race_stats
Columns: year
class
team
points
rank
wins

Question: What is the lowest wins with points larger than 46, and a rank of 10th?
SQL: SELECT MIN("wins") FROM shimizu_race_stats WHERE "points" > 46 AND "rank" = '10th'

Question: What is the average points with a year higher than 1989, and a rank of 7th?
SQL: SELECT AVG("points") FROM shimizu_race_stats WHERE "year" > 1989 AND "rank" = '7th'

Question: What is the year that has points larger than 20?
SQL: SELECT COUNT("year") FROM shimizu_race_stats WHERE "points" > 20

Question: What is year that has points larger than 46, and a rank of 6th?
SQL: SELECT SUM("year") FROM shimizu_race_stats WHERE "points" > 46 AND "rank" = '6th'

Question: What earliest year with points larger than 68 and a rank of 7th?
SQL: SELECT MIN("year") FROM shimizu_race_stats WHERE "points" > 68 AND "rank" = '7th'