The question is
write a query to view the original string in customers.state, beside a modified version of customers.state where 'California' is replaced by 'CA'
I have no clue how to view the original and the modified beside one another
the best i cam eup with was
alter table customers
add state varchar
set customers.state = replace(state, 'CA', 'California');
I know it's incorrect
can anyone help me or guide me please?
Ask the professor for clarification. Who/what replaced the data? What is the current table schema? Are you going to write query to modify the data or has someone already modified the data?