Update SQL Logic for Biosimilar Brand name and competitor flag

Introduction: Update the SQL query to incorporate the missing conditional logic for competitor_flag and change the brand_normalized_name in the script. This change is critical to prevent over-suppression of biosimilar sales and ensure consistent and accurate reporting across environments.

 

Requirements: Update the 'bai_sales.sql' as below criteria.

 

Add the select logic competitor_flag and cast it to string datatype. update the logic in case statement to change thebrand_normalized_name from 'xyz' to 'riabni'.

 

Final Output: Show the result in sql logic.