rank athlete country time notes
rank
athlete
country
time
notes
number
number min sec
number text text time text
4 kaija mustonen finland 2:22.4 or
what number of countries placed ahead of the united states ?
WDT NN IN NNS VBN RB IN DT NNP NNPS .
7
select count ( distinct ( c3 ) ) from w where id < ( select id from w where c3 = 'united states' )