Total Catalog
15
71 total physical copies (60 on shelf)
Books Issued
11
60 copies currently available
Overdue Books
3
Past 14-day borrowing limit
Total Fines (₹2/Day)
₹54.00
₹46.00 accrued · ₹8.00 collected
Actionable Overdue Defaulters Roll
Members holding books past the 14-day borrowing limit. Fine rate: ₹2.00 / day.
3 Defaulters
| Record | Defaulter Member | Contact | Overdue Volume | Due Date | Delay | Immediate Settlement |
|---|
Catalog Inventory by Category
Aggregated SQL
GROUP BY Category breakdown.| Category | Distinct Titles | Total Copies | Available | Issued |
|---|
Most Circulated Library Volumes
Ranked by historical
COUNT(RecordID) frequency.| Book Title | Category | Total Issues | Shelf Status |
|---|