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

Question: What points have 500cc as a class, and nsr500 as a machine?
SQL: SELECT "points" FROM motogp_results_2 WHERE "class" = '500cc' AND "machine" = 'nsr500'

Question: How many years have 78 for points?
SQL: SELECT COUNT("year") FROM motogp_results_2 WHERE "points" = 78

Question: What class has nsr250 as the machine, with points greater than 97?
SQL: SELECT "class" FROM motogp_results_2 WHERE "machine" = 'nsr250' AND "points" > 97

Question: What is the lowest year that have wins greater than 0?
SQL: SELECT MIN("year") FROM motogp_results_2 WHERE "wins" > 0

Question: What are the highest points that have a year less than 1992, with wins less than 0?
SQL: SELECT MAX("points") FROM motogp_results_2 WHERE "year" < 1992 AND "wins" < 0