Learn how to use the SUM function in SQL queries to calculate the total value of a numeric column or expression, with examples and tips.