CREATE TABLE ship (ship_id NUMBER, name CLOB, type CLOB, built_year NUMBER, class CLOB, flag CLOB)
CREATE TABLE captain (captain_id NUMBER, name CLOB, ship_id NUMBER, age CLOB, class CLOB, rank CLOB)

What is the name of the ship that is commanded by the youngest captain?
SELECT t1.name FROM ship AS t1 JOIN captain AS t2 ON t1.ship_id = t2.ship_id ORDER BY t2.age LIMIT 1
SELECT "t1"."name" FROM "ship" "t1" JOIN "captain" "t2" ON "t1"."ship_id" = "t2"."ship_id" ORDER BY "t2"."age" FETCH FIRST 1 ROWS ONLY