user: ### NOW ANSWER:
Question: Which record has John Flemming as the opponent?
Columns: ['Res.', 'Record', 'Opponent', 'Method', 'Event', 'Round', 'Time', 'Location']
Types: ['text', 'text', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['Win', '11–6–1 (1)', 'Gabe Ruediger', 'KO (head kick and punches)', 'UFC 126', '2', '1:42', 'Las Vegas, Nevada , United States']
SQL:

assistant: SELECT "Record" FROM "Table" WHERE "Opponent" = 'John Flemming';