2 ms·
> people often do an "inner join" leaving out empty departments Empty departments have less than 3 people
by shawabawa3 13y ago
> people often do an "inner join" leaving out empty departments
Empty departments have less than 3 people
- codegeek 13y agocorrect. Edited.
- 3pt14159 13y agoI was following along (without peeking ahead) and I briefly thought "What about NULLs and empty joins?" But I figured, it is an idealized test. For example, what happens when a boss has a NULL department id? Would it be safe to say that they are in a different department than their underling? SQL says no. Besides that, I think this is a great test. Personally, I start off a bit slower so I don't embarrass people that don't know SQL.