Re: Help with structuring a nested query

[Laura M J Stewart]

Select all the records from table sql_store.order_statuses but populate current ‘Name’ column value in a new column called ‘New_Name’ and change values like below.
WHEN name = 'Processed' THEN 'P'
WHEN name = 'Shipped' THEN 'S'
WHEN name = 'Delivered' THEN 'D'

Basically, I have to add a new column with the one letter representing the values in the original column.
Please help, thank you!