user: ### NOW ANSWER:
Question: What is the most Champions League assists for those with a total of 6 and position of Midfielder?
Columns: ['Player', 'Position', 'League', 'Copa del Rey', 'Champions League', 'Total']
Types: ['text', 'text', 'real', 'real', 'real', 'real']
Sample row: ['Gonzalo Higuaín', 'Forward', 8.0, 0.0, 0.0, 8.0]
SQL:

assistant: SELECT MAX("Champions League") FROM "Table" WHERE "Total" = 6.0 AND "Position" = 'Midfielder';