SELECT CUSTID, (SELECT ADDRESS FROM CUSTOMER CS WHERE CS.CUSTID = OD.CUSTID) "ADDRESS", SUM(OD.SALEPRICE) "TOTAL"FROM ORDERS ODGROUP BY OD.CUSTID; SELECT CS.NAME, SFROM (SELECT CUSTID, AVG(SALEPRICE) S FROM ORDERS GROUP BY CUSTID) OD, CUSTOMER CSWHERE CS.CUSTID=OD.CUSTID; CREATE VIEW VW_CUSTOMERAS SELECT * FROM CUSTOMER WHERE ADDRESS LIKE '%대한민국%'; SELECT * FROM VW_CUSTOMER; CREATE VIEW HIGHORDE..