Simple Statistics
Summary Statistics
Advanced Statistics
What is Null Count ?
Example
ID FRISTNAME LASTNAME
1 lei li
2 lei li
3 lei li
4 null stone
5 lei li
6 lei li
7 null stone
8 null zhang
What is Distinct Count ?
Example
ID NAME AGE FAVOURITE FOOD
1 Lily 20 APPLE
2 Lucy 20 APPLE
3 John 20 APPLE
4 David 20 APPLE
5 Sam 35 banana
6 Kaka 35 banana
7 stone 35 banana
8 Adison 35 banana
What is Total Count ?
Example
Suppose we have the below data table, then the total count of ID is: 8
ID NAME AGE
1 lei 17
2 lei 18
3 lei 18
4 lei 21
5 lei 23
6 lei 23
7 lei 24
8 lei 26
What is Maximum ?
Example
Suppose we have the below data table, then the maximum is: 26 26
ID NAME AGE
1 lei 17
2 lei 18
3 lei 18
4 lei 21
5 lei 23
6 lei 23
7 lei 24
8 lei 26
What is Minimum ?
Example
Suppose we have the below data table, then the minimum is: 14
ID NAME AGE
1 lei 17
2 lei 18
3 lei 18
4 lei 14
5 lei 23
6 lei 23
7 lei 24
8 lei 26
What is Average ?
Example
Suppose we have the below data table, then the Average of AGE is: 20
ID NAME AGE
1 lei 18
2 lei 18
3 lei 19
4 lei 19
5 lei 21
6 lei 21
7 lei 22
8 lei 22
What is Median ?
Example
Suppose we have the below data table, then the median of AGE is: 21
ID NAME AGE
1 lei 17
2 lei 18
3 lei 19
4 lei 20
5 lei 21
6 lei 21
7 lei 22
8 lei 22
9 lei 23
What is the Rule Detection Count?
Example
IDENTIFIER NAME AGE
#1111 lei 17
#1245 lei 18
15245 lei 18
87956 lei 21
monkey lei 23
tiger lei 23
456 lei 24
324 lei 26

Suppose Regular Expression is : ^[A-Za-z]+$

The regular expression matching means : Matches a string consisting of 26 english letters

The result is: 2 (MONKEY AND TIGER)

What is the Enum Detection Count?
Example
CUSTOMERID NAME COUNTRY
1 lei Germany
2 lei Mexico
3 lei Germany
4 lei Mexico
5 lei China
6 lei China
7 lei UK
8 lei Sweden

Suppose Enum Expression is : SELECT COUNT(CUSTORMERID), COUNTRY FROM Customers GROUP BY COUNTRY;

The result is:
COUNTRY |COUNT(CUSTOMERID)
Germany|2
Mexico |2
China |2
UK |1
Sweden |1

What is the Regular Expression Match?
Example
IDENTIFIER NAME AGE
#1111 lei 17
#1245 lei 18
15245 lei 18
87956 lei 21
monkey lei 23
tiger lei 23
456 lei 24
324 lei 26

Suppose Regular Expression is : ^[A-Za-z]+$

The regular expression matching means : Matches a string consisting of 26 english letters

The result is: 2 (MONKEY AND TIGER)