user: ### NOW ANSWER:
Question: What is the lowest value of a team with revenue less than 374 and a debt of 84%?
Columns: ['Team', 'Country', 'Value ($M)', 'Debt as %of value', '% change on year', 'Revenue ($M)', 'Operating income($m)']
Types: ['text', 'text', 'real', 'text', 'text', 'real', 'real']
Sample row: ['Manchester United', 'England', 1453.0, '84', '6', 310.0, 92.0]
SQL:

assistant: SELECT MIN("Value ($M)") FROM "Table" WHERE "Revenue ($M)" < 374.0 AND "Debt as %of value" = '84';