select km cycled by day of week

medium.date_fields_vs_extract.query_cycling_entry_for_km_cylcled_group_by_day_of_week.sql

  select sum(km_cycled) as total_km_cycled,
         case when day_of_week=0 then 'Sunday'
              when day_of_week=1 then 'Monday'
              when day_of_week=2 then 'Tuesday'
              when day_of_week=3 then 'Wednesday'
              when day_of_week=4 then 'Thursday'
              when day_of_week=5 then 'Friday'
              when day_of_week=6 then 'Saturday'
         end as day
    from cycling_entry
group by day_of_week;
-- average time: 7.75ms

  select sum(km_cycled) as total_km_cycled,
         case when extract(dow from date)=0 then 'Sunday'
              when extract(dow from date)=1 then 'Monday'
              when extract(dow from date)=2 then 'Tuesday'
              when extract(dow from date)=3 then 'Wednesday'
              when extract(dow from date)=4 then 'Thursday'
              when extract(dow from date)=5 then 'Friday'
              when extract(dow from date)=6 then 'Saturday'
         end as day
    from cycling_entry
group by extract(dow from date);
-- average time: 21.7ms