Table: goty_awards_4
Columns: year
game
genre
platform_s
developer_s

Question: What game was before 2010 and was a role-playing game?
SQL: SELECT "game" FROM goty_awards_4 WHERE "year" < 2010 AND "genre" = 'role-playing game'

Question: What was the platform of Red Dead Redemption?
SQL: SELECT "platform_s" FROM goty_awards_4 WHERE "game" = 'red dead redemption'

Question: Who was the developer of Wii?
SQL: SELECT "developer_s" FROM goty_awards_4 WHERE "platform_s" = 'wii'

Question: What year was The Walking Dead?
SQL: SELECT COUNT("year") FROM goty_awards_4 WHERE "game" = 'the walking dead'

Question: What was the platform when the developer was Telltale Games?
SQL: SELECT "platform_s" FROM goty_awards_4 WHERE "developer_s" = 'telltale games'

Question: What is the game of developer Rockstar Games?
SQL: SELECT "game" FROM goty_awards_4 WHERE "developer_s" = 'rockstar games'