题目链接:点击打开链接
题目大意:略。
解题思路:略。
AC 代码
--解决方案(1) selectseller_idfromsalesgroupbyseller_idhavingsum(price) >=all(selectsum(price) fromsalesgroupbyseller_id) --解决方案(2) SELECTseller_idFROMSalesGROUPBYseller_idHAVINGSUM(price) = (SELECTSUM(price) SUMNFROMSalesGROUPBYseller_idORDERBYSUMNDESCLIMIT1)