data analysis | cleaning data with sql

I worked on cleaning and preparing hotel client data. I fixed a missing state value where Orlando had NULL by checking another table and confirming it belongs to Florida. I standardized the location fields by merging city and state into one column called city_state. I combined the clients and clients_split tables into a single dataset using a UNION.