您如何在常见方案上建模数据变量方差？ SQL

I was thinking about some stuff lately and I was wondering what would be the RIGHT way to do something like the following scenario (I'm sure it is a quite common thing for DB guys to do something like it). I was thinking about some stuff lately and I w