EarthSoft Interview Question

How to normalize a table using SQL.