Go to main query page

Average User Rating in each Park

SELECT ave.park 'National Park',ave.state 'State',ROUND(avrge,2) 'Average User Rating' FROM ( SELECT AVG(u.Rating) AS avrge,t.`National Park` park,p.State state FROM `UserReview` u INNER JOIN Trails t ON u.Trail_ID=t.ID INNER JOIN Parks p ON t.`National Park`=p.Name GROUP BY p.Name ) AS ave GROUP BY ave.park ORDER BY ave.state