How many of Gary Trousdale's movies are adventure movies?
Gary Trousdale refers director = 'Gary Trousdale'; the adventure movie refers to genre = 'Adventure';
SELECT COUNT(T.name) FROM ( SELECT T1.name FROM director AS T1 INNER JOIN movies_total_gross AS T2 ON T1.name = T2.movie_title WHERE T1.director = 'Gary Trousdale' AND T2.genre = 'Adventure' GROUP BY T1.name ) T
database name:db_id disney
characters table characters Cols: movie title dtype text, release date dtype text, hero dtype text, villian dtype text, song dtype text, 
director table director Cols: name dtype text, director dtype text, 
movies_total_gross table movies_total_gross Cols: movie title dtype text, release date dtype text, genre dtype text, Motion Picture Association of America rating dtype text, total gross dtype text, inflation adjusted gross dtype text, 
revenue table revenue Cols: Year dtype integer, Studio Entertainment[NI 1] dtype real, Disney Consumer Products[NI 2] dtype real, Disney Interactive[NI 3][Rev 1] dtype integer, Walt Disney Parks and Resorts dtype real, Disney Media Networks dtype text, Total dtype integer, 
voice-actors table voice-actors Cols: character dtype text, voice-actor dtype text, movie dtype text, 
