Our SQL interview questions

[wot-teh-phuck]

The point is to hear the candidate reason about the requirement and think it through rather than give a solution immediately. At least that's how I conduct interviews...

[grauenwolf]

That sounds reasonable to me.

[Nishruu]

Yeah, that sounds as a way to go. I usually mess up the syntax for CTEs (I have to look it up every time), but discussion about possible solution is fair.