11. What is the difference between Count and Sum? Give an example of how each would be used.
Count counts the number of rows that would be retrieved. Sum adds the values of the items within the column. A simple distinction, but one that creates problems for many people. A simple rule is to count ID values but never sum them.