Table: o2_locomotives_iow
Columns: br_sr_no
sr_name
lswr_no
builder
built
to_iow
withdrawn

Question: What is the number for year built of W27 that was withdrawn in 1967 with a To LoW year earlier than 1926?
SQL: SELECT COUNT("built") FROM o2_locomotives_iow WHERE "withdrawn" = 1967 AND "br_sr_no" = 'w27' AND "to_iow" < 1926

Question: What is the number of the year withdrawn for a LSWR number greater than 210 and a To LoW year of 1923?
SQL: SELECT COUNT("withdrawn") FROM o2_locomotives_iow WHERE "lswr_no" > 210 AND "to_iow" = 1923

Question: What is the BR/SR number of Freshwater which was withdrawn in 1967 and built before 1892 with a To LoW year after 1927?
SQL: SELECT "br_sr_no" FROM o2_locomotives_iow WHERE "withdrawn" = 1967 AND "built" < 1892 AND "to_iow" > 1927 AND "sr_name" = 'freshwater'