最终结果#WriteyourMySQLquerystatementbelowselectdistinctb.item_categoryasCategory,ifnull(sum(casewhendayofweek(a.order_date)=2thena.quantityend),0)Monday,ifnull(sum(casewhendayofweek(a.order_date)=3thena.quantityend),0)Tuesday,