SELECT
    REPID AS ID,
    LAST_NAME AS LN,
    FIRST_NAME AS FN,
    VALUE AS VAL,
    'Total number of orders ' AS INDICATOR
FROM
    (
        SELECT
            R.REPID,
            R.LAST_NAME,
            R.FIRST_NAME,
            ''
            || COUNT(T_O.ORDER#) AS VALUE,
            RANK() OVER(
                ORDER BY
                    COUNT(T_O.ORDER#) DESC
            ) AS RANK
        FROM
            REP R,
            T_ORDERS T_O
        WHERE
            R.REPID = T_O.REPID
        GROUP BY
            R.REPID,
            R.LAST_NAME,
            R.FIRST_NAME
    )
WHERE
    RANK = 1
UNION
SELECT
    REPID AS ID,
    LAST_NAME AS LN,
    FIRST_NAME AS FN,
    VALUE AS VAL,
    'Quantity of items sold ' AS INDICATOR
FROM
    (
        SELECT
            R.REPID,
            R.LAST_NAME,
            R.FIRST_NAME,
            ''
            || SUM(OD.NUM_ORDERED) AS VALUE,
            RANK() OVER(
                ORDER BY
                    SUM(OD.NUM_ORDERED) DESC
            ) AS RANK
        FROM
            REP R,
            T_ORDERS T_O,
            ORDER_DETAILS OD
        WHERE
            R.REPID = T_O.REPID
            AND   OD.ORDER# = T_O.ORDER#
        GROUP BY
            R.REPID,
            R.LAST_NAME,
            R.FIRST_NAME
    )
WHERE
    RANK = 1
UNION
SELECT
    REPID AS ID,
    LAST_NAME AS LN,
    FIRST_NAME AS FN,
    VALUE AS VAL,
    'Total Value of Sales ' AS INDICATOR
FROM
    (
        SELECT
            R.REPID,
            R.LAST_NAME,
            R.FIRST_NAME,
            '$'
            || SUM(OD.NUM_ORDERED * OD.QUOTED_PRICE) AS VALUE,
            RANK() OVER(
                ORDER BY
                    SUM(OD.NUM_ORDERED * OD.QUOTED_PRICE) DESC
            ) AS RANK
        FROM
            REP R,
            T_ORDERS T_O,
            ORDER_DETAILS OD
        WHERE
            R.REPID = T_O.REPID
            AND   OD.ORDER# = T_O.ORDER#
        GROUP BY
            R.REPID,
            R.LAST_NAME,
            R.FIRST_NAME
    )
WHERE
    RANK = 1;