Table: goty_awards_3
Columns: year
game
genre
platform_s
developer_s

Question: What year had Third-Person Shooter?
SQL: SELECT AVG("year") FROM goty_awards_3 WHERE "genre" = 'third-person shooter'

Question: What year was Portal?
SQL: SELECT MAX("year") FROM goty_awards_3 WHERE "game" = 'portal'

Question: Who was the developer(s) of the genre Adventure?
SQL: SELECT "developer_s" FROM goty_awards_3 WHERE "genre" = 'adventure'

Question: What's the platform of the genre RPG?
SQL: SELECT "platform_s" FROM goty_awards_3 WHERE "genre" = 'rpg'

Question: What's the genre of developer(s) Lionhead Studios?
SQL: SELECT "genre" FROM goty_awards_3 WHERE "developer_s" = 'lionhead studios'

Question: What's year was the genre Adventure?
SQL: SELECT "year" FROM goty_awards_3 WHERE "genre" = 'adventure'