use XYZ;

DROP TABLE IF EXISTS BOOK;

CREATE TABLE [BOOK]
(

[BookId] [int] IDENTITY(1, 1) NOT NULL PRIMARY KEY,
[Title] [varchar](50) NOT NULL UNIQUE,
[Author] [varchar](50) NOT NULL,
[Category] [varchar](50) NOT NULL

)
GO

INSERT INTO BOOK (Title, Author, Category)
VALUES (1, 'Yougui', 80)

Go

INSERT INTO BOOK (Title, Author, Category)
VALUES (2,'Liao', 87)
GO

INSERT INTO BOOK (Title, Author, Category)
VALUES (3,'Marsk', 99)

GO

