when creating a todolist with sql where i code the sql

Name: todos id Type: DEFAULT Schema: public Owner: reggieandgeorgiatardyĪLTER TABLE ONLY todos ALTER COLUMN id SET DEFAULT nextval('todos_id_seq'::regclass). Name: todos_id_seq Type: SEQUENCE OWNED BY Schema: public Owner: reggieandgeorgiatardyĪLTER SEQUENCE todos_id_seq OWNED BY todos.id. Name: todos_id_seq Type: SEQUENCE Schema: public Owner: reggieandgeorgiatardyĪLTER TABLE todos_id_seq OWNER TO reggieandgeorgiatardy.

Name: todos Type: TABLE Schema: public Owner: reggieandgeorgiatardyĬreated_at timestamp without time zone NOT NULL,ĪLTER TABLE todos OWNER TO reggieandgeorgiatardy. Name: EXTENSION plpgsql Type: COMMENT Schema: - Owner:ĬOMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language' Name: plpgsql Type: EXTENSION Schema: - Owner:ĬREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog. SET idle_in_transaction_session_timeout = 0 This is the todo with the highest priority that was created first. Write a SELECT statement to find the next todo you should work on. Write a SELECT statement to find the number of todos by priority created in the last 30 days. Write a SELECT statement to find the number of incomplete todos by priority. Write a SELECT statement to find all incomplete todos with priority 3. Write INSERT statements to insert 20 todos into the todos table, with a combination of priorities, created times, and completed times, with not all having a completed time. Created a database called todolist, write a set of SQL statements in a file called sql_todo_list.sql.

When creating a todolist with sql where i code the sql