尝试this：

CREATE TABLE animal_transactions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    store VARCHAR(10) NOT NULL,
    animal VARCHAR(10) NOT NULL,
    date DATE NOT NULL,
    quantity INT NOT NULL,
    moving_price DECIMAL(10, 2) NOT NULL
);

INSERT INTO animal_transactions (store, animal, date, quantity, moving_price)
VALUES
    ('QQQ', 'RAT', '2022-12-28', 1, 100),
    ('QQQ', 'RAT', '2022-12-31', -1, 200),
    ('BBB', 'RAT', '2022-11-23', 3, 50),
    ('BBB', 'RAT', '2022-11-28', 5, 100),
    ('BBB', 'RAT', '2022-11-30', 3, 800),
    ('BBB', 'CAT', '2022-12-27', 2, 100),
    ('BBB', 'CAT', '2022-12-28', 1, 90);

WITH DataSource AS
(
  SELECT *
        ,SUM(quantity) OVER (PARTITION BY store, animal ORDER BY date) culm_quantity
        ,ROW_NUMBER() OVER (PARTITION BY store, animal ORDER BY date DESC) row_id
  FROM animal_transactions
 
)
SELECT *
FROM DataSource
WHERE row_id = 1
ORDER BY store, animal, date

这个想法是按日期对每个商店和动物的数量进行求和。同时，将记录标记为最早的记录。
为了按日期过滤数据，请在CTE中添加WHERE子句。