CREATE TABLE #TempTable
(
    DATE DATE,
    LoanedBooks INT,
    ReturnedBooks INT,
    LateBooks INT
);

-- 93 sest enamus genereeritud laenutustel oli algus rohkem kui kolm kuud tagasi tänasest
DECLARE @DaysLookBack INT = 93
DECLARE @LoanedBooks INT = 0
DECLARE @ReturnedBooks INT = 0
DECLARE @LateBooks INT = 0
DECLARE @DAY DATE

WHILE @DaysLookBack >= 0 BEGIN
    SET @DAY = CAST(DATEADD(DAY, -@DaysLookBack, GETDATE()) AS DATE)
    SELECT @LoanedBooks = COUNT(*) FROM Checkout WHERE StatusID = 1 AND StartDate <= @DAY
    SELECT @ReturnedBooks = COUNT(*) FROM Checkout WHERE StatusID = 2 AND ActualReturnDate = @DAY
    SELECT @LateBooks = COUNT(*) FROM Checkout WHERE StatusID = 1 AND @DAY > PlannedReturnDate
    INSERT INTO #TempTable (DATE, LoanedBooks, ReturnedBooks, LateBooks) VALUES (@DAY, @LoanedBooks, @ReturnedBooks, @LateBooks)
    SET @DaysLookBack = @DaysLookBack - 1
END

SELECT DATE, LoanedBooks, ReturnedBooks, LateBooks FROM #TempTable;
DROP TABLE #TempTable;