Database Design Theory?

Dave Smith DavidSmith at
Wed Nov 9 11:34:25 MST 2005

> On Wed, 9 Nov 2005, Dave Smith wrote:
> Can you confirm or deny this idea (that I heard many times):
> most [if not all] of the "hairy SQL statements" in the assignments were
> hairy only because of arbitrary constraints (e.g. not being allowed to use
> "GROUP BY" or various other things that you'd use in "the real world" when
> trying to find the same data).

For the earlier assignments, we couldn't use aggregate functions like SUM
and COUNT (I guess to give us an appreciation for them). For later
assignments, we were free to use whatever SQL tricks we wanted, including
aggregate functions.


More information about the PLUG mailing list