db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

Normalize

orders_flat repeats the customer on every order and packs items into one text column. Split it so each fact lives once.

task

Split orders_flat(order_id, cust_name, cust_email, items_csv) into exactly three new tables with primary keys and two foreign keys. Keep orders_flat.

hints