each invoice contains multiple line items. you want to find out the total number of purchases for each invoice, and store the result in a new column as total purchases. you write the sql query below. add a group by clause that will group the data by invoice id number.