Advertisement
peshopbs2

Untitled

Dec 1st, 2019
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. SELECT m.mountain_range,
  2. p.peak_name,
  3. p.elevation
  4. FROM mountains AS m
  5. INNER JOIN mountains_countries AS mc
  6. ON mc.country_code = 'BG'
  7. AND mc.mountain_id=m.id
  8. LEFT OUTER JOIN peaks AS p
  9. ON p.mountain_id = m.id
  10. WHERE p.id =
  11. (SELECT id FROM peaks
  12. WHERE mountain_id=m.id
  13. ORDER BY elevation DESC LIMIT 1)
  14. OR p.id is null
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement