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
--