School Entrances

SELECT
	*
	--id, project_name, metric_name, "time", value, display_value, geometry_id
	FROM public.metrics_app_timeandgeometric as a
	join public.metrics_app_geometry as b on a.geometry_id=b.id
	where project_name = 'Lasswade'
	and metric_name = 'peopleCount'
	and time >= '2022-10-20'
	and geometry_name in ('School entrance_count',
						  'School entrance high_count',
						  'Entrance Door 1_count',
						  'Entrance Door 2_count',
						  'Entrance Door 3_count',
						  'Rear exit 1_count',
						  'Rear exit 2_count'
						 )
	order by time