SELECT

 hist_data_china.ProvinceName AS 省份,

 hist_data_china.CityName AS 城市,

 max( hist_data_china.CityConfirm ) AS 确诊数,

 hist_data_china.CityHeal AS 死亡数,

 hist_data_china.CityDead AS 治愈数,

 tab.date 

FROM

 ( SELECT DISTINCT ProvinceName, CityName, date( UpdateTime ) AS date FROM hist_data_china  ORDER BY date ) AS tab,

 hist_data_china 

WHERE

 tab.ProvinceName = hist_data_china.ProvinceName 

 AND tab.CityName = hist_data_china.CityName 

 AND hist_data_china.ProvinceName = '湖北省' 

 AND date( hist_data_china.UpdateTime ) = tab.date 

GROUP BY

 hist_data_china.ProvinceName,

 hist_data_china.CityName,

 tab.date 

ORDER BY

 date

图二和图1不一样，是不是SQL代码的问题，显示不完全，空白的气泡只有用鼠标放在上面了才有显示名字