-- Demonstrates SELECT
-- Uses longlist.db

-- Selects all columns from "longlist" table
SELECT * FROM "longlist";

-- Selects "title" column from "longlist" table
SELECT "title" FROM "longlist";

-- Selects "title" and "author" column from "longlist" table
SELECT "title", "author" FROM "longlist";

-- Selects "title", "author", and "translator" column from "longlist" table
SELECT "title", "author", "translator" FROM "longlist";
