Database Query Exercise

This articles gives you a number of task to solve based on a Stendhal Database.

TODO: Explain how to get a Stendhal Database

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.

Example

Get the email address of the account bob:

<source lang="sql"> SELECT email FROM account WHERE username='bob' </source>