SOLVE:

PROBLEMS 12 & 13 THAT ARE REFERENCED:

12) Write the SQL code that will enter CUS_RANK of A for those customers whose balance is less than $250.

13) Write the SQL command sequences required to: a) Create a temporary table name TEMP_1, whose structure is composed of the CUSTOMER_2. b) Copy all rows from CUSTOMER_2 that contain the customers whose balance is in the range from $250 to $500 into the TEMP_1 table.

15) Suppose you were to repeat steps 12 or 13 very frequently, and your company has already established a way of describing customer balances as shown below: BALANCE LOW _LIMIT Excellent Good Boad HIGH LIMIT 0 250 +infinity 0 250 How would you introduce this knowledge into the database and make use of it? Write the SQL statements that support your solution to this problem. (Hint: there is no single right answer to this problem)