Need SQL query to fetch the details of Item Number details

Summary: We need a SQL query to fetch the Item Number, Inventory item id, Unit cost, Total cost, Sub inventory code, organization name & Quantity of Items. Kindly let us know the query

Content (please ensure you mask any confidential information):

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

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