SELECT * 
FROM NashvilleHousing;

ALTER TABLE NashvilleHousing
ADD SaleDateConverted DATE;

UPDATE NashvilleHousing
SET SaleDateConverted = CONVERT(date, SaleDate);

-- Populating Property Address Data
-- (code snippet for SELECT statement not shown here)

-- Update records with missing property addresses
UPDATE N1
SET PropertyAddress = ISNULL(N1.PropertyAddress, N2.PropertyAddress)
FROM NashvilleHousing N1
JOIN NashvilleHousing N2
	ON N1.ParcelID = N2.ParcelID
	AND N1.UniqueID <> N2.UniqueID
WHERE N1.PropertyAddress IS NULL;

-- Breaking Property Address Column
-- (code snippet for SELECT statement not shown here)

-- Add new columns
ALTER TABLE NashvilleHousing
ADD Address NVARCHAR(255);

-- Update the new columns
UPDATE NashvilleHousing
SET Address = SUBSTRING( PropertyAddress, 1, CHARINDEX(',', PropertyAddress)-1);

ALTER TABLE NashvilleHousing
ADD City NVARCHAR(255);

UPDATE NashvilleHousing
SET City = SUBSTRING(PropertyAddress, CHARINDEX(',', PropertyAddress)+1, LEN(PropertyAddress));

-- Changing 'Y' and 'N' to 'Yes' and 'No' in SoldAsVacant Column
-- (code snippet for SELECT statement not shown here)

-- Update the column
UPDATE NashvilleHousing
SET SoldAsVacant = CASE WHEN SoldAsVacant = 'Y' THEN 'Yes'
	   WHEN SoldAsVacant = 'N' THEN 'No'
	   ELSE SoldAsVacant
	   END;

-- Removing Duplicates
-- (code snippet for WITH statement not shown here)

-- Delete duplicates
WITH RowNumCte AS (
    -- ...
)
DELETE 
FROM RowNumCte
WHERE row_num > 1;

-- Deleting Unused Columns
ALTER TABLE NashvilleHousing
DROP COLUMN OwnerAddress, TaxDistrict, PropertyAddress;

### Checking the Result
Verify that the cleaning process was successful.