Completed
Incomplete
Not Attended
Share
Nebula E-Library is a modern digital platform that keeps detailed records of every
book borrowed, including borrowing_id, member_name, book_title, borrow_date, and
return_date. As the Data Analyst for the library, your job is to support the head librarian by
writing SQL queries to identify overdue books for timely follow-ups, determine the most active
members to reward engagement, and summarize borrowing statistics to create insightful
management reports, ultimately helping the library optimize its operations and enhance
member satisfaction.
Question - 1Calculate the total number of books borrowed by each member.
Question - 2Find the one member who borrowed the most books.
Code Editor
Table Name: borrow_records
| borrow_id | member_name | book_title | borrow_date | return_date |
|---|---|---|---|---|
| 1 | Ananya | Database Systems | 2025-08-01 | 2025-08-10 |
| 2 | Rohit | Algorithms | 2025-08-03 | 2025-08-15 |
| 3 | Simran | Operating Systems | 2025-08-05 | 2025-08-20 |
| 4 | Aditya | Computer Networks | 2025-08-07 | 2025-08-18 |
| 5 | Priya | Web Development | 2025-08-09 | 2025-08-19 |
>>> Submit Your Query to validate