SELECT
            order_no
            , po_order_no
            , interface
            , count (*) amount
            , issue
        FROM
        (
            SELECT
                case
                when interface = 'LRD_POL'
                    then order_no||''
                else po_order_no||''
                end selected_order_no,
                order_no,
                po_order_no,
                interface,
                issue
            FROM
                ifs_healthy_check_issues
            WHERE
                approved = 'N'
        )
        GROUP BY order_no, po_order_no, issue, order_no, interface
        ORDER BY selected_order_no, interface, amount