SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE apollo_org_job_function ( department VARCHAR(64),people integer ); INSERT INTO apollo_org_job_function VALUES ('Engineering',2), ('human_resources',4), ('entrepreneurship',1); WITH data AS ( SELECT department, COUNT(*) as people FROM apollo_org_job_function GROUP BY people ORDER BY people ) SELECT JSON_AGG(JSON_BUILD_OBJECT(department, people)) as "dep_people" FROM data;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear