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_10 (fleet_numbers VARCHAR, diagram VARCHAR, lot_no VARCHAR)

### Question ###
Name the fleet numbers for diagram of 186 and lot number of 30798

### Accurate SQL ###

SELECT fleet_numbers FROM table_name_10 WHERE diagram = 186 AND lot_no = 30798