[MS SQL] BASIC STATS

COUNT, AVG, SUM

SELECT Count(HuntingDistrict) as H_Sum 
from ForestDistricts

with group by clause, order by

SELECT COUNT(HuntingDistrict), Deer
FROM ForestDistricts 
GROUP BY Deer
ORDER BY COUNT(HuntingDistrict) DESC;

select Powiaty, count(Lisy) as LisyCounter
from Raport_RLO_DROBNA
group by Powiaty
order by count(Lisy) asc

SELECT AVG(Fawn) as ALotOfFawn
from LargeWild 

SELECT Sum(AmericanMink) as AM_Sum
from SmallWild

MIN, MAX

SELECT Max(Deer) as MaxDeer
from LargeWild 

SELECT Min(Deer) as MinDeer
from LargeWild 

SELECT Min(Deer) as MinDeer, Fawn
from LargeWild 
group by Fawn

SELECT Min(Deer) as MinDeer, Max(Fawn) as MaxFawn, 
Max(Moose) as MaxMoose, Min(Boar) as MinBoar
from LargeWild