SELECT t.`Trail Name`,t.`National Park`,Parks.State,t.`Trail Difficulty`,row_num FROM ( SELECT t.`Trail Name`,t.`National Park`,t.`Trail Difficulty`, ( SELECT COUNT(*) FROM `Trails` t2 WHERE t2.`National Park`=t.`National Park` AND (t2.`Trail Difficulty` > t.`Trail Difficulty` OR t2.`Trail Difficulty` = t.`Trail Difficulty` AND t2.`Trail Name` <= t.`Trail Name` ) ) AS row_num FROM `Trails` t ) AS t INNER JOIN Parks ON t.`National Park`=Parks.Name WHERE row_num <= 3 ORDER BY t.`National Park`, row_num