Answer Happy

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 .........