year film publisher director distributor worldwide gross notes
year
film
publisher
director
distributor
worldwide gross
notes
number
first second first_number
number text text text text unitnum(text) text
1951 superman and the mole men dc comics lee sholem lippert pictures inc $1,700,000 (est.
us/ canada rentals) based on adventures of superman tv series
which 2012 superhero film did not gross at least 100,000,000 ?
WDT CD NNP NN VBD-AUX RB JJ IN JJS CD .
Dredd
select c2 from w where c1_number = 2012 and c6_first_number < 100000000