Combine Heart Rate and Step in MySQL from HealthKit data export

hr_step.sql

select STR_TO_DATE(CONCAT(H.date, ' ', H.time), '%d/%m/%Y %H:%i') as datetime, H.min, H.max, coalesce(S.steps,0) as steps from heartrate H
left join steps S on 
 (H.date = S.date or H.date is null and S.date is null)
 and
 (H.time = S.time or H.time is null and S.time is null)
order by H.date, H.time

hr_whilst_sleeping.sql

select 
  STR_TO_DATE(CONCAT(H.date, ' ', H.time), '%d/%m/%Y %H:%i') as datetime, 
  H.min, 
  H.max, 
  coalesce(S.steps,0) as steps
from heartrate H
left join steps S on 
 (H.date = S.date or H.date is null and S.date is null)
 and
 (H.time = S.time or H.time is null and S.time is null)
group by date(datetime)
having hour(datetime) >= 0 and hour(datetime) <= 7
order by datetime
limit 10000