​​题目​​​

有如下两张表T1130A


SQL每日一题(20201130)_二维码T1130BSQL每日一题(20201130)_字段_02

T1130B表的数据可以与T1130A表进行关联，T1130B表有字段Quantity，T1130A表有字段Type，怎么样用SQL实现把T1130B表Quantity的和，平均分给T1130A表的Type，不能存在小数，且平均数相加还要等于Quantity的和，预计结果如下：

SQL每日一题(20201130)_字段_03


​​​测试数据​​​

CREATE TABLE T1130A(
ID INT,
Type varchar(28)
)
INSERT INTO T1130A VALUES(1,'1-Series');
INSERT INTO T1130A VALUES(2,'1-Series');
INSERT INTO T1130A VALUES(3,'1-Series');
INSERT INTO T1130A VALUES(4,'2-Series');
INSERT INTO T1130A VALUES(5,'2-Series');
INSERT INTO T1130A VALUES(6,'2-Series');
INSERT INTO T1130A VALUES(7,'2-Series');
INSERT INTO T1130A VALUES(8,'2-Series');


CREATE TABLE T1130B(
ID INT,
Quantity INT
)
INSERT INTO T1130B VALUES(1,50);
INSERT INTO T1130B VALUES(2,50);
INSERT INTO T1130B VALUES(4,33);
INSERT INTO T1130B VALUES(5,33);
INSERT INTO T1130B VALUES(6,33);




——End——
后台回复关键字：1024，获取一份精心整理的技术干货