How to get all the PERSON.NAME that has total workload <= 100? Thx
Why can't let column function in where-clause? Thx

DDL:
CREATE TABLE PERSON
(NAME CHAR(8), DEPT_ID CHAR(18), WORKLOAD INT)

COMMIT;

INSERT INTO PERSON VALUES('NIDM','ENGINEERING', 50);
INSERT INTO PERSON VALUES('NIDM','IT', 50);


This is OK:
SELECT NAME, SUM(WORKLOAD) FROM PERSON
GROUP BY NAME;

But this, got -120:
SELECT NAME FROM PERSON
WHERE SUM(WORKLOAD) <= 100
GROUP BY NAME;

Use having:

SELECT NAME FROM PERSON
GROUP BY NAME
HAVING SUM(WORKLOAD) <= 100

Thanks a lot