Specifies whether the DBMS Server returns zero values for aggregate functions that use the by clause. In the following example, if you specify the project option, the DBMS Server returns a value for each department, zero for those departments that have no employees earning over $10,000. If you specify noproject, departments that have no employees earning over $10,000 are omitted: