EarthSoft interview question

How to normalize a table using SQL.