SELECT ITEM_CODE AS CODE,ITEM_NAME AS NAME,SUM(ORDER_QTY) AS SUM_QTY
    FROM 
    (SELECT * FROM ORDERS
    JOIN WAREHOUSE
    ON ORDERS.WH_CODE=WAREHOUSE.WH_CODE
    WHERE WH_NAME='浦和倉庫') AS A
    JOIN
    (SELECT * FROM ORDERS_DTL
    LEFT JOIN ITEM
    ON ORDERS_DTL.ITEM_CODE=ITEM.ITEM_CODE) AS B
    ON A.ORDER_NO=B.ORDER_NO
    GROUP BY ITEM_CODE
    HAVING SUM(ORDER_QTY)>=50
    ORDER BY SUM_QTY DESC,CODE DESC;