CREATE TABLE table_15637 ("Rank" FLOAT, "Team" CLOB, "Country" CLOB, "Value  ( $M ) " FLOAT, "% change on year" FLOAT, "Revenue  ( $M ) " FLOAT)

What is the lowest rank with a value less than 1,200 million and revenue less than 396 million for Manchester City?
SELECT MIN("Rank") FROM table_15637 WHERE "Value ($M)" < '1,200' AND "Revenue ($M)" < '396' AND "Team" = 'manchester city'
SELECT MIN("Rank") FROM "table_15637" WHERE "Revenue ($M)" < '396' AND "Team" = 'manchester city' AND "Value ($M)" < '1,200'