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
Show the id, name of each editor and the number of journal committees they are on.
CREATE TABLE IF NOT EXISTS "journal" (
"Journal_ID" int,
"Date" text,
"Theme" text,
"Sales" int,
PRIMARY KEY ("Journal_ID")
);
CREATE TABLE IF NOT EXISTS "editor" (
"Editor_ID" int,
"Name" text,
"Age" real,
PRIMARY KEY ("Editor_ID")
);
CREATE TABLE IF NOT EXISTS "journal_committee" (
"Editor_ID" int,
"Journal_ID" int,
"Work_Type" text,
PRIMARY KEY ("Editor_ID","Journal_ID"),
FOREIGN KEY ("Editor_ID") REFERENCES `editor`("Editor_ID"),
FOREIGN KEY ("Journal_ID") REFERENCES `journal`("Journal_ID")
);

INSERT INTO journal VALUES(1,'September 9, 2001','Miami Dolphins',798);
INSERT INTO editor VALUES(1.0,'Kamila Porczyk',34.0);
INSERT INTO journal_committee VALUES(1,13,'Photo');
