But maybe for once, Excell really was the right solution (I did not just say that!) Michiel Van Bel wrote:
Because we can! :p No other reason than that. Why would we write a char-skipping program in haskell, python, java and x86-assembly? Because we can!
Sofie Van Landeghem wrote:
Why the hell would you want to use SQL for that question though?
Kenny Billiau wrote:
Apparently, databases at hogent is now thought by our beloved Joris Moreau from Computer Graphics ;)
Check out the inwe wiki: http://wiki.inwe.be/index.php?title=Gegevensbanken
Those are some pretty hilevel and stupifying queries.
There are insane questions like: Give me a query which determines the date of the last 50 easters. No db needed or provided. The formula is: j = jaar - 1900 a = MOD(jaar - 1900, 19) b = FLOOR(( 7 * a + 1 ) / 19) c = MOD(11 * a + 4 - b, 29) d = 25 - c - MOD(j + FLOOR(j / 4) + 31 - c, 7)
;) (I know, in the end this ain't that hard, but still, this is not as easy as a squirrel homing in on a nut)
-Kenny
On Mon, 22 Sep 2008, Kenny Billiau wrote:
Hi,
I have to teach 40hours of SQL and I'm looking for excercises. Apparently I was so smart to save all my answers when I as in college, but the questions I forgot.
So, does anyone still have their DB cursus ( with exercises )?
Any gene related DBscheme or query questions are greatly appreciated.
Kenny
-- ================================================================== Sofie Van Landeghem PhD Student VIB Department of Plant Systems Biology, Ghent University Bioinformatics and Evolutionary Genomics Technologiepark 927, 9052 Gent, BELGIUM Tel: +32 (0)9 331 36 95 fax:+32 (0)9 3313809 Website: http://bioinformatics.psb.ugent.be ==================================================================