Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
1075-1077 Project Analysis
--PostgreSQL 9.6 --'\\' is a delimiter drop table if exists Project; drop table if exists Employee; Create table Project("project_id" int, "employee_id" int); Create table Employee("employee_id" int, "name" varchar(255), "experience_years" int); insert into Project("project_id", "employee_id") values (1, 1), (1, 2), (1, 3), (2, 1), (2, 4); insert into Employee ("employee_id", "name", "experience_years") values (1, 'Khaled', 3), (2, 'Ali', 2), (3, 'John', 1), (4, 'Doe', 2);
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
statistics
PostgreSQL Sandbox: Legitimate Resale
Testing psql
UNIX_TIMESTAMP
Demande complète
test_tags_count
Pivot the Hard Way..
Update as a function result
1
SQL2_CLASS
Please log in to post a comment.