Club count sql.md

SELECT  
  DISTINCT event_result.club,  
  driver_counts.driver_count  
FROM event_result   
JOIN (  
  SELECT distinct_drivers.club,   
  COUNT(1) AS driver_count  
  FROM (  
    SELECT DISTINCT custid, club  
    FROM event_result  
  ) AS distinct_drivers  
  GROUP BY distinct_drivers.club  
) AS driver_counts   
ON driver_counts.club = event_result.club  
ORDER BY driver_counts.driver_count DESC