✅MySQL || Beginner level||Simple-Short -Solution✅
Please upvote to motivate me in my quest of documenting all leetcode solutions. HAPPY CODING:)\nAny suggestions and improvements are always welcome.\n==========
**Please upvote to motivate me in my quest of documenting all leetcode solutions. HAPPY CODING:)\nAny suggestions and improvements are always welcome.***\n*====================================================================*\n\u2705 **MySQL Code :**\n**Runtime:** \t1022 ms, faster than 91.58% of MySQL online submissions for Sales Person\n```\nSELECT s.name\nFROM salesperson s\nlEFT JOIN orders o ON (o.sales_id=s.sales_id)\nLEFT JOIN company c ON (o.com_id=c.com_id)\nGROUP BY s.name\nHAVING COUNT(order_id)=0 OR NOT SUM(c.name=\'RED\')>0\n```\n**Runtime:** \t1022 ms\n**Memory Usage:**  0B\n________________________________\n__________________________________\n\nIf you like the solution, please upvote \uD83D\uDD3C\nFor any questions, or discussions, comment below. \uD83D\uDC47\uFE0F
['MySQL']