Table: mccain_politics
Columns: years_covered
all_bills_sponsored
all_amendments_sponsored
all_bills_cosponsored
all_amendments_cosponsored
bills_originally_cosponsored
amendments_originally_cosponsored

Question: What is the total number of all bills co-sponsored associated with all amendments sponsored under 15, all bills sponsored of 6, and 0 amendments cosponsored?
SQL: SELECT COUNT("all_bills_cosponsored") FROM mccain_politics WHERE "all_amendments_sponsored" < 15 AND "all_bills_sponsored" = 6 AND "all_amendments_cosponsored" < 0

Question: What is the fewest amendments sponsored associated with 150 bills originally cosponsored and over 247 bills cosponsored?
SQL: SELECT MIN("all_amendments_sponsored") FROM mccain_politics WHERE "bills_originally_cosponsored" = 150 AND "all_bills_cosponsored" > 247

Question: What is the highest number of bills cosponsored associated with under 24 bills sponsored and under 16 amendments sponsored?
SQL: SELECT MAX("all_bills_cosponsored") FROM mccain_politics WHERE "all_bills_sponsored" < 24 AND "all_amendments_sponsored" < 16

Question: What is the highest number of amendments cosponsored associated with 53 amendments originally cosponsored and over 54 bills sponsored?
SQL: SELECT MAX("all_amendments_cosponsored") FROM mccain_politics WHERE "amendments_originally_cosponsored" = 53 AND "all_bills_sponsored" > 54

Question: What is the number of bills sponsored associated with over 113 bills originally cosponsored and under 47 amendments cosponsored?
SQL: SELECT "all_bills_sponsored" FROM mccain_politics WHERE "bills_originally_cosponsored" > 113 AND "all_amendments_cosponsored" < 47