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

Timestamp:

01/12/25 16:46:25 (3 days ago)

Author:

222039

Comment:

--

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

@@ -116 +116 @@
 }}}
 
+=== Извештај за членовите === 
+{{{#!sql
+SELECT 
+    u.FirstName,
+    u.LastName,
+    COUNT(l.LoanID) as total_loans,
+    COUNT(f.FineID) as total_fines,
+    SUM(f.FineAmount) as total_fine_amount
+FROM Users u
+JOIN Member m ON u.UserID = m.UserID
+LEFT JOIN Loan l ON m.MemberID = l.MemberID
+LEFT JOIN Fine f ON l.LoanID = f.LoanID
+GROUP BY u.UserID, u.FirstName, u.LastName
+ORDER BY total_loans DESC;
+}}}