PL/SQL need some help writing this out in PL/SQL

1) Write a query to return the department number and the total number of employees (in the associated department) whose makes more than $3,000.

2) Repeat step 1, and filter the results so that returns only department number with more than 2 employees who earns more than $3,000.

3) Repeat step 2 and sort the result by department number.

4) Write a query to transform department's name from multiple rows based on zip codes into a single list of values separated by a pipe delimiter (|)

ORACLE APEX App Builder SQL Workshop Team Development App Gallery a lov or SQL Commands Schema BEN10 Rows 10 Clear Command Find Tables Sa - 1 select * from emp; Explain Describe Saved SQL History EMPNO EMPLOYEE EMPADDRESS ZIP JOB SALARY DEPNO Joe 75 Santa Anita ST. 91006 Staff 3000 Jack 620 Jackson Ave. 91007 Staff 3500 Alen 91107 Accountant 8000 32 Hill Ave. Apt 12 510 Foothill apt 3 Jose 91016 Staff 4000 Sara 689 Hillcreast ave. 91007 Staff 3000 Marty 457 Brand ST. 91501 Developer Sam 56 Central St. 91501 Staff 2000 Jay 387 Pico Ave 90001 Staff 109 Robert 65 Brandy ST 91016 Manager 12000 110 Ann 888 Hill Ave 91006 Staff 2000 More than 10 rows available. Increase rows selector to view more rows