CREATE TABLE table_47080 ("Name" CLOB, "Class" CLOB, "Navy" CLOB, "Date joined" CLOB, "Date departed" CLOB)

What's the class of the HMS Fowey?
SELECT "Class" FROM table_47080 WHERE "Name" = 'hms fowey'
SELECT "Class" FROM "table_47080" WHERE "Name" = 'hms fowey'