books(id, title author, isbn, goodreads_rating, num_ratings)

ratings(id, user_id, book_name, rating)

users(id, username, year_joined)

books[title] ratings[book_name] users[id] ratings[user_id]

The id attribute in all three tables is different! You can think of them in your mind as the book_id, user_id, and rating_id. The title attribute in the Books table is the same as the book_name attribute in the Ratings table. The id attribute in the Users table is the same as the user_id attribute in the Ratings table.

Write an Algebra relationship query to list all book titles that have a 4 or higher GoodReads rating that have been rated by user LibreLibrary sorted by LibreLibrarys rating.