テキスト ボックス: SELECT COUNT(*) AS CNT_ALL, COUNT(AMOUNT) AS CNT, SUM(AMOUNT) AS TOTAL_SUM, ORDER_DT FROM CUSTOMER_ORDER WHERE ORDER_DT BETWEEN '7/1/2003' AND '9/30/2003' GROUP BY ORDER_DT
テキスト ボックス: SELECT SUM(AMOUNT) FROM CUSTOMER_ORDER WHERE ORDER_DT BETWEEN '7/1/2003' AND '9/30/2003' GROUP BY ORDER_DT