you are working with a database table that contains invoice data. the table includes the columns invoice id item (items for each invoice), invoice id, unit price, and quantity (the number of purchases in each item). each invoice contains multiple items. you want to know the total price of each of the 5 items in the table. you decide to multiply the unit price by the quantity to get the total price for each item, and you save the as command to store the total in a new column called item total. add a statement to your sql query that calculates the total price for each item and stores it in a new column called item total. note: the three dots (...) indicate where to add the statement.
