~/ learn/ postgresql/ cards/ UNION, INTERSECT & EXCEPT
1 of 2

Build one list of distinct 'places': author countries (non-null) plus customer cities. Column: place.

Build one list of distinct 'places': author countries (non-null) plus customer cities. Column: place.

Answer

SELECT country AS place FROM authors WHERE country IS NOT NULL UNION SELECT city FROM customers;

space flip · ← → navigate · esc to exit
NORMAL ~/memra/library/b3d96d54-5f28-4171-8792-67ddbbd8afb4/flashcard utf-8 LF