mysql中季度表怎么出的_如何在mysql中生成季度报表和一年中每个季度的总和

我想在mysql数据库中生成一个季度报告和一年中每个季度的总和。 我写了下面的查询，它不工作SELECT t.name as terminals,

sum(bl.barrels_net_qty) as 'IST QTR',

sum(bl2.barrels_net_qty) as '2ND QTR',

sum(bl3.barrels_net_qty) as '3RD QTR',

sum(bl4.barrels_net_qty) as '4TH QTR',

sum(coalesce(bl.barrels_net_qty,0))

+ sum(coalesce(bl2.barrels_net_qty,0))

+ sum(coalesce(bl3.barrels_net_qty,0))

+ sum(coalesce(bl4.barrels_net_qty,0)) as total

FROM loadingdetails as l

LEFT JOIN bldetails as bl on bl.operation_no = l.operation_no AND l.year = '2020' AND bl.month = 'January' and bl.month = 'Feburary' and bl.month = 'March'

LEFT JOIN bldetails as bl2 on bl2.operation_no = l.operation_no and l.year = '2020' AND bl2.month = 'April' and bl2.month = 'May' and bl2.month = 'June' AND l.month = 'April' and bl2.month = 'May' and bl2.month = 'June'

LEFT JOIN bldetails as bl3 on bl3.operation_no = l.operation_no and l.year = '2020' AND bl3.month = 'July' and bl3.month = 'August' and bl3.month = 'September'

LEFT JOIN bldetails as bl4 on bl4.operation_no = l.operation_no and l.year = '2020' AND bl4.month = 'October' and bl4.month = 'November' and bl4.month = 'December'

LEFT JOIN terminals as t on t.id = l.terminal_id

GROUP BY t.name

下面是输出。