graphs/sql/following_you/req06.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

SELECT person_id,validation,created_at
FROM(
    (
    SELECT person_id,validation,created_at
    FROM transport.metro_usage_logs
    WHERE created_at BETWEEN timestamp '2059-12-03 12:00:00' AND timestamp '2059-12-03 13:59:59'
)
UNION
(
    SELECT person_id,validation,created_at
    FROM transport.metro_usage_logs
    WHERE created_at BETWEEN timestamp '2059-12-03 20:00:00' AND timestamp '2059-12-03 21:59:59'
    LIMIT 10
)) AS res
ORDER BY created_at DESC, person_id ASC