Good time of day. There are three tables:
books (id, title)
users (id, first_name, last_name, age)
users_books (id, user_id, book_id)
The table users_books contains information about the users purchased books. You should select the list of users who did not buy a book with a certain name.
Users_books INNER JOIN ON users.id = users_books.user_id
users_books.user_id NOT IN (
users_books.book_id = (SELECT id FROM books where title = "Book")
Is it possible to execute a query optimally?