CREATE TABLE editor (editor_id VARCHAR, Name VARCHAR, Editor_ID VARCHAR)
CREATE TABLE journal_committee (Editor_ID VARCHAR)

Show the id, name of each editor and the number of journal committees they are on.
SELECT T1.Editor_ID, T1.Name, COUNT(*) FROM editor AS T1 JOIN journal_committee AS T2 ON T1.Editor_ID = T2.Editor_ID GROUP BY T1.Editor_ID
SELECT "T1"."Editor_ID", "T1"."Name", COUNT(*) FROM "editor" AS "T1" JOIN "journal_committee" AS "T2" ON "T1"."Editor_ID" = "T2"."Editor_ID" GROUP BY "T1"."Editor_ID"