Utilized MS-SQl to clean Nashville Housing dataset with 56,600 rows.The following was the process involved in it.

1. Strandizing Format of the date Using CONVERT()
2. Populating the Adrress column
3. Segmenting Adrress in to individual columns
4. Changing Y and N to Yes and No in Sold as Vacant column
5. Removing Duplicate rows by ulilizing CTE.
6. Deleting Unused columns