storing intermediate computations? (2 replies)
(MySQL.com) Consider the following query for computing a weighted average:
SELECT a.x0, a.x1, a.name,
SUM(USERFN(a.x0, a.x1, b.x0, b.x1) * b.y) /
SUM(USERFN(a.x0, a.x1, b.x0, b.x1)) AS avg
FROM b
INNER JOIN a ON b.x0 < a.x1 AND b.x1 &
