I want to show the average of products added in every section(category), daily wise for any month can you help me in that ?
Section are cars,villas and general
----------------------------------------------- Date Cars Villas General =============================================== 01-01-2011 20% 10% 70% ----------------------------------------------- 02-01-201开发者_如何学Python1 31% 9% 60% ----------------------------------------------- . . . ----------------------------------------------- 31-01-2011 70% 19% 11% ===============================================
Go to the mysql docs and look up the GROUP_BY
and AVG
functions. :)
精彩评论