Hands On SQL

Page 26: More ORDER BY, with SUM and GROUP BY

Use ORDER BY to find the winner of the Girl Sprout cookie sales contest (page 263).

Now, use SUM to add up the cookie sales (page 265); try adding GROUP BY to it yourself (page 266).

Finally, use AVG to find each Girl Sprout's daily average (page 267):


< Previous Page

Next Page >