Example queries against this table

1. Select first 5 products by price descending

   SQLCopy

   SELECT product_id, name, price, stock
   FROM products
   ORDER BY price DESC
   LIMIT 5;

2. Show total sum of all product prices in stock

   SQLCopy

   SELECT
     SUM(price * stock) AS total_inventory_value
   FROM products
   WHERE is_active = TRUE;

3. Show products with stock between 10 and 100

   SQLCopy

   SELECT name, price, stock
   FROM products
   WHERE stock BETWEEN 10 AND 100
   ORDER BY stock;

4. Show products with profit margin percentage

   SQLCopy

   SELECT
     name,
     price,
     cost,
     ROUND((price - cost) / price * 100, 2) AS margin_pct
   FROM products
   WHERE cost IS NOT NULL AND cost > 0
   ORDER BY margin_pct DESC;