LeetCode 175: Combine Two Tables
A clear SQL guide for solving Combine Two Tables using LEFT JOIN.
Tag
Left-Join
4 notes
LeetCode 580: Count Student Number in Departments
A clear SQL guide for counting students in every department, including departments with zero students.
LeetCode 577: Employee Bonus
A clear SQL guide for finding employees whose bonus is less than 1000 or missing.
LeetCode 183: Customers Who Never Order
A clear SQL solution for finding customers who have no matching rows in the Orders table.