How many attraction types are there?
select count(*) from ref_attraction_types
What is the description of the attraction with attraction type code being 2?
select attraction_type_description from ref_attraction_types where attraction_type_code = 2
For each attraction type, how many attractions are there?
select t2.attraction_type_code, count(*) from ref_attraction_types as t1 join tourist_attractions as t2 on t1.attraction_type_code = t2.attraction_type_code group by t2.attraction_type_code
Please show the description and code of the attraction type that includes the most tourist attractions.
select t1.attraction_type_description, t2.attraction_type_code from ref_attraction_types as t1 join tourist_attractions as t2 on t1.attraction_type_code = t2.attraction_type_code group by t2.attraction_type_code order by count(*) desc limit 1