Table: kevinschwantz_500cc
Columns: year
class
team
machine
points
rank
wins

Question: How many wins for the year that is later than 1987 and has points less than 188?
SQL: SELECT "wins" FROM kevinschwantz_500cc WHERE "year" > 1987 AND "points" < 188

Question: What is the name of the machine that ranked  4th and has 2 wins?
SQL: SELECT "machine" FROM kevinschwantz_500cc WHERE "rank" = '4th' AND "wins" = 2

Question: How many wins were there in 1994?
SQL: SELECT SUM("wins") FROM kevinschwantz_500cc WHERE "year" = 1994

Question: What is the rank associated with the team that has more than 2 wins and has greater than 204 points?
SQL: SELECT "rank" FROM kevinschwantz_500cc WHERE "wins" > 2 AND "points" > 204