leetcodeSolution to some Leetcode problems written in C++ |
git clone git://git.dimitrijedobrota.com/leetcode.git |
Log | Files | Refs | README | LICENSE |
0607.sql (163B)
0 SELECT P.name
1 FROM Orders O
2 JOIN Company C
3 ON O.com_id = C.com_id AND C.name = 'RED'
4 RIGHT JOIN SalesPerson P
5 ON P.sales_id = O.sales_id
6 WHERE O.sales_id IS NULL