~/ 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/ac8f3225-2e68-4849-8c91-29235a8a70d5/flashcard utf-8 LF