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 films were made by 20th century fox studios ?
WRB JJ NNS VBD-AUX VBN IN JJ NNP NNP NNP .
5
select count ( c2 ) from w where c3 = '20th century fox'