News for hackers. Stuff that matters.
Re:Our SQL interview questions by shawabawa3 on Tuesday May 28, 2013 @09:18AM (#5779777)
> people often do an "inner join" leaving out empty departments

Empty departments have less than 3 people

Re:Our SQL interview questions by codegeek on Tuesday May 28, 2013 @09:20AM (#5779790)
correct. Edited.
Re:Our SQL interview questions by 3pt14159 on Tuesday May 28, 2013 @09:37AM (#5779915)
I 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.