CREATE TABLE staff (staff_id NUMBER, staff_details CLOB)
CREATE TABLE claim_headers (claim_header_id NUMBER, claim_status_code CLOB, claim_type_code CLOB, policy_id NUMBER, date_of_claim TIME, date_of_settlement TIME, amount_claimed NUMBER, amount_piad NUMBER)
CREATE TABLE claims_documents (claim_id NUMBER, document_type_code CLOB, created_by_staff_id NUMBER, created_date NUMBER)
CREATE TABLE claims_processing (claim_processing_id NUMBER, claim_id NUMBER, claim_outcome_code CLOB, claim_stage_id NUMBER, staff_id NUMBER)
CREATE TABLE policies (policy_id NUMBER, customer_id NUMBER, policy_type_code CLOB, start_date TIME, end_date TIME)
CREATE TABLE customers (customer_id NUMBER, customer_details CLOB)
CREATE TABLE claims_processing_stages (claim_stage_id NUMBER, next_claim_stage_id NUMBER, claim_status_name CLOB, claim_status_description CLOB)

How much amount in total were claimed in the most recently created document?
SELECT SUM(t1.amount_claimed) FROM claim_headers AS t1 JOIN claims_documents AS t2 ON t1.claim_header_id = t2.claim_id WHERE t2.created_date = (SELECT created_date FROM claims_documents ORDER BY created_date LIMIT 1)
SELECT SUM("t1"."amount_claimed") FROM "claim_headers" "t1" JOIN "claims_documents" "t2" ON "t1"."claim_header_id" = "t2"."claim_id" AND "t2"."created_date" = (SELECT "created_date" FROM "claims_documents" ORDER BY "created_date" FETCH FIRST 1 ROWS ONLY)