-- Query 1
SELECT Book.Title, Category.CatDescription
FROM Book JOIN Category
    ON Book.Category = Category.CatID
ORDER BY CatDescription DESC, title ASC;

-- Query 2
SELECT Reviewer.Name, Book.Title, BookReview.Rating
FROM ((Book JOIN BookReview
    ON Book.ISBN = BookReview.ISBN)
    JOIN Reviewer
    ON Reviewer.ReviewerID = BookReview.ReviewerID)
    WHERE Reviewer.EmployedBy IS NULL;

-- Query 3
SELECT Book.Title, Author.LastName, Author.FirstName
FROM ((Book JOIN BookAuthor
    ON Book.ISBN = BookAuthor.ISBN)
    JOIN Author
    ON Author.AuthorID = BookAuthor.AuthorID)
ORDER BY Book.Title ASC, Author.LastName ASC;

-- Query 4
SELECT Book.Title, Author.LastName, Author.FirstName, OwnersBook.Price
FROM ((Book JOIN BookAuthor
    ON Book.ISBN = BookAuthor.ISBN)
    JOIN Author
    ON Author.AuthorID = BookAuthor.AuthorID) JOIN OwnersBook on OwnersBook.ISBN = Book.ISBN
HAVING OwnersBook.Price <= 50
ORDER BY OwnersBook.Price DESC, Book.Title ASC;

-- Query 5
SELECT Book.Title, Reviewer.Name
FROM ((Book JOIN BookReview
    ON Book.ISBN = BookReview.ISBN)
    JOIN Reviewer
    ON Reviewer.ReviewerID = BookReview.ReviewerID);

-- Query 6
SELECT Book.ISBN, Book.Title
FROM Book JOIN Category ON Book.Category = Category.CatID;