peshopbs2

Untitled

Dec 1st, 2019
175
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.22 KB | None | 0 0
  1. SELECT
  2. COUNT(c.country_name) as countries_count
  3. /* or show data for countries, e.g c.country_name*/
  4. FROM countries AS c
  5. LEFT JOIN mountains_countries AS mc
  6. ON mc.country_code = c.country_code
  7. WHERE mountain_id IS NULL;
Advertisement
Add Comment
Please, Sign In to add comment