PersonType FirstName Total ---------- -------------------------------------------------- ----------- EM John 6 EM Ken 2 GC John 5 GC Ken 2 IN John 24 IN Ken 1 SC John 20 VC John 3 VC Ken 1 (9 row(s) affected)