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