- In Sql Live Using The Oe Schema 1 (74.19 KiB) Viewed 31 times
In sql live using the OE schema
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
In sql live using the OE schema
In sql live using the OE schema
To calculate the Turnover and the Type of customers, follow the data preparation steps below: 1. CREATE a table CUSTOMER_COPY by copying the CUSTOMER table. 2. Add a column TUROVER NUMBER (12, 2) to the CUSTOMER_COPY table. 3. Write SQL correlated statements to populate the TUROVER column. 4. Display the entire content of the CUSTOMER_COPY table. 5. Add the column CUST_TYPE CHAR (1) to the CUSTOMER_COPY table. To populate the column CUST_TYPE with the appropriate TYPE, follow the steps below: 6. Implement a PL/SQL block using the IF and UPDATE statements to set the CUST_TYPE column value to 'A', 'B' or 'C' according to the rule explained above. 7. Display the whole content of the CUSTOMER_COPY table. 8. Display the number of customers, write it here......... 9. Count the number of Customers by CUST_TYPE, write it below: A ......... B C .........
To calculate the Turnover and the Type of customers, follow the data preparation steps below: 1. CREATE a table CUSTOMER_COPY by copying the CUSTOMER table. 2. Add a column TUROVER NUMBER (12, 2) to the CUSTOMER_COPY table. 3. Write SQL correlated statements to populate the TUROVER column. 4. Display the entire content of the CUSTOMER_COPY table. 5. Add the column CUST_TYPE CHAR (1) to the CUSTOMER_COPY table. To populate the column CUST_TYPE with the appropriate TYPE, follow the steps below: 6. Implement a PL/SQL block using the IF and UPDATE statements to set the CUST_TYPE column value to 'A', 'B' or 'C' according to the rule explained above. 7. Display the whole content of the CUSTOMER_COPY table. 8. Display the number of customers, write it here......... 9. Count the number of Customers by CUST_TYPE, write it below: A ......... B C .........