Table: new_england_politics
Columns: state
governor
senior_u_s_senator
junior_u_s_senator
u_s_house_delegation
upper_house_majority
lower_house_majority

Question: Who was the senior US senator in the state whose governor was D. Patrick?
SQL: SELECT "senior_u_s_senator" FROM new_england_politics WHERE "governor" = 'D. Patrick'

Question: What's the lower house majority in the state whose Senior senator is J. Shaheen?
SQL: SELECT "lower_house_majority" FROM new_england_politics WHERE "senior_u_s_senator" = 'J. Shaheen'