First query:

SELECT ENAME, REPID, CUSTID, NAME, ADDRESS, TRIM(CITY)||', 
'||STATE||'  '||ZIP LOCATION,  AREA||' '||PHONE, CREDITLIMIT 
FROM EMP, CUSTOMER 
WHERE EMPNO = REPID 
ORDER BY REPID



Second query:

SELECT CUSTID,PRODNAME,AMOUNT
FROM SALES
ORDER BY CUSTID