Skip to main content

2

sql

-- View the users table
SELECT * FROM users;

-- View the user_courses table
SELECT * FROM user_courses;

-- Return users who selected more than one course
SELECT name
FROM users
WHERE user_id IN (
  SELECT user_id
  FROM user_courses
  GROUP BY user_id
  HAVING COUNT(*) > 1
);

Want to learn more?

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

sql