SQL Query to get lot cost of an item

Summary:

there is a requirement where we need to get item cost that is at either in lot level or organization level need a SQL Query for the same

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):