7. VIEW - javabasedapplicationsw/EducationalMaterials GitHub Wiki

SELECT C.NAME AS CUSTOMER ,TO_CHAR(A.ORDER_DATE, 'YYYY') AS YEAR ,SUM(B.QUANTITY * B.UNIT_PRICE) AS SALES_AMOUNT FROM ORDERS A ,ORDER_ITEMS B ,CUSTOMERS C WHERE 1=1 AND A.STATUS = 'Shipped' AND A.ORDER_ID = B.ORDER_ID AND A.CUSTOMER_ID = C.CUSTOMER_ID GROUP BY C.NAME, TO_CHAR(A.ORDER_DATE, 'YYYY') ORDER BY C.NAME ;