Meta Interview Question

Given a raw data table, how would you write the SQL to perform the ETL to get data into a desired format?