mirror of
https://github.com/grocy/grocy.git
synced 2025-09-16 17:56:51 +00:00
10 lines
226 B
MySQL
10 lines
226 B
MySQL
|
DROP VIEW products_average_price;
|
||
|
|
CREATE VIEW products_average_price
|
||
|
|
AS
|
||
|
|
SELECT
|
||
|
|
1 AS id, -- Dummy, LessQL needs an id column
|
||
|
|
s.product_id,
|
||
|
|
SUM(s.amount * s.price) / SUM(s.amount) as price
|
||
|
|
FROM stock s
|
||
|
|
GROUP BY s.product_id;
|