SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE users (`user_id` INTEGER, `group_id` INTEGER, `house_name` VARCHAR(5));
✓
CREATE TABLE points (`user_id` INTEGER, `group_id` INTEGER, `points` INTEGER, `term_id` VARCHAR(8));
✓
INSERT INTO users (`user_id`, `group_id`, `house_name`) VALUES
  ('923828395', '1', 'Alpha'),
  ('722161580', '2', 'Beta'),
  ('923828395', '1', 'Gamma');
✓
INSERT INTO points (`user_id`, `group_id`, `points`, `term_id`) VALUES
  ('722161580', '1', '18', '02078e51'),
  ('923828395', '1', '11', '02078e51'),
  ('923828395', '2', '140', '81450fc1');
✓
SELECT u.user_id, u.house_name, p.points, p.group_id, p.term_id
FROM users u JOIN points p
ON p.user_id = u.user_id AND p.group_id = u.group_id
WHERE p.term_id = '02078e51' AND p.group_id = '1'


user_id
house_name
points
group_id
term_id


923828395
Alpha
11
1
02078e51

923828395
Gamma
11
1
02078e51