SQL logic update in metric master table

Requirement: Update the SQL logic in metric_master table for the following:

 

1. For metric_template_name “evenity_unit_hash” and dependency =1, remove the where condition WHERE source_customer.pt_cdl_uuid = {uuid} also change the view_name evenity_vw to eve_view
2. For metric_template_name “evenity_unit_hash” and dependency =2, change the table name in FROM statement to eve_view
3. For metric_template_name “final_css“ and dependency = 2 change the logic from 0.25 (Allowed_Amount / Billed_Amount) to 0.2 (Allowed_Amount / Billed_Amount), Also change the logic from 0.25 (Patient_Paid / Billed_Amount) to 0.3 (Patient_Paid / Billed_Amount)