Table: nintendo_games
Columns: title
year
platform_s
director
producer

Question: Who was the director of Battalion Wars 2 which was released on GCN after 2004?
SQL: SELECT "director" FROM nintendo_games WHERE "platform_s" = 'gcn' AND "year" > 2004 AND "title" = 'battalion wars 2'

Question: What year was Metroid Prime Hunters 5 released?
SQL: SELECT SUM("year") FROM nintendo_games WHERE "title" = 'metroid prime hunters 5'

Question: What platform was used for the game directed by Bryan Walker after 2006?
SQL: SELECT "platform_s" FROM nintendo_games WHERE "year" > 2006 AND "director" = 'bryan walker'

Question: What 3ds game did Naohiko Aoyama direct?
SQL: SELECT "title" FROM nintendo_games WHERE "platform_s" = '3ds' AND "director" = 'naohiko aoyama'