CREATE TABLE table_142159_1 (no VARCHAR, location VARCHAR)

Which number has Engine Shed as the location
SELECT no FROM table_142159_1 WHERE location = "Engine shed"
SELECT "no" FROM "table_142159_1" WHERE "Engine shed" = "location"