Pharmaceutical Inventory Calculations

Requirement:

 

Develop a Databricks SQL to perform business logics using pharma_inventory table and display the output. Refer the attached excel for the formula mentioned in Calculation_Logic column.

 

Unity Catalog Information: purgo_playground.pharma_inventory