sql根据时间查询当天-昨天记录

-- 今日记录
SELECT t.salesid,IFNULL(tod.todaynum,0) AS todaynum
FROM tbcompany t
LEFT JOIN 
(SELECT COUNT(tgtime) AS todaynum,salesid FROM tbcompany WHERE YEAR(tgtime)=YEAR(NOW()) AND MONTH(tgtime)=MONTH(NOW()) AND DAY(tgtime)=DAY(NOW()) GROUP BY salesid) tod 
ON t.salesid=tod.salesid
GROUP BY salesid


-- 昨日记录
SELECT t.salesid,IFNULL(yed.ysdaynum,0) AS ysdaynum
FROM tbcompany t
LEFT JOIN 
(SELECT salesid,COUNT(tgtime) AS ysdaynum FROM tbcompany WHERE TO_DAYS(NOW( ) ) - TO_DAYS(tgtime) = 1 GROUP BY salesid) yed 
ON t.salesid=yed.salesid
GROUP BY salesid


-- 全部记录
SELECT salesid,COUNT(tgtime) AS alltgnum FROM tbcompany GROUP BY salesid


-- 联查
SELECT a.salesid,a.todaynum,b.ysdaynum,c.alltgnum
FROM 
(SELECT t.salesid,IFNULL(tod.todaynum,0) AS todaynum
FROM tbcompany t