Run Code
|
API
|
Code Wall
|
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
postgresql timestamp
Movie Rating SQL Analysis Project
Mandelbrot
Professional Networking Social Media Website SQL Analysis
select distinct
PostgreSQL aggregate JSON recordset keys by row
Assignment 1(SET A)
Update as a function result
1225. Report Contiguous Dates
Distinct row aggregation with ordering - stackoverflow.com/q/43249053/4116017