Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- COUNT(c.country_name) as countries_count
- /* or show data for countries, e.g c.country_name*/
- FROM countries AS c
- LEFT JOIN mountains_countries AS mc
- ON mc.country_code = c.country_code
- WHERE mountain_id IS NULL;
Advertisement
Add Comment
Please, Sign In to add comment