Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE table_name_37 (rider VARCHAR, bonus_pts VARCHAR, matches VARCHAR, total_points VARCHAR, rides VARCHAR)

### Question ###
Which rider had less than 342 points in no more than 76 rides in 7 matches with more than 2 bonus points?

### Accurate SQL ###

SELECT rider FROM table_name_37 WHERE total_points < 342 AND rides < 76 AND matches = 7 AND bonus_pts > 2