Part $2$: Data Cleaning

For each question below $(1-4),$ you must include the following to obtain full

credit:

$$ Identification Query: A single SELECT query showing the data needing cleaning $($e$.$g$.$

SELECT $*$ FROM table WHERE column$\_$name $=$ 'None Given'$)$

$$ Update Query: The query that performs the update to the table

$$ Validation Query: A query validating the change

$$ Rationale Comment: A comment explaining the purpose of the modification and the

logic behind your choice. These rationales should be $2-3$ sentences in length.