SELECT
O.CUST_CODE AS CODE,
C.CUST_NAME AS NAME,
COUNT(O.ORDER_NO) AS CNT,
SUM(O.ORDER_AMNT) AS TTL_AMT,
ROUND((SUM(O.ORDER_AMNT)/COUNT(O.ORDER_NO)),1) AS AVG_AMT

FROM ORDERS AS O
 INNER JOIN CUSTOMER AS C
  ON O.CUST_CODE = C.CUST_CODE
  
WHERE CNT >= 5

GROUP BY 
 CODE,NAME

ORDER BY
 CNT DESC,
 AVG_AMT DESC,
 CODE ASC
 
 LIMIT 5;