Exercise

Using RIGHT() , LEFT() and REVERSE()

In the previous exercise, you used SUBSTRING() and CHARINDEX() to split the city_state column into two new columns.

This time you need to do the same, but using the LEFT(), RIGHT(), and REVERSE() functions.

Instructions

100 XP

Extract the name of the city using LEFT() and CHARINDEX().
Extract the name of the state using RIGHT(), CHARINDEX() and REVERSE().