Logic and comparison expressions

The table books of the library database is defined by the following statement:

CREATE TABLE books (
    id INT,
    title VARCHAR(100),
    author VARCHAR(20),
    rating INTEGER,
    quantity INTEGER
);

Write a query that selects id, title, author, and rating for books to prepare for the American novelists exhibition (Theodore Dreiser, Ayn Rand, Harper Lee, Mark Twain). Only select books which are currently present in the library. What you need is those books written by selected author with positive quantity in library.

Tip: Present in the library means that the quantity > 0.