gistfile1.txt

WITH #members AS (
    SELECT DISTINCT count(*) as num
	FROM yrb_club C, yrb_member M
	WHERE C.club = M.club
)
SELECT 
	C.club,
	count(M.num)
FROM 
	yrb_club C,
	#members M
GROUP BY 
    C.club;

ERROR:
The statement does not include a required column list.