Available question text
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).
Related questions
Continue with questions that share topics or the same question type.
Sources · 1 reference
These records explain where the question appears. A company tag or candidate report does not guarantee a future interview question.
Hello Interview · 1 record
No company association
Leetcode 3570. Find Books with No Available Copies
Reported date not specified · 0 source reports
Source snapshot: Nov 12, 2026
View source