Table: game_details
Columns: franchise_or_game
console
main_developer
main_genre
first_release
latest_release

Question: What consoles was Shenmue released on?
SQL: SELECT "console" FROM game_details WHERE "franchise_or_game" = 'Shenmue'

Question: Which main developer made their first release in 1991 and created the Mega Drive/Genesis console?
SQL: SELECT "main_developer" FROM game_details WHERE "first_release" = 1991 AND "console" = 'Mega Drive/Genesis'