When someone can’t answer an interview question about relational databases, it might be that they don’t know anything about relational databases. I thought you all were better than this. Why are you asking questions about relational databases? Why not just have candidates accomplish the thing you're assessing with an actual relational database ? I know you're work-sample-literate! But if your feedback emphasizes comm…
I have been doing mysql database type things for 15 years solid. Once during a job interview at digg.com, someone [ok ok doxx removed] asked: "what is a having statement in sql?". I jumped in explained how you can filter aggregated sets performed by a 'group by' and rambled on and on. He stopped me and said, "You can use a having statement without a group by, are you sure you know how they work." I have never seen th…
[1] https://dba.stackexchange.com/questions/57445/use-of-having-...