力扣（leetcode）607和610题（MySQL）

607 销售员

题目链接：607.销售员

解答：

select SalesPerson.name from SalesPerson where SalesPerson.sales_id not in (select Orders.sales_id from Orders left join Company on Orders.com_id = Company.com_id where Company.name = 'RED');   

610 判断三角形

题目链接：610.判断三角形

解答：

方法一：用case…when…

select x,y,z,case when x+y>z and x+z>y and y+z>x then 'Yes' else 'No' end triangle from Triangle;

方法二：用if…

select x,y,z,if(x+y>z and x+z>y and y+z>x,'Yes','No') triangle from Triangle;