Select * from(
select '0-30' as Wiek, (SELECT COUNT(*) FROM dbo.Pracownicy WHERE Plec='kobieta' AND Wiek > 0 And Wiek < 30) as Kobiety, (SELECT COUNT(*) FROM dbo.Pracownicy WHERE Plec='mezczyzna' AND Wiek > 0 And Wiek < 30) as Mezczyzni union all
select '30-40', (SELECT COUNT(*) as Kobiety FROM dbo.Pracownicy WHERE Plec='kobieta' AND Wiek > 30 And Wiek < 40), (SELECT COUNT(*) as Mezczyzni FROM dbo.Pracownicy WHERE Plec='mezczyzna' AND Wiek > 30 And Wiek < 40) union all
select '40-50', (SELECT COUNT(*) as Kobiety FROM dbo.Pracownicy WHERE Plec='kobieta' AND Wiek > 40 And Wiek < 60), (SELECT COUNT(*) as Mezczyzni FROM dbo.Pracownicy WHERE Plec='mezczyzna' AND Wiek > 40 And Wiek < 60) union all
select '60+', (SELECT COUNT(*) as Kobiety FROM dbo.Pracownicy WHERE Plec='kobieta' AND Wiek > 60), (SELECT COUNT(*) as Mezczyzni FROM dbo.Pracownicy WHERE Plec='mezczyzna' AND Wiek > 60)) x