Content-Length: 299044 | pFad | https://github.com/iamAntimPal/LeetCode_SQL_Database/discussions/23#discussioncomment-12582053

0B LeetCode SQL 50 · iamAntimPal LeetCode_SQL_Database · Discussion #23 · GitHub
Skip to content

LeetCode SQL 50 #23

Answered by iamAntimPal
IamShiwangi asked this question in Q&A
Mar 21, 2025 · 1 comments · 1 reply
Discussion options

You must be logged in to vote
SELECT e1.employee_id
FROM
    Employees AS e1
    LEFT JOIN Employees AS e2 ON e1.manager_id = e2.employee_id
WHERE e1.salary < 30000 
  AND e1.manager_id IS NOT NULL 
  AND e2.employee_id IS NULL
ORDER BY 1;

for explanation click on me

Replies: 1 comment 1 reply

Comment options

You must be logged in to vote
1 reply
@IamShiwangi
Comment options

Answer selected by IamShiwangi
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Category
Q&A
Labels
None yet
2 participants








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: https://github.com/iamAntimPal/LeetCode_SQL_Database/discussions/23#discussioncomment-12582053

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy