X++:
Query q=new Query();
//while select sum(SalesQty) from SPLJLH
QueryBuildDataSource ds = q.addDataSource(tableNum(SPLJLH));
;
//group by ModifDate
ds.OrderMode(OrderMode::GroupBy);
ds.addSortField(fieldNum(SPLJLH, ModifDate));
ds.addSelectionField(fieldNum(SPLJLH, SalesQty), SelectionField::Sum);
//where SPLJLH.EmplId == it.value()
ds.addRange(fieldNum(SPLJLH, EmplID)).value(queryValue(it.value()));