Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
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
loggin_trigger-audit
PostreSQL: Left Join
Query integer in text field - Seemingly doesn't work as expected
user
postgresql: working days
2
mandelbrot set
SQL - Unpivot Table
Mandelbrot
Tememons Dashboard