What are the claim documents?
select * from claims_documents
Which was created most recently?
select * from claims_documents where created_date = (select created_date from claims_documents order by created_date limit 1)
Show the claim headers for this as well.
select * 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)
What is the total claim amount for these?
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)