CREATE TABLE city (id INTEGER, name TEXT, country TEXT);
INSERT INTO city VALUES (1, 'Cairo', 'Egypt'), (2, 'Lima', 'Peru');
-- * expands to every column in the table
SELECT *
FROM city;

SELECT * returns all columns