Table: spec_ops_rangers_lead
Columns: name
year_of_release
developer
publisher
original_platforms

Question: Which developer has a year of cancelled releases?
SQL: SELECT "developer" FROM spec_ops_rangers_lead WHERE "year_of_release" = 'cancelled'

Question: Which publisher has release year of 2000 and an original dreamcast platform?
SQL: SELECT "publisher" FROM spec_ops_rangers_lead WHERE "year_of_release" = '2000' AND "original_platforms" = 'dreamcast'

Question: Which publisher is responsible for spec ops: stealth patrol?
SQL: SELECT "publisher" FROM spec_ops_rangers_lead WHERE "name" = 'spec ops: stealth patrol'