Data-Cleaning-Using-SQL

In this project i have followerd the following ETL process

1. Selecting Everything from the table
2. Converting the date to proper format
3. Filling Property Address by checking self join [If parcel id is same butnot have property address fill it with respective]
4. Property Address spliting into city and address
5. Spliting Owner Address
6. Cleaning for Sold as Vacant column
7. Removing Duplicates
8. Delete Unused Columns