    @Test
    public void testSelectWithHaving() {

        String sql = "select a, b from TRANSACTION t where a = 'hello world' group by c having b > 100";
        LogicalPlan plan = getLogicalPlan(sql);

        LogicalPlan logicalPlan = buildHaving();

        assertTrue(logicalPlan.getQuery().equals(plan.getQuery()));
    }