what is the average lifespan of the representatives
select avg ( lifespan ) from representative
what parties have at least two representatives
select party from representative group by party having count ( * ) > = 2
what parties have at least three representatives
select party from representative group by party having count ( * ) > = 3