SELECT                                          
      cm.metric_id
  FROM contracts c
  JOIN contract_metrics cm
      ON c.uuid = cm.contract_uuid
  JOIN subscription s
      ON c.subscription_number = s.subscription_number
      AND c.start_date = s.start_date
  LEFT JOIN subscription_measurements sm
      ON s.subscription_id = sm.subscription_id
      AND s.start_date = sm.start_date
      AND (
          (sm.metric_id = 'Managed-nodes'       AND cm.metric_id = 'managed_node') OR
          (sm.metric_id = 'Instance-hours'      AND cm.metric_id = 'infrastructure') OR
          (sm.metric_id = 'Instance-hours'      AND cm.metric_id = 'control_plane') OR
          (sm.metric_id = 'Instance-hours'      AND cm.metric_id = 'cluster_hour') OR
          (sm.metric_id = 'vCPUs'               AND cm.metric_id = 'vcpu_hourly') OR
          (sm.metric_id = 'vCPUs'               AND cm.metric_id = 'vCPU_hours') OR
          (sm.metric_id = 'vCPUs'               AND cm.metric_id = 'acm_vcpu_hours') OR
          (sm.metric_id = 'Cores'               AND cm.metric_id = 'four_vcpu_hour') OR
          (sm.metric_id = 'Cores'               AND cm.metric_id = 'cluster_cpu_hour') OR
          (sm.metric_id = 'Cores'               AND cm.metric_id = 'vCPU_Hour') OR
          (sm.metric_id = 'Transfer-gibibytes'  AND cm.metric_id = 'transfer_gb') OR
          (sm.metric_id = cm.metric_id)
      )
  WHERE sm.subscription_id IS NULL group by cm.metric_id;
 

select count(*)
from (
select distinct subscription_number, start_date, product_id, vendor_product_code
from contracts
) a
left join subscription s on a.subscription_number = s.subscription_number and a.start_date = s.start_date 
where s.subscription_id  is null;