ÁÖ¹® Á¤º¸ ¿ä¾à º¸°í¼­

»óÁ¡ÀÇ ¼º´ÉÀ» °ËÅäÇÏ°í ºÐ¼®ÇÏ·Á¸é ÀÌ º¸°í¼­¸¦ »ç¿ëÇϽʽÿÀ.

¿É¼Ç: ½ÃÀÛ ³¯Â¥, Á¾·á ³¯Â¥
Á¤·Ä ±âÁØ: ³â, ´Þ
±×·ì ±âÁØ: ³â, ´Þ, ÅëÈ­

ÂüÁ¶µÈ ¿­ À̸§ Å×À̺í À̸§ ¿­ À̸§
³âµµ ORDERITEMS TIMESHIPPED
¿ù ORDERITEMS TIMESHIPPED
ÃÑ »óǰ ºñ¿ë sum(ORDERITEMS.TOTALPRODUCT)
»óǰ¿¡ ´ëÇÑ ÃÑ ¼¼±Ý sum(ORDERITEMS.TAXAMOUNT)
¿î¼Û °æºñ ÃѰè sum(ORDERITEMS.SHIPCHARGE)
¿î¼Û¿¡ ´ëÇÑ ÃÑ ¼¼±Ý sum(ORDERITEMS.TOTALADJUSTMENT)
ÃѰè Á¶Á¤ sum(ORDERITEMS.TOTALADJUSTMENT)
ÁÖ¹® °ª ÃѰè sum(ORDERITEMS.TOTALPRODUCT + ORDERITEMS.TAXAMOUNT + ORDERITEMS.SHIPCHARGE + ORDERITEMS.SHIPTAXAMOUNT + ORDERITEMS.TOTALADJUSTMENT)
ÁÖ¹® ¼ö count (distinct ORDERS.ORDERS_ID)
ÁÖ¹®´ç Æò±Õ ÆÇ¸Å¾× sum(ORDERITEMS.TOTALPRODUCT + ORDERITEMS.TAXAMOUNT + ORDERITEMS.SHIPCHARGE + ORDERITEMS.SHIPTAXAMOUNT + ORDERITEMS.TOTALADJUSTMENT) / count (distinct ORDERS.ORDERS_ID)
ÅëÈ­ ORDERS CURRENCY

°ü·Ã °³³ä(1275¹ÙÀÌÆ®)

°ü·Ã ŽºÅ©(1201¹ÙÀÌÆ®)

IBM copyright