Play with PostgreSQL

Made by yingshaoxo 

CREATE TABLE people (
    name            varchar(80),
    age             int,           -- how long you live
    createDate      date
);

INSERT INTO people VALUES ('hero hu', 18, '2021-09-1');
INSERT INTO people VALUES ('kristine', 25, '2021-09-1');

SELECT * FROM people;

SELECT name FROM people;

SELECT * FROM people WHERE age = 25;

CREATE TABLE sex (
    name            varchar(80),
    sex             varchar(80) 
);

INSERT INTO sex VALUES ('hero hu', 'male');
INSERT INTO sex VALUES ('kristine', 'female');

SELECT people.name, age, sex.sex, people.createdate FROM people JOIN sex ON people.name = sex.name;

SELECT people.name, age, sex.sex, people.createdate as date FROM people JOIN sex ON people.name = sex.name;

SELECT max(age) FROM people;
SELECT min(age) FROM people;

SELECT * FROM people WHERE name LIKE '%hu%';

UPDATE people 
    SET age = 0
    WHERE name = 'hero hu';

​