Answer for case statement section in SQL course

https://365datascience.com/dwqa-answer/answer-for-case-statement-section-in-sql-course/ -

Hi Aimen!

Thanks for the kind words and reaching out.

Although the number of rows obtained is the same, the output as a whole is not identical at all.

If you use IS NOT NULL, you obtain only “Employee” in column is_manager.

If you use IS NULL (I think that’s what you meant, as opposed to NOT NULL which leads to an error message), then you will obtain only “Manager” in column is_manager.

Hope this helps.
Best,
Martin

#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy