Table: mccarthy_polls
Columns: date
favorable
no_opinion
unfavorable
net_favorable

Question: which is the lowest favorable on 1954 June and more unfavorable than 45?
SQL: SELECT MIN("favorable") FROM mccarthy_polls WHERE "date" = '1954 june' AND "unfavorable" > 45

Question: What is the most unfavorable that is favorable of 34 during 1953 August and has a no opinion score larger than 24?
SQL: SELECT MAX("unfavorable") FROM mccarthy_polls WHERE "favorable" = 34 AND "date" = '1953 august' AND "no_opinion" > 24

Question: What is the average no opinion score during 1954 November that is more favorable than 35?
SQL: SELECT AVG("no_opinion") FROM mccarthy_polls WHERE "date" = '1954 november' AND "favorable" > 35