Примеры команд SQL в рамках урока #20

-- Соединение таблиц. FULL JOIN
-- https://www.youtube.com/watch?v=KsBIHB1covo

-------------------------------------------
-- Примеры команд SQL в рамках урока #20


SELECT LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE, COUNTRY_ID
FROM LOCATIONS
;

SELECT COUNTRY_ID, COUNTRY_NAME, REGION_ID
FROM COUNTRIES
;

SELECT DISTINCT CITY, COUNTRY_ID
FROM LOCATIONS
;

SELECT
    DISTINCT a.CITY, a.COUNTRY_ID, b.COUNTRY_NAME, b.REGION_ID
FROM
    LOCATIONS a
    LEFT OUTER JOIN COUNTRIES b ON a.COUNTRY_ID = b.COUNTRY_ID
;