Annotations on a document are represented using dm_relation objects. On the dm_relation object, both parent_id and child_id point to a dm_sysobject. The object pointed to by the parent_id is the…

Annotations on a document are represented using dm_relation objects. On the dm_relation object, both parent_id and child_id point to a dm_sysobject. The object pointed to by the parent_id is the document and the object pointed to by the child_id is the annotation. The annotation object is owned by the person who commented on the document. Which query will return all documents owned by `John Smith' that have annotations along with the name of the user that commented on the document?