select '藏品编号',sum('交易总额') from tablename where '创建时间'>'时间1' and '创建时间'<'时间2' group by '藏品编号';

SQL语句如下:

SELECT `no`,SUM(money) FROM `tb` GROUP BY `no`;

表结构如下图:

结果如下图:

SELECT cp_id,sum(jyze) FROM `tab` GROUP BY cp_id; jyze:交易总额 cp_id:藏品编号