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


Ignore:
Timestamp:
02/24/25 16:11:21 (3 months ago)
Author:
222039
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

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

    v20 v21  
    1919LIMIT 5;
    2020}}}
     21
     22* '''π_{FirstName, LastName, month, loan_count} (σ_{EXTRACT(MONTH FROM LoanDate) = 4} (Users ⨝{Users.UserID = Loan.MemberID} Loan) γ{Users.UserID, Users.FirstName, Users.LastName, EXTRACT(MONTH FROM Loan.LoanDate)} COUNT(Loan.LoanID) → loan_count τ_{loan_count DESC} ρ_{LIMIT 5})'''
    2123
    2224=== Извештај за најпозајмени книги по тримесечие ===
    … …  
    4749LIMIT 5;
    4850}}}
    49 
     51* '''π_{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 DESC} ρ_{LIMIT 5})'''
    5052=== Извештај за најмалку позајмувани книги по тримесечие ===
    5153{{{#!sql