Table: goty_games_8
Columns: year
game
genre
platform_s
developer_s

Question: What is total number of years that has genre of first-person shooter?
SQL: SELECT SUM("year") FROM goty_games_8 WHERE "genre" = 'first-person shooter'

Question: Which year is the lowest for genre of action-adventure?
SQL: SELECT MIN("year") FROM goty_games_8 WHERE "genre" = 'action-adventure'