db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

Boss: derived fields

Let the database derive three fields so they can never drift from the source columns. Four hidden inserts prove them.

task

prod2(product_id, name, price_cents) exists. Add stored generated columns slug (lower name, spaces to dashes), price_eur (numeric(10,2) = cents/100) and is_cheap (price under 2000 cents).

hints