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 have united artists as their studio ?
WRB JJ NNS VBD-AUX VBN NNS IN PRP$ NN .
7
select count ( c2 ) from w where c3 = 'united artists'