leetcode

Unnamed repository; edit this file 'description' to name the repository.
Log | Files | Refs | README
commit 8cdde13c1f6c4c57e48dad169475a1aef45b9f71
parent f3da95d8d92f3f0b296789752589983a639dcd7b
Author: AndrewLockVI <andrewlaack1@gmail.com>
Date:   Fri, 14 Apr 2023 20:54:19 -0500

Find customer referee question

Diffstat:

Afind-customer-referee/find-customer-referee.sql | 6++++++


1 file changed, 6 insertions(+), 0 deletions(-)

diff --git a/find-customer-referee/find-customer-referee.sql b/find-customer-referee/find-customer-referee.sql
@@ -0,0 +1,6 @@
+--Return all customers where the referee id is not equal
+--to 2
+
+SELECT name 
+FROM Customer C
+WHERE C.referee_id != 2 OR C.referee_id IS NULL