Adds two numbers. This addition arithmetic operator also can add a number, in days, to a date.
In the following example, you want to create a target total, which is the current number of customers plus 50. The following example adds 50 to the total number of current customers. This result of the query in this example assumes that there are 90 current customers listed in the Customers table.
SELECT COUNT(CustomerID) + 50 AS "Target Total" FROM Customers
This is the result set:
Target Total ------------ 140