what were the three most common specimen tests carried out?
select t1.spec_type_desc from ( select microbiologyevents.spec_type_desc, dense_rank() over ( order by count(*) desc ) as c1 from microbiologyevents group by microbiologyevents.spec_type_desc ) as t1 where t1.c1 <= 3