user: ### NOW ANSWER:
Question: What is the highest points gained of the match where fans took 907 and there were more than 44.9 miles one way?
Columns: ['Team', 'Miles [One Way]', 'Home Result', 'Fans Brought', 'Away Result', 'Fans Took', 'Points Gained']
Types: ['text', 'real', 'text', 'text', 'text', 'text', 'real']
Sample row: ['Mansfield Town', 34.8, '1 - 2', '734 [Tuesday]', '3 - 1', '620', 3.0]
SQL:

assistant: SELECT MAX("Points Gained") FROM "Table" WHERE "Fans Took" = '907' AND "Miles [One Way]" > 44.9;