Q&A for pet owners, caretakers, breeders, veterinarians, and trainers
SELECT pt.Name, SUM(p.Score) as totScore, COUNT(*) as CatTotal FROM Users u JOIN Posts p ON p.OwnerUserId = u.Id JOIN PostTypes pt ON pt.Id = p.PostTypeId WHERE u.Id = ##UserID## GROUP BY pt.Name