Using SQL and UNION ALL to Aggregate Data from Multiple Columns

Optimizing Book Inventory: Calculating Remaining Copies with SQL Join and Filtering