SELECT, INSERT, UPDATE, DELETE

-- READ
SELECT id, name
  FROM users
 WHERE email = '[email protected]'
 ORDER BY created_at DESC
 LIMIT 10 OFFSET 0;

-- CREATE
INSERT INTO users (name, email)
VALUES ('Alice', '[email protected]');

COPY gender (id, name) FROM stdin;
0	Male
1	Female
\\.

-- UPDATE
UPDATE users
   SET name = 'Bob'
 WHERE id = 123;

-- DELETE
DELETE FROM users
 WHERE id = 123;

Insertion rows

insert into instructot
	select ID, name dept_name, 18000
	from student
	where department = 'music'