Sales Metrics Aggregation for Latest Week Ending for C360 Table

Requirement:

 

Prepare a SQL query to compute the below mentioned metrics and display them.

 

% territory using RTE - SUM(rte_ff_total_reps)/SUM(no_of_territories)

 

% calls with meals - SUM(calls_with_meals_total_interactions)/SUM(rep_calls_total_calls)

 

% calls with ICVA - SUM(visual_aid_calls_total_calls/SUM(rep_calls_total_calls)

 

Delivered RTEs - SUM(rte_total_email_delivered)

 

Unity Catalog: purgo_playground.s_source_sales_team_brand_interactions