CREATE TABLE people (People_ID VARCHAR2)
CREATE TABLE employment (People_ID VARCHAR2, Company_ID VARCHAR2)
CREATE TABLE company (Name VARCHAR2, Company_ID VARCHAR2)

Show the names of companies and the number of employees they have
SELECT T3.Name, COUNT(*) FROM employment AS T1 JOIN people AS T2 ON T1.People_ID = T2.People_ID JOIN company AS T3 ON T1.Company_ID = T3.Company_ID GROUP BY T3.Name
SELECT "T3"."Name", COUNT(*) FROM "employment" "T1" JOIN "people" "T2" ON "T1"."People_ID" = "T2"."People_ID" JOIN "company" "T3" ON "T1"."Company_ID" = "T3"."Company_ID" GROUP BY "T3"."Name"