SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE users ( id int, name varchar(255), birth_year int ); INSERT INTO users VALUES (1, 'Ivan Ivanov', 2003), (2, 'Maria Ivanova', 2007); CREATE TABLE books ( id int, name varchar(255), author varchar(255) ); INSERT INTO books VALUES (1, 'War and Peace', 'Leo Tolstoy'), (2, 'Anna Karenina', 'Leo Tolstoy'), (3, 'Another Book', 'Another Author') ; CREATE TABLE user_books ( id int, user_id int, book_id int ); INSERT INTO user_books VALUES (1, 1, 3), (2, 2, 1), (3, 2, 2); SELECT users.name, COUNT(books.id) books_count, COUNT(DISTINCT books.author) authors_count FROM users JOIN user_books ON users.id = user_books.user_id JOIN books ON books.id = user_books.book_id WHERE users.birth_year BETWEEN 2004 AND 2014 GROUP BY users.name HAVING books_count = 2 AND authors_count = 1 ;