How to perform an aggregate query using SubSonic 2.1’s SqlQuery

One of the new features is the addition of the SqlQuery class and it’s ability to perform aggregate queries (along with many other features). Shows example of SQL syntax versus SubSonic's SqlQuery aggregate coding to perform SQL queries.