Now use the previous query as a subquery in the FROM statement (it will be used in place of a table). From this new "table" select the customer_id, the total_amount and a new column, named, customer_status, that has the following values:
a. very bad: when total_amount <= 50
b. bad: when total_amount > 50 and total_amount <=100
c. ok: when total_amount > 100 and total_amount <=150
d. good: when total_amount > 150 and total_amount <=200