CREATE TABLE table_56475 ("Navy" CLOB, "Name" CLOB, "Pennant" CLOB, "Commissioned" FLOAT, "Home port" CLOB)

What is the navy for middleton with a home port of portsmouth after 1983?
SELECT "Navy" FROM table_56475 WHERE "Home port" = 'portsmouth' AND "Commissioned" > '1983' AND "Name" = 'middleton'
SELECT "Navy" FROM "table_56475" WHERE "Commissioned" > '1983' AND "Home port" = 'portsmouth' AND "Name" = 'middleton'