Postgres Practice, PostgreSQL

Postgres Practice

CREATE TABLE LEGITIMATE_RESALE (product_id INTEGER PRIMARY KEY,
    title TEXT,
    delivered DATE,
    unit_count INTEGER,
    price INTEGER                            
    haz_class TEXT,                       
    radioactive_yn INTEGER);

INSERT INTO EO_Incidents25 VALUES(1, "Kuro", "HZ Expansion", "Operations", 3, 1);
INSERT INTO EO_Incidents25 VALUES(2, "Kuro", "HZ Expansion", "Operations", 3, 1);
INSERT INTO EO_Incidents25 VALUES(3, "Kuro", "HZ Expansion", "Operations", 3, 1);
INSERT INTO EO_Incidents25 VALUES(4, "Kuro", "HZ Expansion", "Operations", 3, 1);
INSERT INTO EO_Incidents25 VALUES(5, "Lavender", "Override Escalation", "Support", 1, 0);
INSERT INTO EO_Incidents25 VALUES(6, "Lavender", "Override Escalation", "Security", 1, 0);
INSERT INTO EO_Incidents25 VALUES(7, "Lavender", "Override Escalation", "Security", 1, 0);
INSERT INTO EO_Incidents25 VALUES(8, "Lavender", "Override Escalation", "Operations", 1, 0);
INSERT INTO EO_Incidents25 VALUES(9, "Lavender", "Override Escalation", "Operations", 1, 0);
INSERT INTO EO_Incidents25 VALUES(10, "Lavender", "Override Escalation", "Operations", 1, 0);
INSERT INTO EO_Incidents25 VALUES(11, "Zinnwald", "Prank Call", "Operations", 1, 0);
INSERT INTO EO_Incidents25 VALUES(12, "Zinnwald", "Conference", "Operations", 1, 0);
INSERT INTO EO_Incidents25 VALUES(13, "Kuro", "Prank Call", "Operations", 1, 0);
INSERT INTO EO_Incidents25 VALUES(14, "Kuro", "Conference", "Operations", 1, 0);
INSERT INTO EO_Incidents25 VALUES(15, "Kuro", "Visitor", "Operations", 1, 1);
INSERT INTO EO_Incidents25 VALUES(16, "Kuro", "Explosive", "Operations", 5, 4);
INSERT INTO EO_Incidents25 VALUES(17, "Zinnwald", "Suspicious Person", "Security", 2, 1);
INSERT INTO EO_Incidents25 VALUES(18, "Zinnwald", "Conference", "Security", 1, 0);
INSERT INTO EO_Incidents25 VALUES(19, "Zinnwald", "Override Escalation", "Security", 1, 0);
INSERT INTO EO_Incidents25 VALUES(20, "Kuro", "Override Escalation", "Operations", 1, 0);


run \| edit \| history \| help	0