Database: cre_Doc_and_collections
Question: List all document which is related to document owned by Ransom . List the document id .
SQL:
select t1.document_object_id from document_subset_members as t1 join document_objects as t2 on t1.document_object_id  =  t2.document_object_id where t2.owner  =  'ransom'