select COUNT(*) as woj from dbo.woj w
select COUNT(*) as etaty from dbo.etaty e
select COUNT(*) as firmy from dbo.firmy f
select AVG(e.pensja) as [sr  pensja], MIN(e.pensja) as [minimum], MAX(e.pensja) as [maximum] from dbo.etaty e
select AVG(e.id_etatu) from dbo.etaty e
select AVG(e.pensja),e.stanowisko from dbo.etaty e group by e.stanowisko
select SUM(e.pensja), etaty.stanowisko from dbo.etaty e group by e.stanowisko
select SUM(e.pensja) from dbo.etaty e
--select * from dbo.etaty e
select MIN(f.id_miasta) from dbo.firmy f
select MIN(f.kod_pocztowy) from dbo.firmy f
select MIN(f.ulica) from dbo.firmy f
sElEcT mAx(f.id_miasta) from dbo.firmy f
SeLeCt MaX(f.kod_pocztowy) from dbo.firmy f
SElECt Max(f.ulica) from dbo.firmy f
select SUM(e.pensja) from dbo.etaty e where e.stanowisko like '%konsultant%' or e.stanowisko like '%adjunkt%'
select * from dbo.etaty e where e.pensja<10000 and e.do is not null
select * from dbo.etaty e where e.pensja between 10000 and 40000