Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- mc.country_code,
- m.mountain_range,
- p.peak_name,
- p.elevation
- FROM mountains_countries AS mc
- INNER JOIN mountains AS m ON
- mc.mountain_id = m.id
- INNER JOIN peaks AS p ON
- p.mountain_id = m.id
- WHERE mc.country_code = 'BG'
- AND p.elevation > 2835
- ORDER BY p.elevation DESC
Advertisement
Add Comment
Please, Sign In to add comment