Write SQL for library analytics

Q: Write SQL for library analytics

This question evaluates proficiency in SQL-based data manipulation and analytical querying, focusing on relational schema navigation, joins, aggregation, filtering, and handling temporal and conditional metrics within a library dataset.

Q: How do I approach Data Manipulation (SQL/Python) interview questions?

Data Manipulation (SQL/Python) questions require understanding of core concepts and practice. PracHub provides solutions with explanations to help you master data manipulation (sql/python) interviews.

Question

Given a library database, write SQL to answer the following:

Count the number of books that are currently not returned (i.e., still checked out) and are in good condition.
Among those currently not returned and in good condition, compute the percentage that have been renewed more than 2 times (use that subset as the denominator).
Return the top 3 book titles or IDs that have more than 10 copies and the longest total lending time across all their loans (sum of loan durations).
Find the member–referrer pair with the greatest difference in the number of reservations they have made, and return the pair and the difference.

Write SQL for library analytics

Overview

Comments (0)