today:
280
yesterday:
288
Total:
1,017,266

-- Customer by Order --
SELECT distinct c.CUSTOMER_ID , initcap(C.CUST_FIRST_NAME || ' ' || C.CUST_LAST_NAME)  Name, o.ORDER_ID, O.ORDER_TOTAL  
FROM DEMO_CUSTOMERS C, DEMO_ORDERS O, DEMO_ORDER_ITEMS I
where C.CUSTOMER_ID   = O.CUSTOMER_ID   and
      I.ORDER_ID = O.ORDER_ID


-- Customer by Product --
SELECT distinct c.CUSTOMER_ID , initcap(C.CUST_FIRST_NAME || ' ' || C.CUST_LAST_NAME)  Name, p.product_id, P.PRODUCT_DESCRIPTION  
FROM DEMO_CUSTOMERS C, DEMO_ORDERS O, DEMO_ORDER_ITEMS I,  DEMO_PRODUCT_INFO P
where C.CUSTOMER_ID (+)  = O.CUSTOMER_ID   and
      I.ORDER_ID = O.ORDER_ID and
      I.PRODUCT_ID = p.product_id


-- Customer by Order and Product --
SELECT distinct c.CUSTOMER_ID , initcap(C.CUST_FIRST_NAME || ' ' || C.CUST_LAST_NAME)  Name, i.order_item_id,  p.product_id, P.PRODUCT_DESCRIPTION  
FROM DEMO_CUSTOMERS C, DEMO_ORDERS O, DEMO_ORDER_ITEMS I,  DEMO_PRODUCT_INFO P
where C.CUSTOMER_ID (+)  = O.CUSTOMER_ID   and
      I.ORDER_ID = O.ORDER_ID and
      I.PRODUCT_ID = p.product_id (+)


-- Customer By Order & Non Order --
SELECT c.CUSTOMER_ID,  initcap(C.CUST_FIRST_NAME || ' ' || C.CUST_LAST_NAME)  Name,  min(O.ORDER_ID) Order_id
FROM DEMO_CUSTOMERS C, DEMO_ORDERS O
where C.CUSTOMER_ID  = O.CUSTOMER_ID (+)
        group by c.CUSTOMER_ID, C.CUST_FIRST_NAME, C.CUST_LAST_NAME order by c.customer_id

No. Subject Author Date Views
86 If you want to use EXISTS in a PL/SQL function returning BOOLEAN admin 2018.05.19 243
85 eeeeee admin 2018.06.21 242
84 CREATE VIEW admin 2016.05.13 241
83 Process admin 2018.05.05 239
» Report by Order / Product / Order and Product / By Order & Non Order admin 2016.04.29 239
81 3D Pie Chart admin 2016.05.17 235
80 All Data DELETE from Table admin 2018.05.10 231
79 use a validation function for an element in apex 5.0 admin 2018.05.19 226
78 IF/ELSE ... CASE WHEN admin 2018.06.25 223
77 MISSIONARY_SUB admin 2018.06.25 222
76 How to convert DATE to NUMBER admin 2018.05.27 217
75 Name Show admin 2016.04.28 217
74 TABLE PRINT admin 2018.06.18 210
73 Apex setup procedure admin 2016.04.28 198
72 Using SQL*Plus to Unlock and Change Passwords admin 2023.06.04 192
71 CREATE TABLESPACE admin 2016.04.28 192
70 Captcha Test file admin 2016.04.18 192
69 EXPORT & IMPORT admin 2016.05.01 188
68 UPDATE PROCESS admin 2016.04.28 188
67 CREATING A TABLE / SEQUENCE / TRIGGER admin 2016.04.28 186