SQL recipes

SELECT list_transform(
  [12, 24, 36],
  lambda price: price * 1.2
) AS prices_with_tax;

SELECT regexp_replace(
  lower(trim('  Summer Harvest 2026  ')),
  '\s+', '-', 'g'
) AS slug;

SELECT
  date_trunc('month', sold_at) AS month,
  sum(amount) AS revenue
FROM (VALUES
  (DATE '2026-06-03', 120),
  (DATE '2026-06-18', 85),
  (DATE '2026-07-02', 150)
) AS sales(sold_at, amount)
GROUP BY 1 ORDER BY 1;

SELECT json_extract_string(
  '{"farm":"Willow Creek","crops":["apples","pears"]}',
  '$.farm'
) AS farm;

SELECT
  avg(yield_kg) AS average,
  median(yield_kg) AS median
FROM (VALUES (12), (14), (15), (16), (98))
  AS harvest(yield_kg);

SELECT
  range AS n,
  range * range AS squared
FROM range(1, 6);