How many features could be provided by tourist attractions?
select count(*) from features
Please show their details.
select feature_details from features
How many tourist attractions have parking as their feature details?
select count(*) from tourist_attractions as t1 join tourist_attraction_features as t2 on t1.tourist_attraction_id = t2.tourist_attraction_id join features as t3 on t2.feature_id = t3.feature_id where t3.feature_details = 'park'
How about the number of those that have either parking or shopping as their feature details?
select count(*) from (select t1.name from tourist_attractions as t1 join tourist_attraction_features as t2 on t1.tourist_attraction_id = t2.tourist_attraction_id join features as t3 on t2.feature_id = t3.feature_id where t3.feature_details = 'park' union select t1.name from tourist_attractions as t1 join tourist_attraction_features as t2 on t1.tourist_attraction_id = t2.tourist_attraction_id join features as t3 on t2.feature_id = t3.feature_id where t3.feature_details = 'shopping')
Please show the names of these attractions.
select t1.name from tourist_attractions as t1 join tourist_attraction_features as t2 on t1.tourist_attraction_id = t2.tourist_attraction_id join features as t3 on t2.feature_id = t3.feature_id where t3.feature_details = 'park' union select t1.name from tourist_attractions as t1 join tourist_attraction_features as t2 on t1.tourist_attraction_id = t2.tourist_attraction_id join features as t3 on t2.feature_id = t3.feature_id where t3.feature_details = 'shopping'