Table: us_house_conn_2008
Columns: district
incumbent
2008_status
democratic
republican
green

Question: What's the 2008 Status of Rosa Delauro?
SQL: SELECT "2008_status" FROM us_house_conn_2008 WHERE "democratic" = 'rosa delauro'

Question: Who was the incumbent when Bo Itshaky was the Republican?
SQL: SELECT "incumbent" FROM us_house_conn_2008 WHERE "republican" = 'bo itshaky'

Question: Who was the Republican in the district more than 4?
SQL: SELECT "republican" FROM us_house_conn_2008 WHERE "district" > 4

Question: Who was the Republican when the green was Harold Burbank?
SQL: SELECT "republican" FROM us_house_conn_2008 WHERE "green" = 'harold burbank'

Question: Who was the Democratic when then Incumbent was Christopher Shays?
SQL: SELECT "democratic" FROM us_house_conn_2008 WHERE "incumbent" = 'christopher shays'