CREATE TABLE coach (coach_id DECIMAL, coach_name TEXT, gender TEXT, club_id DECIMAL, rank DECIMAL)
CREATE TABLE club (club_id DECIMAL, club_name TEXT, region TEXT, start_year DECIMAL)
CREATE TABLE match_result (rank DECIMAL, club_id DECIMAL, gold DECIMAL, big_silver DECIMAL, small_silver DECIMAL, bronze DECIMAL, points DECIMAL)
CREATE TABLE player_coach (player_id DECIMAL, coach_id DECIMAL, starting_year DECIMAL)
CREATE TABLE player (player_id DECIMAL, sponsor_name TEXT, player_name TEXT, gender TEXT, residence TEXT, occupation TEXT, votes DECIMAL, rank TEXT)

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"