SELECT COUNTRY_NAME,REGION_NAME,CITY
FROM COUNTRIES
NATURAL JOIN REGIONS
NATURAL JOIN LOCATIONS
ORDER BY REGION_ID ASC,COUNTRY_ID DESC, CITY DESC;

SELECT COUNTRY_NAME,REGION_NAME
FROM COUNTRIES
NATURAL JOIN REGIONS;