News for hackers. Stuff that matters.
Re:Our SQL interview questions by mhd on Tuesday May 28, 2013 @08:58AM (#5779662)
A sample SQL file with dummy data would be much appreciated, I think. I guess some of us would like to try their luck.

At least this should be quicker in an interview situation than the usual "normalize this database" or "given this situation, define a database schema".

Re:Our SQL interview questions by arb99 on Tuesday May 28, 2013 @09:04AM (#5779694)
I made the tables quick to go through them. It could do with more data really but its got a few rows.

https://gist.github.com/abkr/5662615

Re:Our SQL interview questions by petepete on Tuesday May 28, 2013 @09:18AM (#5779776)
I had the same idea, but in an SQL Fiddle

http://sqlfiddle.com/#!1/778bb/5

Re:Our SQL interview questions by mhd on Tuesday May 28, 2013 @09:20AM (#5779793)
Didn't even know that there was such a thing as SQL Fiddle. That's going to come in handy, beyond this quiz, thanks.
Re:Our SQL interview questions by lostsock on Tuesday May 28, 2013 @09:28AM (#5779851)
In the same vain here are some very quickly put together answers if anyone is interested. I haven't tested these so they may not work. If you see any errors please let me know :)

https://gist.github.com/dritterman/5662750