# date film gross notes
#
date
film
gross
notes
number
number parsed year month day
number
number date text unitnum text
1 january 6, 2002 the lord of the rings: the fellowship of the ring $23,006,447 black hawk down broke save the last dance's record ($23.4 mil) for the highest martin luther king weekend debut
what is the lowest grossing film listed before march 3 , 2002 ?
WP VBD-AUX DT JJS VBG NN VBN IN NNP CD , CD .
Queen of the Damned
Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Literal.String Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword
select c3 from w where c2_parsed < ( select c2_parsed from w where c2 = 'march 3, 2002' ) group by c3 order by sum ( c4_number ) asc limit 1
None None Keyword Keyword Column Column None Column Literal Literal Literal Literal None
['sort', '_group'] ['sort', '_group'] c4_number c3 c2_parsed