-- Database schema
| club : Club_ID [ INT ] primary_key , name [ TEXT ] , Region [ TEXT ] , Start_year [ TEXT ] | club_rank : Rank [ INT ] primary_key , Club_ID [ INT ] club_rank.Club_ID = club.Club_ID , Gold [ INT ] , Silver [ INT ] , Bronze [ INT ] , Total [ INT ] | player : Player_ID [ INT ] primary_key , name [ TEXT ] , Position [ TEXT ] , Club_ID [ INT ] player.Club_ID = club.Club_ID , Apps [ INT ] , Tries [ INT ] , Goals [ TEXT ] , Points [ INT ] | competition : Competition_ID [ INT ] primary_key , Year [ INT ] , Competition_type [ TEXT ] , Country [ TEXT ] | competition_result : Competition_ID [ INT ] primary_key competition_result.Competition_ID = competition.Competition_ID , Club_ID_1 [ INT ] competition_result.Club_ID_1 = club.Club_ID , Club_ID_2 [ INT ] competition_result.Club_ID_2 = club.Club_ID , Score [ TEXT ] |
-- -- What is the total number of clubs that have less than 10 medals in total?

SELECT count(*) FROM club_rank WHERE Total  <  10;