Query - Extra Tech to User role

 SELECT NAME              AS 'Account Name',

       CASE
         WHEN DATA IS NOT NULL THEN APPROLE
       END               AS 'Application role',
       ENTITLEMENT_VALUE AS 'Entitlement Role',
       ENDPOINTNAME      AS 'Entitlement Endpoint',
       CASE
         WHEN DATA IS NOT NULL THEN 'Yes'
         ELSE 'No'
       END               AS 'Entitlement Role according to Application role'
FROM   (SELECT *
        FROM   (SELECT *,
                       (SELECT DISTINCT RUA1.ACCOUNTKEY
                        FROM   ROLE_USER_ACCOUNT RUA1,
                               ROLE_ENTITLEMENTS RE1,
                               ROLES R1,
                               ENDPOINTS E1,
                               ACCOUNTS A1
                        WHERE  RE1.ROLEKEY = RUA1.ROLEKEY
                               AND R1.ROLEKEY = RUA1.ROLEKEY
                               AND R1.ENDPOINTKEY = E1.ENDPOINTKEY
                               AND E1.ENDPOINTNAME = 'Rushi'
                               AND RE1.ENTITLEMENT_VALUEKEY =
                                   V1.ENTITLEMENT_VALUEKEY
                               AND RUA1.ACCOUNTKEY IN ( V1.ACCOUNTKEY )
                               AND RUA1.ACCOUNTKEY IN ( A1.ACCOUNTKEY )
                               AND A1.STATUS IN (
                                   1, 'Active', 'Manually Provisioned' )
                       ) AS
                               DATA,
                       (SELECT GROUP_CONCAT(R1.ROLE_NAME)
                        FROM   ROLES R1
                        WHERE  R1.ROLEKEY IN ( ASSIGNEDFROMROLES ))
                       AS
                               APPROLE
                FROM   (SELECT *
                        FROM   (SELECT *,
                                       (SELECT DISTINCT RUA1.ACCOUNTKEY
                                        FROM   ROLE_USER_ACCOUNT RUA1,
                                               ROLE_ENTITLEMENTS RE1,
                                               ROLES R1,
                                               ENDPOINTS E1,
                                               ACCOUNTS A1
                                        WHERE  RE1.ROLEKEY = RUA1.ROLEKEY
                                               AND R1.ROLEKEY = RUA1.ROLEKEY
                                               AND R1.ENDPOINTKEY =
                                                   E1.ENDPOINTKEY
                                               AND E1.ENDPOINTNAME =
                                                   'OneHealthIT'
                                               AND RE1.ENTITLEMENT_VALUEKEY =
                                                   ENTITLEMENT_VALUEKEY
                                               AND RUA1.ACCOUNTKEY IN
                                                   ( V01.ACCOUNTKEY )
                                               AND RUA1.ACCOUNTKEY IN (
                                                   A1.ACCOUNTKEY )
                                               AND A1.STATUS IN (
                                                   1, 'Active',
                                                   'Manually Provisioned'
                                                   )
                                       ) AS S
                                FROM   (SELECT A.ACCOUNTKEY,
                                               EV.ENTITLEMENT_VALUEKEY,
                                               A.NAME,
                                               E.ENDPOINTNAME,
                                               EV.ENTITLEMENT_VALUE,
                                               E.ENDPOINTKEY,
                                               AE.ASSIGNEDFROMROLES
                                        FROM   ACCOUNT_ENTITLEMENTS1 AE,
                                               ACCOUNTS A,
                                               ENDPOINTS E,
                                               ENTITLEMENT_VALUES EV,
                                               ENTITLEMENT_TYPES ET
                                        WHERE  AE.ACCOUNTKEY = A.ACCOUNTKEY
                                               AND A.ENDPOINTKEY = E.ENDPOINTKEY
                                               AND E.ENDPOINTNAME IN (
                                                   'Rushi1' )
                                               AND A.STATUS IN (
                                                   1, 'Active',
                                                   'Manually Provisioned'
                                                               )
                                               AND EV.ENTITLEMENT_VALUEKEY =
                                                   AE.ENTITLEMENT_VALUEKEY
                                               AND ET.ENTITLEMENTTYPEKEY =
                                                   EV.ENTITLEMENTTYPEKEY
                                               AND EV.CUSTOMPROPERTY11 IS NULL)
                                       V01)
                               V02) V1)
               V2) V3