Changes between Version 26 and Version 27 of Напредни извештаи од базата (SQL и складирани процедури)

Timestamp:

02/24/25 16:16:11 (3 months ago)

Author:

222039

Comment:

--

Напредни извештаи од базата (SQL и складирани процедури)

@@ -79 +79 @@
 
 * '''π_{CoverImage, Title, Genre, FirstName, LastName, quarter, loan_count}
-(σ_{EXTRACT(QUARTER FROM LoanDate) = 4}
-((Book ⨝{Book.BookID = Book_Copies.BookID} Book_Copies)
-⟕{Book_Copies.CopyID = Loan.BookCopyID} Loan
-⨝{Book.BookID = Book_Author.BookID} Book_Author
-⨝{Book_Author.AuthorID = Author.AuthorID} Author)
-γ_{Book.BookID, Book.Title, Book.CoverImage, Book.Genre, Author.FirstName, Author.LastName, EXTRACT(QUARTER FROM Loan.LoanDate)} COUNT(Loan.LoanID) → loan_count
-τ_{loan_count ASC} ρ_{LIMIT 5})''''
+* (σ_{EXTRACT(QUARTER FROM LoanDate) = 4}
+* ((Book ⨝{Book.BookID = Book_Copies.BookID} Book_Copies)
+* ⟕{Book_Copies.CopyID = Loan.BookCopyID} Loan
+* ⨝{Book.BookID = Book_Author.BookID} Book_Author
+* ⨝{Book_Author.AuthorID = Author.AuthorID} Author)
+* γ_{Book.BookID, Book.Title, Book.CoverImage, Book.Genre, Author.FirstName, Author.LastName, EXTRACT(QUARTER FROM Loan.LoanDate)} COUNT(Loan.LoanID) → loan_count
+* τ_{loan_count ASC} ρ_{LIMIT 5})''''
 
 {{{#!sql                      
@@ -186 +186 @@
     AVG(l.ReturnDate - l.LoanDate) DESC;
 }}}
+
+* π_{Title, AvgDaysToReturn, MinDaysToReturn, MaxDaysToReturn, TotalLoans, LoansWithFines}
+* (σ_{TotalLoans ≥ 5}
+* (γ_{Book.BookID, Book.Title}
+* (Loan ⨝{Loan.BookCopyID = Book_Copies.CopyID} Book_Copies
+* ⨝{Book_Copies.BookID = Book.BookID} Book
+* ⟕{Loan.LoanID = Fine.LoanID} Fine)
+* AVG(Loan.ReturnDate - Loan.LoanDate) → AvgDaysToReturn,
+* MIN(Loan.ReturnDate - Loan.LoanDate) → MinDaysToReturn,
+* MAX(Loan.ReturnDate - Loan.LoanDate) → MaxDaysToReturn,
+* COUNT(*) → TotalLoans,
+* COUNT(σ{Fine.FineID IS NOT NULL} (*)) → LoansWithFines)
+* τ_{AvgDaysToReturn DESC})
 
 === Извештај за активност на членови ===
@@ -227 +240 @@
 }}}
 
-* π_{Title, AvgDaysToReturn, MinDaysToReturn, MaxDaysToReturn, TotalLoans, LoansWithFines}
-(σ_{TotalLoans ≥ 5}
-(γ_{Book.BookID, Book.Title}
-(Loan ⨝{Loan.BookCopyID = Book_Copies.CopyID} Book_Copies
-⨝{Book_Copies.BookID = Book.BookID} Book
-⟕{Loan.LoanID = Fine.LoanID} Fine)
-AVG(Loan.ReturnDate - Loan.LoanDate) → AvgDaysToReturn,
-MIN(Loan.ReturnDate - Loan.LoanDate) → MinDaysToReturn,
-MAX(Loan.ReturnDate - Loan.LoanDate) → MaxDaysToReturn,
-COUNT(*) → TotalLoans,
-COUNT(σ{Fine.FineID IS NOT NULL} (*)) → LoansWithFines
-)
-τ_{AvgDaysToReturn DESC})
 
 === Извештај за најпозајмени жанри на временски периоди ===