Pergunta de entrevista da empresa UpEquity

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