LeetCode 1873 Interview SQL Question with Detailed Explanation | Practice SQL

preview_player
Показать описание
Previous Video: LeetCode 1821 Customers with Positive Revenue

In this video I solve and explain a leetcode SQL question using MySQL query. This question has been asked in Apple, Facebook, Amazon, Google, Adobe, Microsoft, Adobe interviews or what we popularly call FAANG interviews.
I explain the related concept as well. This question is about finding employee bonus and also includes points to keep in mind to develop SQL queries.

LeetCode is the best platform to help you enhance your skills, expand your knowledge and prepare for technical interviews.

If you found this helpful, Like and Subscribe to the channel for more content.

#LeetCodeSQL #FAANG #SQLinterviewQuestions
Рекомендации по теме
Комментарии
Автор

great walkthrough!

i tried a variation with
CASE WHEN employee_id %2 = 0 AND name LIKE 'M%' THEN 0 ELSE salary

it was rejected. any clue why this didnt work - it seems like it should have produced the same result

johnwayne
Автор

anything divide by 2 if it is = 0 it is an even number otherwise its an odd number? XD 2 is an even number 2/2 = 1 that means 2 is odd?
8/2 is 4, 8 is odd?

younewber