Premium Retail Services

SELECT COUNT(*)
  FROM [coordinator].[ServiceRequest] WHERE [Status] = 'Complete' AND [CompletionReason] IN ('Answered', 'AutoAnswered') AND [PartitionDate] > DATEADD(DAY, -2, SYSUTCDATETIME())

  SELECT COUNT(*)
  FROM [coordinator].[ServiceRequest] WHERE [Status] = 'Complete' AND [CompletionReason] = 'Canceled' AND [PartitionDate] > DATEADD(DAY, -2, SYSUTCDATETIME())

    SELECT COUNT(*)
  FROM [coordinator].[ServiceRequest] WHERE [Status] = 'Complete' AND [CompletionReason] = 'Expired' AND [PartitionDate] > DATEADD(DAY, -2, SYSUTCDATETIME())