SQL Tidbit - setting up a Common Table Expression

A quick tutorial on setting up a common table expression, generating random values, and using the AVG and STDEV aggregate functions with the OVER() clause.