How can I perform statistics analysis with my data in the sql code?

Answer 1

Use aggregative function

Answer 2

depends on what you need done, mostly you would use sum, avg , and,or between etc..