CREATE TABLE table_30890 ("Number" CLOB, "Serial Number" FLOAT, "Into Service" CLOB, "Withdrawn" CLOB, "Scrapped" CLOB)

Name the withdrawn for example and serial number 579
SELECT "Withdrawn" FROM table_30890 WHERE "Into Service" = 'Example' AND "Serial Number" = '579'
SELECT "Withdrawn" FROM "table_30890" WHERE "Into Service" = 'Example' AND "Serial Number" = '579'