How many parties are there?
select count ( * ) from party
What are their names?
select party from party
Is there any party that has at least two records?
select party from party group by party having count ( * ) > 1
Yes, can you show me all the attorney generals from democratic party?
select attorney_general from party where party = 'Democratic'