Data cleaning using SQL

Data cleaning is an essential process in the Data analytics lifecycle. It ensures data consistency for analysis. Clean data will also ensure consistent and accurate results. We have used Nashville Housing Data for data cleaning. The data collected was a part of a survey and had several inconsistent data. Below are some standard data cleaning practices in using SQL