CREATE TABLE Reader (id INTEGER PRIMARY KEY, name TEXT); CREATE TABLE Loan (id INTEGER PRIMARY KEY, reader_id INTEGER, status TEXT); INSERT INTO Reader VALUES (1, 'Ana'), (2, 'Boris'); INSERT INTO Loan VALUES (11, 1, 'open'), (12, 1, 'open'), (13, 1, 'closed'), (14, 2, 'open'); SELECT r.id, r.name, COUNT(*) AS active_count FROM Reader AS r JOIN Loan AS l ON l.reader_id = r.id WHERE l.status = 'open' GROUP BY r.id, r.name HAVING COUNT(*) >= 2 ORDER BY r.id; SELECT r.name FROM Reader AS r WHERE EXISTS ( SELECT 1 FROM Loan AS l WHERE l.reader_id = r.id AND l.status = 'open' ) ORDER BY r.id;