3 ms·
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 in
by mhd 13y ago
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".
- arb99 13y agoI 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 https://gist.github.com/abkr/5662615
- petepete 13y agoI had the same idea, but in an SQL Fiddle http://sqlfiddle.com/#!1/778bb/5 http://sqlfiddle.com/#!1/778bb/5
- mhd 13y agoDidn't even know that there was such a thing as SQL Fiddle. That's going to come in handy, beyond this quiz, thanks.
- lostsock 13y agoIn 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 https://gist.github.com/dritterman/5662750