What is the smallest rank for the city having partners of 342, other under 147, and largest city of Cleveland?
CREATE TABLE "see_also" (
  "rank" real,
  "largest_u_s_city" text,
  "total" real,
  "partners" real,
  "other" real
);
SELECT MIN("rank") FROM "see_also" WHERE "partners"=342 AND "largest_u_s_city"='cleveland' AND "other"<147;