SELECT DATE_FORMAT(monitor_time, '%Y-%m-%d'), avg(blood_systolic) FROM health_cloud_new.t_neowave_blood_pressure
where family_id = 1 and family_no = 1
and monitor_time>='2013-05-01 00:00:00' and monitor_time<= '2013-06-01 24:00:00' group by 1
order by 1 desc;
where family_id = 1 and family_no = 1
and monitor_time>='2013-05-01 00:00:00' and monitor_time<= '2013-06-01 24:00:00' group by 1
order by 1 desc;