Quarterly Analysis of REPATHA Product

Requirement: Develop a SQL query to analyse the total “value” from stitched_pmr_consolidation_data table for the product “REPATHA“ under “ALL“ specialty. Using time_stamp column query should display total value (value) per quarter and percentage of increase or decrease from previous quarter. Final output should have product_name, quarter (Q1,Q2,Q3 or Q4) and total_value, percentage_difference.

 

Unity catalog: stitched_pmr_consolidation_data