=> CREATE VIEW authors_v AS SELECT a.author_id, a.first_name || ' ' || a.last_name || coalesce(' ' || a.surname, '') AS display_name FROM authors a;
CREATE VIEW
=> CREATE VIEW catalog_v AS SELECT b.book_id, b.title AS display_name FROM books b;
CREATE VIEW