Chapter 23, Problem 14RE

Explanation of Solution

Consider the following:

The below SQL statement that computes and finds the total number of all quantities that are part of invoice number 11731:

/* Display the total from the table */

SELECT SUM (LineItem.Quantity)

FROM LineItem

WHERE LineItem.Invoice_Number = 11731

Explanation:

• The above “SELECT” statement that calculate and returns the “SUM(LineItem.Quantity)” column from “LineItem” table where “LineItem.Invoice_Number” is equal to “11731”.
  • “SUM(LineItem.Quantity)” – It finds the sum of all quantities and returns the quantity value related to the given invoice number “11731”...