user: Question: What was the total amount of Value ($M), when the Rank was higher than 6, and the % change on year was -27?
Columns: ['Rank', 'Team', 'Country', 'Value ($M)', 'Debt as %of value', '% change on year', 'Revenue ($M)', 'Operating income($m)']
Types: ['real', 'text', 'text', 'real', 'real', 'text', 'real', 'real']
Sample row: [1.0, 'Manchester United', 'England', 1800.0, 60.0, '24', 394.0, 111.0]
SQL:

assistant: SELECT SUM("Value ($M)") FROM "Table" WHERE "Rank" > 6.0 AND "% change on year" = '-27';