Leetcode 1098. Unpopular Books

Given a list of books and their transaction/borrow records, return the books that are "unpopular" (never borrowed or borrowed fewer than a specified threshold). This requires joining book metadata with transaction data and using aggregation/anti-join patterns (COUNT/GROUP BY or LEFT JOIN + WHERE NULL) to count and filter while handling missing or duplicate records.