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.
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
Show the id , name of each editor and the number of journal committees they are on .