Using Microsoft SQL Server, I altered the date to eliminate the time stamp, broke out the address by street, city and state, making them separate fields. I updated the language to be consistent by changing "Y "and "N" to "Yes" and "No", and deleted duplicate rows and unused columns.

Some skills used: SELF JOIN, ALTER TABLE, CASE, CTE, PARTITION BY

View my code on my GitHub profile.