SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Users (
        UID INT PRIMARY KEY,
        Username VARCHAR(256),
        DoB DATE,
        Age INT,
    );
CREATE TABLE Book (
        ISBN VARCHAR(17) PRIMARY KEY,
        Title VARCHAR(256),
        Published DATE,
        Pages INT,
        Language VARCHAR(256)
    );
CREATE TABLE Rating (
        UID INT REFERENCES Users (UID),
        ISBN VARCHAR(17) REFERENCES Book (ISBN),
        PRIMARY KEY (UID,ISBN),
        Rating INT);
INSERT INTO Users (UID, Username, DoB, Age)
VALUES
  (1, 'Alice', '1990-01-01', 33),
  (2, 'Bob', '1995-05-15', 28),
  (3, 'Charlie', '1985-12-31', 37),
  (4, 'David', '2000-07-04', 22);
4 rows affected

INSERT INTO Book (ISBN, Title, Published, Pages, Language)
VALUES
  ('9783161484100', 'The Catcher in the Rye', '1951-07-16', 277, 'English'),
  ('9780061120084', 'To Kill a Mockingbird', '1960-07-11', 336, 'English'),
  ('9780141187761', '1984', '1949-06-08', 328, 'English'),
  ('9780547928227', 'The Lord of the Rings', '1954-07-29', 1178, 'English');
4 rows affected

INSERT INTO Rating (UID, ISBN, Rating)
VALUES
  (1, '9783161484100', 4),
  (2, '9783161484100', 5),
  (3, '9783161484100', 3),
  (1, '9780061120084', 5),
  (2, '9780061120084', 4),
  (3, '9780061120084', 5),
  (4, '9780061120084', 3),
  (1, '9780141187761', 5),
  (2, '9780141187761', 4),
  (3, '9780141187761', 5),
  (4, '9780141187761', 4),
  (1, '9780547928227', 5),
  (2, '9780547928227', 5),
  (3, '9780547928227', 5),
  (4, '9780547928227', 5);
15 rows affected

SELECT
     Book.Title, Rating.UID, Users.Username, Rating.ISBN, Rating.Rating
FROM Book
JOIN Rating ON Book.ISBN = Rating.ISBN
JOIN Users On Rating.UID = Users.UID
WHERE Rating.Rating = 5
ORDER BY
     Book.Title
;


Title
UID
Username
ISBN
Rating


1984
1
Alice
9780141187761
5

1984
3
Charlie
9780141187761
5

The Catcher in the Rye
2
Bob
9783161484100
5

The Lord of the Rings
1
Alice
9780547928227
5

The Lord of the Rings
2
Bob
9780547928227
5

The Lord of the Rings
3
Charlie
9780547928227
5

The Lord of the Rings
4
David
9780547928227
5

To Kill a Mockingbird
1
Alice
9780061120084
5

To Kill a Mockingbird
3
Charlie
9780061120084
5

Title	UID	Username	ISBN	Rating
1984	1	Alice	9780141187761	5
1984	3	Charlie	9780141187761	5
The Catcher in the Rye	2	Bob	9783161484100	5
The Lord of the Rings	1	Alice	9780547928227	5
The Lord of the Rings	2	Bob	9780547928227	5
The Lord of the Rings	3	Charlie	9780547928227	5
The Lord of the Rings	4	David	9780547928227	5
To Kill a Mockingbird	1	Alice	9780061120084	5
To Kill a Mockingbird	3	Charlie	9780061120084	5