Database: sports_competition
Question: How many clubs have total medals less than 10?
SQL:
SELECT count(*) FROM club_rank WHERE Total  <  10