MySQL统计当日和最新数据

#地图警情统计sql
#查询schemaid=GASJ001各个派出所的 所有案件类型的当日之和，统计当日的数据
SELECT columnvalue1,SUM(columnvalue5) FROM z_gasj 
WHERE schemaid='GASJ001' AND TO_DAYS(gathertime) = TO_DAYS(NOW())
GROUP BY columnvalue1

#查询schemaid=GASJ001各个派出所的 所有案件类型的数量和，统计最新数据
SELECT columnvalue1,SUM(columnvalue5) 当日和 FROM z_gasj AS b 
WHERE NOT EXISTS(SELECT 1 FROM z_gasj 
WHERE Id= b.Id AND b.gathertime<gathertime)
AND schemaid='GASJ001' 
GROUP BY columnvalue1

#警情统计总览sql
#查询schemaid=GASJ001各个案件类型六个派出所最新值之和，统计最新
SELECT columnvalue2,SUM(columnvalue5) 当日和 FROM z_gasj AS b 
WHERE NOT EXISTS(SELECT 1 FROM z_gasj 
WHERE Id= b.Id AND b.gathertime<gathertime)
AND schemaid='GASJ001' 
AND columnvalue1 IN (520114510000,520114230000,520114540000,520114550000,520114520000,520114530000)
GROUP BY columnvalue2