Calculate Average Force Fields Per Territory

Requirement:

 

Create a SQL query that calculates the percentage of territories using RTEs. The calculation should divide the total number of field-force representatives (rte_ff_total_reps) by the total number of territories (no_of_territories). Name this result as average_force_fields and also include a column called QC_NAME with the fixed value 'CARD-% territory using RTEs'. The query should read data from the view c360_combined_ell_reporting_us and for the records where the brand name is 'REPATHA', the source is 'FLD', the interaction channel is 'ALL', the target category is not 'Targets', and the field force name is 'RED BASE'.