~/ learn/ postgresql/ cards/ Set Operations
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/271cbe26-9289-4b00-9011-e9ea31624798/flashcard utf-8 LF