Schema: CREATE TABLE club_rank (Total INTEGER)
Question: How many clubs have total medals less than 10?
SQL: SELECT COUNT(*) FROM club_rank WHERE Total < 10