以下mysql查询用于获取2014年用户ID 31购买的每个项目的总销售额 .
SELECT
op.products_name,
ROUND(SUM( IF(MONTH(o.date_purchased) = 1, op.final_price * op.products_quantity,0)), 2) AS january,
ROUND(SUM( IF(MONTH(o.date_purchased) = 2, op.final_price * op.products_quantity,0)), 2) AS febraury,
ROUND(SUM( IF(MONTH(o.date_purchased) = 3, op.final_price * op.products_quantity,0)), 2) AS march,
ROUND(SUM( IF(MONTH(o.date_purchased) = 4, op.final_price * op.products_quantity,0)), 2) AS april,
ROUND(SUM( IF(MONTH(o.date_purchased) = 5, op.final_price * op.products_quantity,0)), 2) AS may,
ROUND(SUM( IF(MONTH(o.date_purchased) = 6, op.final_price * op.products_quantity,0)), 2) AS june,
ROUND(SUM( IF(MONTH(o.date_purchased) = 7, op.final_price * op.products_quantity,0)), 2) AS july,
ROUND(SUM( IF(MONTH(o.date_purchased) = 8, op.final_price * op.products_quantity,0))