Write SQL for library analytics

Q: Write SQL for library analytics

This is a Data Manipulation (SQL/Python) interview question from Meta for Data Engineer roles. View the full question and solution on PracHub.

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

Comments (0)