Table: gymnastics_2004_qual
Columns: rank
team
floor_exercise
pommel_horse
rings
vault
parallel_bars
horizontal_bar
total

Question: How many Horizontal Bars have a Team of japan (jpn), and Parallel Bars smaller than 38.924?
SQL: SELECT COUNT("horizontal_bar") FROM gymnastics_2004_qual WHERE "team" = 'japan (jpn)' AND "parallel_bars" < 38.924

Question: How many pommel Horses have Rings of 37.461, and a Total smaller than 229.507?
SQL: SELECT COUNT("pommel_horse") FROM gymnastics_2004_qual WHERE "rings" = 37.461 AND "total" < 229.507

Question: What is the sum of totals with a Vault of 38.437, and a Floor Exercise smaller than 37.524?
SQL: SELECT COUNT("total") FROM gymnastics_2004_qual WHERE "vault" = 38.437 AND "floor_exercise" < 37.524

Question: How many pommel horses have a Total smaller than 230.019, a Team of china (chn), and a Vault smaller than 38.437?
SQL: SELECT COUNT("pommel_horse") FROM gymnastics_2004_qual WHERE "total" < 230.019 AND "team" = 'china (chn)' AND "vault" < 38.437