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());
}
