SELECT T1.club_id ,  T1.club_name, count(*) FROM club AS T1 JOIN coach AS T2 ON T1.club_id  =  T2.club_id GROUP BY T1.club_id
How many coaches does each club has? List the club id, name and the number of coaches.
SELECT T1.club_id , T1.club_name , count ( * ) FROM club AS T1 JOIN coach AS T2 ON T1.club_id = T2.club_id GROUP BY T1.club_id
select t1 . club_id , t1 . club_name , count ( * ) from club as t1 join coach as t2 on t1 . club_id = t2 . club_id group by t1 . club_id
How many coaches does each club has ? List the club id , name and the number of coaches .