Saviynt Solutions

 SELECT   'Level 1 - Avg Time spent in the first Approval (QAD Mexico SoD Validation Approval) in hours'           AS category ,                   Concat(Round((Sum(Timestampdiff(hour, submitdate, approvedate)) / Count(username)),0) ,' hours') AS 'Data' FROM     ars_requests ar,          access_approvers aa,          users u,          request_access ra,          request_access_attrs raa,          endpoints en WHERE    ar.requestkey = ra.requestkey AND      raa.request_access_key = ra.parentrequest AND      raa.attribute_value = en.endpointkey AND      raa.attribute_name = 'ENDPOINT' AND      ra.request_accesskey = aa.request_access_key AND      1 = 1 AND      ar....

  SELECT   ce . certkey        AS   'Certification ID' ,         c . campaign_name   AS   'campaign name' ,         CASE   c . status           WHEN   1   THEN   'In Progress'           WHEN   2   THEN   'Completed'           WHEN   5   THEN   'In Progress'           WHEN   4   THEN   'Preview'           WHEN   6   THEN   'Discontinued'           WHEN   7   THEN   'Expired'           WHEN   8   THEN   'Launching'   ...