Function se3 = new Function(); se3.setName("EXTRACT_YEAR"); se3.setParameters(el);
Column le = new Column(); le.setTable(tableLineitem); le.setColumnName("EXTENDEDPRICE");
Column ld = new Column(); ld.setTable(tableLineitem); ld.setColumnName("DISCOUNT");
Subtraction diff = new Subtraction(); diff.setLeftExpression(new DoubleValue("1.0")); diff.setRightExpression(ld);
Parenthesis diffPnths = new Parenthesis();diffPnths.setExpression(diff);
Multiplication se4 = new Multiplication(); se4.setLeftExpression(le); se4.setRightExpression(diffPnths);
List<Expression> expListExpr = Arrays.asList(se1, se2, se3, se4);
EqualsTo eq1 = new EqualsTo(); eq1.setLeftExpression(se1); eq1.setRightExpression(new StringValue(" FRANCE "));
EqualsTo eq2 = new EqualsTo(); eq2.setLeftExpression(se2); eq2.setRightExpression(new StringValue(" GERMANY "));