What is the total number of clubs that have less than 10 medals in total?
SELECT count(*) FROM club_rank WHERE Total  <  10
total number of clubs = COUNT(*); less than 10 medals in total refers to Total < 10;