SELECT
	TOP(5)
	ITEM_CODE AS CODE
	ITEM_NAME AS NAME
--	受注金額の合計 AS TOTAL_AMT



FROM
--  テーブル①
--	LEFT JOIN テーブル② ON テーブル①のカラム = テーブル②のカラム
    ORDERS
    LEFT JOIN ORDERS_DTL ON 


WHERE 
	ORDER_DATE BETWEEN <= '2023-5-14' AND '2023-5-20'


ORDER BY
	TOTAL_AMT DESC,
	CODE DESC