Create sales-person.sql

kamyu104 · web-flow · commit 7810d642946e · 2017-11-04T10:59:08.000-05:00
diff --git a/MySQL/sales-person.sql b/MySQL/sales-person.sql
@@ -0,0 +1,17 @@
+# Time:  O(s * o)
+# Space: O(s + o)
+
+SELECT
+    s.name
+FROM
+    salesperson AS s
+WHERE
+    s.sales_id NOT IN (SELECT
+            o.sales_id
+        FROM
+            orders AS o
+                LEFT JOIN
+            company AS c ON o.com_id = c.com_id
+        WHERE
+            c.name = 'RED')
+;
