Compute the tax-inclusive price once — inside the column
The shop stores prices in kopecks in the price_cents column and the tax rate in tax_rate. The backend assembles the tax-inclusive total — price_cents × (1 + tax_rate) / 100 — and the formula gets copy-pasted across the codebase.
Safer to compute it once inside the column itself. Build a products table with id (primary key), price_cents (integer, required), tax_rate (number with two decimals, default 0.20), and an auto-computed column total whose value always equals price_cents × (1 + tax_rate) / 100 and is stored physically. Insert one row with price_cents = 1000 and verify total was computed automatically.
Just CREATE/ALTER/DROP — no trailing SELECT needed.
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inNo starting schema
This task starts with no tables — you'll create them via CREATE TABLE.