Table: indiana_house_representatives
Columns: office
representative
party
residence
first_elected

Question: Which Party has a Office of majority floor leader
SQL: SELECT "party" FROM indiana_house_representatives WHERE "office" = 'majority floor leader'

Question: Which Office has a Representative of scott pelath?
SQL: SELECT "office" FROM indiana_house_representatives WHERE "representative" = 'scott pelath'

Question: Which Office has a Party of rep, and a Representative of brian bosma?
SQL: SELECT "office" FROM indiana_house_representatives WHERE "party" = 'rep' AND "representative" = 'brian bosma'

Question: Which Residence has a Party of dem, and a Representative of linda lawson?
SQL: SELECT "residence" FROM indiana_house_representatives WHERE "party" = 'dem' AND "representative" = 'linda lawson'

Question: Which Party has a Representative of brian bosma?
SQL: SELECT "party" FROM indiana_house_representatives WHERE "representative" = 'brian bosma'

Question: Which Office has a Party of dem, and a First Elected of 1991†?
SQL: SELECT "office" FROM indiana_house_representatives WHERE "party" = 'dem' AND "first_elected" = '1991†'