user: ### NOW ANSWER:
Question: What was the total rating that had a score higher than 7 and a b score smaller than 8.65?
Columns: ['Position', 'Gymnast', 'A Score', 'B Score', 'Total']
Types: ['text', 'text', 'real', 'real', 'real']
Sample row: ['1st', 'Fabian Hambuechen ( GER )', 7.0, 9.2, 16.2]
SQL:

assistant: SELECT SUM("Total") FROM "Table" WHERE "A Score" > 7.0 AND "B Score" < 8.65;