Books for you

Which drink leads to the highest performance? The Transmegtech people are having a
dispute with the new personnel from J. Lee Games. The new testers and programmers
drink Fresca, whereas the Transmegtech team prefers the Moxie energy drink.
Both sides claim their drink is superior, and leads to higher productivity and mental
agility. The management would like to know which drink leads to the highest performance,
with the data broken down by wins per game. In the interests of fairness,
they??™ve agreed to analyze data only from new titles developed by the joint company,
so old data won??™t cloud the analysis. This question can be answered with a combination
of grouping and aggregate functions, and that will be tackled second.
For the examples in this chapter, you??™ll use the schema shown in Listing 2-1.
nNote This and upcoming chapters use subqueries. Subqueries were not introduced into MySQL until
version 4.2. If you have an older version of MySQL, you??™ll need to upgrade to follow these examples.
Listing 2-1.


Pages:
36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60