Select GV.MaKhoa, count(GV.Hoc_Vi) as CN, count(GV.Hoc_Vi) as KS, COUNT(GV.Hoc_Vi) as ThS, COUNT(GV.Hoc_Vi) as TS, COUNT(GV.Hoc_Vi) as PTS
From GiaoVien GV
where exists (Select distinct GV1.MaKhoa
From GiaoVien GV1 where GV1.Hoc_Vi = GV.Hoc_Vi)
Group by GV.MaKhoa
Be the first to comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.