CREATE TABLE musical (musical_id NUMBER, name CLOB, year NUMBER, award CLOB, category CLOB, nominee CLOB, result CLOB)
CREATE TABLE actor (actor_id NUMBER, name CLOB, musical_id NUMBER, character CLOB, duration CLOB, age NUMBER)

What is the duration of the oldest actor?
SELECT duration FROM actor ORDER BY age DESC LIMIT 1
SELECT "duration" FROM "actor" ORDER BY "age" DESC FETCH FIRST 1 ROWS ONLY