基于教材征订与发放管理系统的操作手册解析

CREATE TABLE Textbook (

ISBN VARCHAR(20) PRIMARY KEY,

Title NVARCHAR(100),

Author NVARCHAR(50),

Publisher NVARCHAR(50)

);

CREATE TABLE OrderDetail (

OrderID INT IDENTITY(1,1) PRIMARY KEY,

StudentID INT,

ISBN VARCHAR(20),

Quantity INT,

FOREIGN KEY (ISBN) REFERENCES Textbook(ISBN),

FOREIGN KEY (StudentID) REFERENCES Student(StudentID)

);

SELECT T.Title, O.Quantity

FROM Textbook T

JOIN OrderDetail O ON T.ISBN = O.ISBN

WHERE O.OrderDate BETWEEN '2023-09-01' AND '2023-12-31';