~/ 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/720e0077-1115-4aad-9503-461c227cb549/flashcard utf-8 LF