CREATE TABLE person (id INTEGER, first TEXT, last TEXT);
INSERT INTO person VALUES (1, 'Grace', 'Hopper'), (2, 'Alan', 'Turing');
-- || concatenates strings
SELECT first || ' ' || last AS full_name
FROM person;

join strings with ||