»óÁ¡ÀÇ ¼º´ÉÀ» °ËÅäÇÏ°í ºÐ¼®ÇÏ·Á¸é ÀÌ º¸°í¼¸¦ »ç¿ëÇϽʽÿÀ.
¿É¼Ç: ½ÃÀÛ ³¯Â¥, Á¾·á ³¯Â¥
Á¤·Ä ±âÁØ: ³â, ´Þ
±×·ì ±âÁØ: ³â, ´Þ, ÅëÈ
ÂüÁ¶µÈ ¿ À̸§ | Å×À̺í À̸§ | ¿ À̸§ |
---|---|---|
³âµµ | 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 |
![]() |