Calculated Columns in CTEs

CTEs are perfect for calculating derived values:

WITH product_metrics AS (
    SELECT 
        name,
        price,
        cost,
        price - cost as profit,
        (price - cost) / price * 100 as margin_pct
    FROM products
)
SELECT * FROM product_metrics WHERE margin_pct > 50;

Your Task

Create a CTE called product_margins that calculates for each product:

• name, category, price, cost
• profit (price - cost)
• margin_pct ((price - cost) / price * 100)

Then select products where margin_pct is greater than 50, ordered by margin_pct descending.