Table: macadam_cup_2004
Columns: year
date_held
winner
events_won_by_kcl
events_won_by_kclms

Question: Which event won by KCLMS in 2008 has KCLMS as the winner and less than 10 wins by KCL?
SQL: SELECT "events_won_by_kcl" FROM macadam_cup_2004 WHERE "winner" = 'kclms' AND "events_won_by_kclms" < 10 AND "year" = 2008

Question: How many years were the events won by KCLMS less than 7?
SQL: SELECT COUNT("year") FROM macadam_cup_2004 WHERE "events_won_by_kclms" < 7

Question: What is the average value for events won by KCL in a year earlier than 2004?
SQL: SELECT AVG("events_won_by_kcl") FROM macadam_cup_2004 WHERE "year" < 2004