Search
⌘K
Leetcode 3570. Find Books with No Available Copies
Identify books for which the number of currently borrowed copies (COUNT of borrowing_records with NULL return_date) equals total_copies, meaning zero copies are available. Return those books ordered by current borrower count descending and then by title ascending (requires grouping/aggregation and HAVING to filter).
Question Timeline
See when this question was last asked and where, including any notes left by other candidates.
All Regions
Comments
Hello Interview Premium
Your account is free and you can post anonymously if you choose.