SQL - Analytics

These code library will helps in creating the variables, calculated field, for table observation which can be used in in Analytics, Software development. Table observation - calculate min, max, row count , unique count, data type, min length, max length, sum of column, average of column, null count, blank count for each column. calculate the frequency of transaction - will calculate the frequency of transaction of all customer.