date time opponent# rank# site tv result attendance
date
time
opponent #
rank #
site
tv
result
attendance
number parsed year month day
number hour min
raw home
number
first second first_address
result number number1 number2
number
date time text rank address(text) text score number
september 1 2:30 pm nevada #19 faurot field • columbia, mo (rivalry) abc w 52-10 84078
which opponent comes before usc ?
WDT NN VBZ IN NNP .
Wake Forest
select c3_raw from w where c1_parsed < ( select c1_parsed from w where c3_raw = 'usc' ) order by c1_parsed desc limit 1