Querying and Aggregating Data: Finding the Total Price of an Invoice

How to Use IN Clause vs Correlated Subqueries in SQL Aggregate Functions