Advanced Database Query Exercise

From Arianne
Revision as of 10:11, 11 September 2011 by imported>Hendrik Brummermann (Created page with "This is an advanced version of the basic Database Query Exercise. You should probably do that one first. The same instructions apply: : Some tasks can be solved with one si...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

This is an advanced version of the basic Database Query Exercise. You should probably do that one first.

The same instructions apply:

Some tasks can be solved with one single query, other tasks may require a set of queries with human interaction in between. Please point out what to look for in the result set and anything else that should be kept in mind.
If possible explain how the results can be validated.

With the following addition: Make sure that you use the existing indices on large tables such as gameEvents and itemlog.

Example