mysql select as 多个_mysql – SQL组合多个SELECT语句

我正在尝试构建一个SQLite查询,它将从单个表中收集统计信息.

该表包含各种日志,每天有几个条目.我需要在搜索参数中每天获得一个单独的行,然后使用某些布尔值编译这些日期内的行总数.

这是我到目前为止的查询：

SELECT DATE(DateTime) AS SearchDate,

(SELECT COUNT() AS Total

FROM CallRecords

WHERE DATE(DateTime)

BETWEEN '2017-08-27' AND '2017-09-02'

GROUP BY DATE(DateTime)

ORDER BY Total DESC) AS Total,

(SELECT COUNT() AS Total

FROM CallRecords

WHERE NoMarket = 1

AND DATE(DateTime)

BETWEEN '2017-08-27' AND '2017-09-02'

GROUP BY DATE(DateTime)

ORDER BY Total DESC) AS NoMarkets,

(SELECT COUNT() AS Total

FROM CallRecords

WHERE Complaint = 1

AND DATE(DateTime)

BETWEEN '2017-08-27' AND '2017-09-02'

GROUP BY DATE(DateTime)

ORDER BY Total DESC) AS Complaints,

(SELECT COUNT() AS Total

FROM CallRecords

WHERE Voicemail = 1

AND DATE(DateTime)

BETWEEN '2017-08-27' AND '2017-09-02'

GROUP BY DATE(DateTime)

ORDER BY Total DESC) AS Voicemails

FROM CallRecords

WHERE DATE(DateTime) BETWEEN '2017-08-27' AND '2017-09-02'

GROUP BY SearchDate

并输出：

8/28/2017 175 27 11

8/29/2017 175 27 11

8/30/2017 175 27 11

8/31/2017 175 27 11

9/1/2017 175 27 11

正如您所看到的,它正确地获取每个日期,但列的总数不正确.

显然,我在查询中遗漏了一些内容,但我不知道在哪里.有没有更好的方法来执行此查询？

编辑：我已经在这里查看了几个其他几乎相同标题的问题,但我没有发现任何类似于我正在寻找的东西.大多数似乎比我想要完成的要复杂得多.