FindYourTrail.us

Go to main query page

Parks that have Trails with 2 or more reviews

SELECT NP_NAME 'National Park', NP_STATE 'State' FROM ( SELECT Parks.Name AS NP_NAME,Parks.State AS NP_STATE,Trails.ID,COUNT(UserReview.Review_ID) AS cnt FROM Parks LEFT JOIN Trails ON Parks.Name=Trails.`National Park` LEFT JOIN UserReview ON Trails.ID=UserReview.Trail_ID GROUP BY Trails.ID ) AS park_count WHERE cnt>1 GROUP BY NP_NAME