joebartels/medium.date_fields_vs_extract.query_cycling_entry_by_day_of_week_and_hour_of_day.sql

## medium.date_fields_vs_extract.query_cycling_entry_by_day_of_week_and_hour_of_day.sql
select sum(km_cycled) as km_cycled_for_all_mondays
 from cycling_entry
where day_of_week = 1
  and hour_of_day > 11;
--       result: 39982
-- average time: 7.25ms

select sum(km_cycled) as km_cycled_for_all_mondays
  from cycling_entry
 where extract(dow from date) = 1
   and extract(hour from date) > 11;
--       result: 39982
-- average time: 19.2ms
	select sum(km_cycled) as km_cycled_for_all_mondays
	from cycling_entry
	where day_of_week = 1
	and hour_of_day > 11;
	-- result: 39982
	-- average time: 7.25ms

	select sum(km_cycled) as km_cycled_for_all_mondays
	from cycling_entry
	where extract(dow from date) = 1
	and extract(hour from date) > 11;
	-- result: 39982
	-- average time: 19.2ms