In: Computer Science
Create a new table named CUSTOMER_STATUS.The table will hold the Customer_Status_Id and the Customer_Status_Description with possible values:
Inactive, Active, Very_Active
These values will be used to characterize the customers so that:
Inactive Customers => Have 0 orders
Active Customers => Have between 1 and 3 orders
Very Active Customers => Have 4 or more orders
ANS: Tables can be created by using CREATE table tablename .
Inside which the required attributes can be added.
Values to the attributes can be added by using INSERT into the TABLE values( );
The below screenshot shows the creation of table CUSTOMER_STATUS with required attributes and values: