Yes, can you give me the codes please?
select 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
yes
select t1.attraction_type_description 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
yes
select t2.name from ref_attraction_types as t1 join tourist_attractions as t2 on t1.attraction_type_code = t2.attraction_type_code where attraction_type_description = "gallery"
How many attractions belong to gallery type?
select count ( * ) from ref_attraction_types as t1 join tourist_attractions as t2 on t1.attraction_type_code = t2.attraction_type_code where attraction_type_description = "gallery"
What are the opening hours of the haunted mansion?
select opening_hours from tourist_attractions where name = "haunted mansion"