Crosstabs, also known as pivots, are supported directly by SQL-92 and later. They provide a compact "spreadsheet-style" summary representation of data that varies in two (or more) dimensions. However, it is extremely difficult to use relational manipulation techniques on data that has already...