Skip to main content

8

sql

-- Users who appeared in both 2023 and 2024
SELECT user_id, name
FROM users_2023
INTERSECT
SELECT user_id, name
FROM users_2024;

-- Users who appeared in 2023 but not in 2024
SELECT user_id, name
FROM users_2023
EXCEPT
SELECT user_id, name
FROM users_2024;

Want to learn more?

Join CodeFriends Plus membership or enroll in a course to start your journey.

sql