CREATE TABLE authors (
    id INT NOT NULL AUTO_INCREMENT,
    name VARCHAR(127),
    PRIMARY KEY (id)
);

CREATE TABLE books (
    book_id INT NOT NULL AUTO_INCREMENT,
    name VARCHAR(256),
    author_id INT,
    FOREIGN KEY (author_id) REFERENCES authors (id),
    PRIMARY KEY (book_id)
);

CREATE TABLE mapping_table (
    author_id INT,
    book_id INT,
    FOREIGN KEY (author_id) REFERENCES authors (id),
    FOREIGN KEY (book_id) REFERENCES books (book_id)
);
-----------------------------------------------------------
SELECT books.name, count(books.book_id) AS AUTHORS_COUNT FROM books, mapping_table AS MT
WHERE books.book_id = MT.book_id GROUP BY books.book_id HAVING AUTHORS_COUNT = 3;