mysql8分组后排序

SELECT b.id              uid,
               b.mobile,
               count(1)          openedCount,
               sum(share_amount) shareTotalAmount
        FROM (select *, ROW_NUMBER() OVER (PARTITION BY share_uid ORDER BY create_time desc)
              from ums_share_red_packet) a
                 LEFT JOIN ums_member b ON a.share_uid = b.id
        WHERE a.delete_status = 0
          AND b.`status` = 1
          AND ssp_id = #{settingId}
        GROUP BY a.share_uid
        HAVING openedCount >= #{limitShareCount}
        ORDER BY openedCount DESC,
                 a.create_time ASC