ot of  |
|                                | the population variance.                  |
+--------------------------------+-------------------------------------------+
| STDDEV_SAMP()                  | Computes the cumulative sample standard   |
|                                | deviation and returns the square root of  |
|                                | the sample variance.                      |
+--------------------------------+-------------------------------------------+
| SUM()                          | Sum of expression across all input        |
|                                | values.                                   |
+--------------------------------+-------------------------------------------+
| VARIANCE() VAR_POP()           | Population variance of the input values   |
|                                | (square of the population standard        |
|                                | deviation).                               |
+--------------------------------+-------------------------------------------+
| VAR_SAMP()                     | Sample variance of the input values       |
|                                | (square of the sample standard            |
|                                | deviation).                               |
+--------------------------------+-------------------------------------------+

Examples
--------

Example Schema
--------------

The examples are all based on the following simplified sales opportunity table:

create table opportunities (
id int,
accountName varchar(20),
name varchar(128),
owner varchar(7),
amount decimal(10,2),
closeDate date,
stageName varchar(11)
) engine=columnstore;

Some example values are (thanks to https://www.mockaroo.com for sample data
generation):

+----+---------------+------+--------+---------+-------------+-------------+
| id | accountName   | name | owner  | amount  | closeDate   | stageName   |
+----+---------------+------+--------+---------+-------------+-------------+
| 1  | Browseblab    | Mult | Bob    | 26444.8 | 2016-10-20  | Negotiating |
|    |               | -lat |        |         |             |             |
|    |               | ral  |        |         |             |             |
|    |               | exec |        |         |             |             |
|    |               | tive |        |         |             |             |
|    |               | func |        |         |             |             |
|    |               | ion  |        |         |             |             |
+----+---------------+------+--------+---------+-------------+-------------+
| 2  | Mita          | Orga | Maria  | 477878. | 2016-11-28  | ClosedWon   |
|    |               | ic   |        | 1       |             |             |
|    |               | dema |        |         |             |             |
|    |               | d-dr |        |         |             |             |
|    |               | ven  |        |         |             |             |
|    |               | benc |        |         |             |             |
|    |               | mark |        |         |             |             |
+----+---------------+------+--------+---------+-------------+-------------+
| 3  | Miboo         | De-e | Olivie | 80181.7 | 2017-01-05  | ClosedWon   |
|    |               | gine |        |         |             |             |
|    |               | red  |        |         |             |             |
|    |               | hybr |        |         |             |             |
|    |               | d    |        |         |             |             |
|    |               | grou |        |         |             |             |
|    |               | ware |        |         |             |             |
+----+---------------+------+--------+---------+-------------+-------------+
| 4  | Youbridge     | Ente | Chris  | 946245. | 2016-07-02  | ClosedWon   |
|    |               | pris |        | 9       |             |             |
|    |               | -wid |        |         |             |             |
|    |               |    ë~J6