peshopbs2

Untitled

Nov 30th, 2019
163
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. SELECT
  2. mc.country_code,
  3. m.mountain_range,
  4. p.peak_name,
  5. p.elevation
  6. FROM mountains_countries AS mc
  7. INNER JOIN mountains AS m ON
  8. mc.mountain_id = m.id
  9. INNER JOIN peaks AS p ON
  10. p.mountain_id = m.id
  11. WHERE mc.country_code = 'BG'
  12. AND p.elevation > 2835
  13. ORDER BY p.elevation DESC
Advertisement
Add Comment
Please, Sign In to add comment