SELECT count(*) FROM club_rank WHERE Total  <  10
What is the total number of clubs that have less than 10 medals in total?
SELECT count ( * ) FROM club_rank WHERE Total < 10
select count ( * ) from club_rank where total < value
What is the total number of clubs that have less than 10 medals in total ?