extraction.sql

SELECT brew_id, ROUND(tds * volume / dose, 1) AS yield_pct
FROM brews
WHERE method = 'pour-over'
ORDER BY yield_pct DESC;

Yield per brew: dissolved solids times volume, divided by the dose.