CREATE TABLE table_203_547 (id NUMBER, "ship" CLOB, "built" NUMBER, "in service for cunard" CLOB, "type" CLOB, "tonnage" CLOB, "notes" CLOB)

the year the last intermediate ship was built .
SELECT MAX("built") FROM table_203_547 WHERE "type" = 'intermediate'
SELECT MAX("built") FROM "table_203_547" WHERE "type" = 'intermediate'