SQL SQLite — reference sample — DedSec Project

CREATE TABLE people (name TEXT NOT NULL); INSERT INTO people(name) VALUES ('Ada'), ('Grace'); SELECT 'Hello, ' name '!' AS greeting FROM people;

Source reference

CREATE TABLE people (name TEXT NOT NULL);
INSERT INTO people(name) VALUES ('Ada'), ('Grace');
SELECT 'Hello, ' || name || '!' AS greeting FROM people;