Tell me the information of all the parties.
select * from party
I just want to know their names.
select party from party
just show me the ones which have at least two records.
select party from party group by party having count(*) >= 2