Couple this with the concept of correlated-subqueries (the process of running a "child" query for each row in the "parent" resultset), and you can get pretty much anything you want with 'simple' SQL.

Hey, been reading the board for a bit. First post. I'm having issues coming up with a SQL query that will provide the average admits for each day of the week. The data structure looks like this: ...