Table: mess_emulator
Columns: name
actual_version
system
platform
license

Question: Which License has a System of amiga, and a Name of pocketuae?
SQL: SELECT "license" FROM mess_emulator WHERE "system" = 'amiga' AND "name" = 'pocketuae'

Question: What name has a License of gpl, and an Actual version of 0.8.29wip4?
SQL: SELECT "name" FROM mess_emulator WHERE "license" = 'gpl' AND "actual_version" = '0.8.29wip4'

Question: Which platform has an Actual version of 0.147?
SQL: SELECT "platform" FROM mess_emulator WHERE "actual_version" = '0.147'

Question: Which name has a License of gpl, and a Platform of windows?
SQL: SELECT "name" FROM mess_emulator WHERE "license" = 'gpl' AND "platform" = 'windows'

Question: Which system is named mess?
SQL: SELECT "system" FROM mess_emulator WHERE "name" = 'mess'

Question: Which Platform has an Actual version of 0.8.29?
SQL: SELECT "platform" FROM mess_emulator WHERE "actual_version" = '0.8.29'