on usa air how many flights leaving oakland on july twenty seventh to boston nonstop 
return flights ;return #1 from  oakland ;return #2 to boston ;return #3 on  usa air ;return #4 leaving on  july twenty seventh ;return #5 which  are nonstop ;return the number of #6
['select', 'filter', 'filter', 'filter', 'filter', 'filter', 'aggregate']