From c9b6b9a5ca082fe7c1b6f58d7713f785a9eb6a5c Mon Sep 17 00:00:00 2001 From: Martial Simon Date: Mon, 15 Sep 2025 01:08:27 +0200 Subject: add: graphs et rushs --- graphs/sql/following_you/req05.sql | 51 ++++++++++++++++++++++++++++++++++++++ 1 file changed, 51 insertions(+) create mode 100644 graphs/sql/following_you/req05.sql (limited to 'graphs/sql/following_you/req05.sql') diff --git a/graphs/sql/following_you/req05.sql b/graphs/sql/following_you/req05.sql new file mode 100644 index 0000000..691442b --- /dev/null +++ b/graphs/sql/following_you/req05.sql @@ -0,0 +1,51 @@ +SELECT * +FROM + ( + ( + ( + SELECT + person_id, + p.first_name AS person_first_name, + p.last_name AS person_last_name, + created_at, + 'metro' AS place, + station_id AS place_id + FROM transport.metro_usage_logs + INNER JOIN public.people AS p + ON p.id = person_id + WHERE + created_at BETWEEN timestamp '2059-12-03 17:00:00' AND timestamp '2059-12-03 21:59:59' + ) + UNION + ( + SELECT + person_id, + p.first_name AS person_first_name, + p.last_name AS person_last_name, + created_at, + 'shop' AS place, + shop_id AS place_id + FROM public.shop_entrance_logs + INNER JOIN public.people AS p + ON p.id = person_id + WHERE + created_at BETWEEN timestamp '2059-12-03 17:00:00' AND timestamp '2059-12-03 21:59:59' + ) + ) + UNION + ( + SELECT + person_id, + p.first_name AS person_first_name, + p.last_name AS person_last_name, + created_at, + 'street' AS place, + street_id AS place_id + FROM public.street_logs + INNER JOIN public.people AS p + ON p.id = person_id + WHERE + created_at BETWEEN timestamp '2059-12-03 17:00:00' AND timestamp '2059-12-03 21:59:59' + ) + ) AS res +ORDER BY created_at ASC, person_id ASC -- cgit v1.2.3