SQL generation method for complex pivot tables

In general, when you use a form to view data, a pivot table is involved from a different dimension. For example, analyze sales data from product and time dimensions.

When the need to analyze from the time dimension, but also want to have a year, the chain data, then the time dimension of the design column will greatly facilitate the writing of SQL.

Such as:

Products	Week	Last week	Week-over-quarter comparison	Monthly comparison
A
B

When you design a time dimension to a row, you make the corresponding SQL statement much more complex.

SQL generation method for complex pivot tables