diff options
Diffstat (limited to 'graphs/sql/following_you/req04.sql')
| -rw-r--r-- | graphs/sql/following_you/req04.sql | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/graphs/sql/following_you/req04.sql b/graphs/sql/following_you/req04.sql new file mode 100644 index 0000000..9cb46ed --- /dev/null +++ b/graphs/sql/following_you/req04.sql @@ -0,0 +1,25 @@ +SELECT + place_type, + entries, + place_id +FROM + ( + ( + SELECT + 'metro' AS place_type, + station_id AS place_id, + COUNT(DISTINCT person_id) AS entries + FROM transport.metro_usage_logs + GROUP BY station_id + ) + UNION + ( + SELECT + 'shop' AS place_type, + shop_id AS place_id, + COUNT(DISTINCT person_id) AS entries + FROM public.shop_entrance_logs + GROUP BY shop_id + ) + ) AS res +ORDER BY entries DESC, place_id ASC, place_type DESC |