SQL query for resource mapping to item

Summary:

Need a SQL query which identifies which resource is mapped to which assembly item

Content (required):

New a SQL query which helps in listing the assembly items along with the resources assigned to it as part of the work definitions.

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):