Which states have two or more representatives?
select state from representative group by state having count ( * ) > = 2
What are the names of the representatives from those states?
select name from representative where state in ( select state from representative group by state having count ( * ) > = 2 )
What parties do they belong to?
select party from representative where state in ( select state from representative group by state having count ( * ) > = 2 )