Hello Guys, My problem is i don't know how to query TOP ORDER PROD using COUNT,AVG...
anybody can help me please? thanks ^_^
EXAMPLE
-LIST OF ORDER'S-
ITEM CODE | ITEM NAME |
4323 PROD A
4323 PROD A
4323 PROD A
4323 PROD A
4323 PROD A
2345 PROD B
2345 PROD B
2345 PROD B
3462 PROD C
3462 PROD C
i don't know how display TOP ORDER PROD. using count and average
-TOP ODER PRODUCT-
ITEM CODE | ITEM NAME | TOTAL NO. OF ORDERS | PERCENTAGE RATE
4323 PROD A 5 4.23%
2345 PROD B 3 2.33%
3462 PROD C 2 1.56%