Sollicitatievraag bij UpEquity

Using SQL, how would you clean a messy, dirty dataset with nulls and differently formatted fields?