Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Q3
--PostgreSQL 9.6 --'\\' is a delimiter CREATE TABLE Project (ProjectID CHAR(4) NOT NULL, Step INTEGER NOT NULL, Status CHAR(1) NOT NULL) ; INSERT INTO Project(ProjectID,Step,Status) VALUES ('P100',0,'C'), ('P100',1,'W'), ('P100',2,'W'), ('P201',0,'C'), ('P201',1,'C'), ('P333',0,'W'), ('P333',1,'W'), ('P333',2,'W'), ('P333',3,'W'), ; SELECT * FROM Project;
run
|
edit
|
history
|
help
0
Finale8E9237394
loggin_trigger-audit
Assignment 1(SET A)
Islands demonstration
complicated-conditional-sql-query-to-match-attributes-for-marketing-campaigns/43219741#43219741
Ass2 q2
test
Funciones matemáticas PostgreSQL
Many to many
E-commerce Website SQL Analysis