This a data cleaning and queries using Microsoft SQL Server The data set is from: https://ourworldindata.org/
In this script I use different statements to check and analyze info. SQL keywords are like:
select from
where
order by
MAX
SUM
JOIN
DROP
Insert Into Breaking out address into individual columns using: SUBSTRING, CHARINDEX Updating the table Split columns to divide the info, for example an address, statements used: PARSENAME, REPLACE Changing info of the columns using case when, when, else, end Remove duplicates using ROW_NUMBER Using CTE (Common Table Expression)
