user: Question: What is the lowest rank with a value less than 1200 million and revenue less than 396 million for Manchester City?
Columns: ['Rank', 'Team', 'Country', 'Value ($M)', '% change on year', 'Revenue ($M)']
Types: ['real', 'text', 'text', 'real', 'real', 'real']
Sample row: [1.0, 'Manchester United', 'England', 1864.0, 1.0, 428.0]
SQL:

assistant: SELECT MIN("Rank") FROM "Table" WHERE "Value ($M)" < 1200.0 AND "Revenue ($M)" < 396.0 AND "Team" = 'Manchester City';