Healthkit queries

By converting my HealthKit data to sqlite using healthkit-to-sqlite I have a SQL queriable dataset of my heatlh. Here are some fun queries to run

Handwashing

Handwashing Session Duration

Average handwashing time by date

select
  substr(creationDate, 1, 10) as label,
  date(substr(creationDate, 1, 10)) as recordDate,
  avg(
    round(
      (
        julianday(replace(endDate, " +0900", "")) - julianday(replace(startDate, " +0900", ""))
      ) * 86400.0
    )
  ) as average
from
  rHandwashingEvent
group by
  label;