graphs/sql/where_is_waldo/req02.sql


1
2
3
4
5
6

SELECT *
FROM nexus_stores.cashier_shifts AS s
FULL JOIN nexus_stores.cashier_shifts as c
ON s.id = c.id
WHERE s.employee_id IS NOT NULL
AND s.store_id IS NOT NULL