SQL试题八

有一个直播主播收入表，还有一个被封禁的主播列表，请写一个sql输出每个未封禁的主播的收入总和。

主播输入表名称：user_income

封禁的主播表名称：banned_user

 

-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
SELECT uid,SUM(income_money)as "未被封禁金额" FROM user_income u
WHERE uid NOt IN (SELECT uid FROM banned_user)
GROUP BY uid
;

SELECT b.uid as "被封禁id",SUM(u.income_money) as "被封禁金额" 
FROM banned_user b
LEFT  JOIN user_income u
on b.uid = u.uid
GROUP BY b.uid

;