Table: cryengine_games
Columns: title
year
developer
publisher
platform

Question: Which title has a year prior to 2008 and xbox 360 as the platform?
SQL: SELECT "title" FROM cryengine_games WHERE "year" < 2008 AND "platform" = 'xbox 360'

Question: Which publisher has Far Cry as the title?
SQL: SELECT "publisher" FROM cryengine_games WHERE "title" = 'far cry'

Question: Which title has xbox as the platform with a year prior to 2006?
SQL: SELECT "title" FROM cryengine_games WHERE "platform" = 'xbox' AND "year" < 2006

Question: Which developer has xbox 360 as the platform?
SQL: SELECT "developer" FROM cryengine_games WHERE "platform" = 'xbox 360'

Question: What is the average year that has far cry vengeance as the title?
SQL: SELECT AVG("year") FROM cryengine_games WHERE "title" = 'far cry vengeance'