For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
I have following tables TABLE EMPLOYEE: TABLE DEPARTMENT: Here is the data of table DEPARTMENT: And here is the code and the result of the code that Im trying to do: I have done the 1st condition of the question that is count which department that have >=2 employees, but when I try to do the 2nd condition that is print out the list of department's employees right after each department, it show wrong data. Any suggestions? Tks.