183. 1873.(leetcode)

183. Customers Who Never Order

https://leetcode.com/problems/customers-who-never-order/description/?envType=study-plan&id=sql-i

SELECT A.name AS Customers 
FROM customers A LEFT JOIN orders B ON A.id = B.customerId
WHERE B.id is null

1873. Calculate Special Bonus

https://leetcode.com/problems/calculate-special-bonus/description/?envType=study-plan&id=sql-i

SELECT employee_id, CASE WHEN (employee_id %2) != 0 AND
name NOT LIKE ('M%') THEN salary ELSE 0 END bonus
FROM employees
ORDER BY employee_id