SELECT "-- Query 1";
SELECT COUNT(ISBN) AS 'Total Books Owned' FROM OwnersBook;

SELECT "-- Query 2";
SELECT Title AS 'Book Title', CatDescription AS 'Category' FROM Book LEFT OUTER JOIN Category ON Book.Category = Category.CatID
	ORDER BY CatDescription ASC, Title ASC;

SELECT "-- Query 3";
SELECT Name AS 'Reviewer Name', COUNT(ISBN) AS 'Number of Reviews', ROUND(Rating, 1) AS 'Average Rating' FROM Reviewer RIGHT OUTER JOIN BookReview
	ON Reviewer.ReviewerID = BookReview.ReviewerID GROUP BY Name ORDER BY COUNT(ISBN) DESC;

SELECT "-- Query 4";
SELECT DISTINCT Name AS 'Reviewers with No Reviews' FROM Reviewer LEFT OUTER JOIN BookReview ON Reviewer.ReviewerID = BookReview.ReviewerID
	WHERE Reviewer.ReviewerID NOT IN(SELECT ReviewerID FROM BookReview) ORDER BY Name ASC;