Table 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