Aug 03, 2020 08:31 PM|mgebhard|LINK
The written requirement seems like a UNION query or a CTE. But the data example is not clear. It looks Qty and Sale_Price are both partitioned by the same range. Like many of your post, I think there is deeper issue with the general design.