SELECT * FROM list;
SELECT * FROM task;

SELECT description, deadline FROM task;

SELECT description, deadline FROM task WHERE id = 1;

SELECT description, deadline FROM task WHERE list_id = 1 AND status = 0;

SELECT description AS 'Incomplete tasks', deadline FROM task WHERE list_id = 1 AND status = 0;


SELECT list.name, task.description, task.deadline, task.status FROM list INNER JOIN task ON task.list_id = list.id;

-- CREATE VIEW detailed_list
