Table: destroyers_2007_stats
Columns: player
car
yards
avg
td_s
long

Question: Name the total number of TD's for long more than 6 and cars less than 4
SQL: SELECT COUNT("td_s") FROM destroyers_2007_stats WHERE "long" > 6 AND "car" < 4

Question: Name the sum of Long for yards less than 197 and players of matt nagy
SQL: SELECT SUM("long") FROM destroyers_2007_stats WHERE "yards" < 197 AND "player" = 'matt nagy'