Tell me the information about all parties
select * from party
I want to know the information about the Democratic party specifically.
select * from party where party = "Democratic"
Who is their lieutenant governor?
select lieutenant_governor from party where party = "Democratic"
Tell me the comptroller of that party.
select comptroller from party where party = "Democratic"