What is the fewest amendments sponsored associated with 150 bills originally cosponsored and over 247 bills cosponsored?
CREATE TABLE "legislation_sponsored_by_john_mc_cain" (
  "years_covered" text,
  "all_bills_sponsored" real,
  "all_amendments_sponsored" real,
  "all_bills_cosponsored" real,
  "all_amendments_cosponsored" real,
  "bills_originally_cosponsored" real,
  "amendments_originally_cosponsored" real
);
SELECT MIN("all_amendments_sponsored") FROM "legislation_sponsored_by_john_mc_cain" WHERE "bills_originally_cosponsored"=150 AND "all_bills_cosponsored">247;