graphs/sql/following_you/req01.sql


1
2
3
4
5
6
7
8
9

SELECT p.id,first_name,last_name
FROM public.people AS p
WHERE EXISTS (
    SELECT *
    FROM transport.metro_usage_logs, transport.metro_stations AS s
    WHERE p.id = person_id
    AND s.id = station_id
    AND s.name = 'Morgane Abeille'
)