CREATE TABLE table_name_48 (Champions INT, total VARCHAR, position VARCHAR)

What is the most Champions League assists for those with a total of 6 and position of Midfielder?
SELECT MAX(Champions) AS league FROM table_name_48 WHERE total = 6 AND position = "midfielder"
SELECT MAX("Champions") AS "league" FROM "table_name_48" WHERE "midfielder" = "position" AND "total" = 6