public void Having() { var clause = _builder .Select <Product>(product => product.Name) .SelectAs <Product>(product => SqlFunctions.Avg(product.Price), "avg_price") .From <Product>() .GroupBy <Product>(product => product.Name) .Having <Product>(product => SqlFunctions.Avg(product.Price) > 74) .Build(); var reader = _connection.Read(clause); Assert.IsTrue(reader.Read()); Assert.AreEqual("almira", reader["name"]); Assert.AreEqual(75, reader["avg_price"]); Assert.IsFalse(reader.Read()); }