rank title studio director actors gross
rank
title
studio
director
actors
gross
number
list length
number
number text text text <c, text> unitnum
1 the sound of music 20th century fox robert wise julie andrews, christopher plummer, charmian carr, nicholas hammond, heather menzies, duane chase, angela cartwright, debbie turner, kym karath, richard haydn, peggy wood, eleanor parker, anna lee, portia nelson, marni nixon, daniel truhitte, ben wright $163,214,286
how many movies did 20th century fox create that were in the top 10 grossing films of 1965 ?
WRB JJ NNS VBD-AUX JJ NNP NNP VB DT VBD-AUX IN DT JJ CD VBG NNS IN CD .
3
select count ( c2 ) from w where c2 in ( select c2 from w order by c6_number desc limit 10 ) and c3 = '20th century fox'