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

Timestamp:

01/11/25 16:12:50 (4 days ago)

Author:

222039

Comment:

--

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

@@ -3 +3 @@
 === Извештај за членови со најмногу позајмувања ===
 {{{#!sql
-SELECT users.FirstName, users.LastName, COUNT(loan.LoanID) AS loan_count
+SELECT 
+    users.FirstName,
+    users.LastName,
+    EXTRACT(MONTH FROM loan.LoanDate) AS month,
+    COUNT(loan.LoanID) AS loan_count
 FROM users
 INNER JOIN loan ON users.UserID = loan.MemberID
-GROUP BY users.UserID, users.FirstName, users.LastName
+WHERE EXTRACT(MONTH FROM loan.LoanDate) = 4  -- Change this number for different months (1-12)
+GROUP BY 
+    users.UserID, 
+    users.FirstName, 
+    users.LastName,
+    EXTRACT(MONTH FROM loan.LoanDate)
 ORDER BY loan_count DESC
 LIMIT 5;