select a.`创建日期`,b.`订单数`,c.结算数,d.失效数,e.付款数
FROM
(SELECT
tkorder.`创建日期`
FROM
tkorder
group by tkorder.`创建日期`) AS a
LEFT JOIN (
SELECT
tkorder.`创建日期`,
count(*) 订单数
FROM
tkorder
group by tkorder.`创建日期`
) AS b ON a.`创建日期`= b.`创建日期`
LEFT JOIN (
SELECT
tkorder.`创建日期`,
count(*) 结算数
FROM
tkorder where `订单状态`='订单结算'
group by tkorder.`创建日期`
) AS c ON a.`创建日期`= c.`创建日期`
LEFT JOIN (
SELECT
tkorder.`创建日期`,
count(*) 失效数
FROM
tkorder where `订单状态`='订单失效'
group by tkorder.`创建日期`
) AS d ON a.`创建日期`= d.`创建日期`