By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Id | Name | State | Grade | Weight | random_val |
---|---|---|---|---|---|
1 | John | NY | 100 | 1 | 80 |
2 | Liam | NY | 90 | 2 | 90 |
3 | Olivia | NY | 90 | 3 | 90 |
4 | Emma | NY | 80 | 4 | 90 |
5 | James | CA | 10 | 1 | 10 |
6 | Henry | CA | 20 | 1 | 10 |
7 | Mia | NJ | 50 | 1 | 50 |
8 | Ava | NJ | 30 | 4 | 30 |
Id | Name | State | Grade | Weight | weight_range_lower | weight_range_upper | rand_threshold | random_grade |
---|---|---|---|---|---|---|---|---|
1 | John | NY | 100 | 1 | 0 | 1 | 2.858695269430704 | 90 |
2 | Liam | NY | 90 | 2 | 1 | 3 | 1.016128455303729 | 90 |
3 | Olivia | NY | 90 | 3 | 3 | 6 | 6.504556775562984 | 80 |
4 | Emma | NY | 80 | 4 | 6 | 10 | 9.474398819240182 | 80 |
5 | James | CA | 10 | 1 | 0 | 1 | 1.6115413174140651 | 20 |
6 | Henry | CA | 20 | 1 | 1 | 2 | 0.9571943608645297 | 10 |
7 | Mia | NJ | 50 | 1 | 0 | 1 | 4.878369783869357 | 30 |
8 | Ava | NJ | 30 | 4 | 1 | 5 | 2.2128913665310397 | 30 |
Id | Name | State | Grade | Weight | FIRST_VALUE(grade) OVER (PARTITION BY state ORDER BY weight * rand() DESC) |
---|---|---|---|---|---|
1 | John | NY | 100 | 1 | 100 |
2 | Liam | NY | 90 | 2 | 100 |
3 | Olivia | NY | 90 | 3 | 100 |
4 | Emma | NY | 80 | 4 | 100 |
5 | James | CA | 10 | 1 | 20 |
6 | Henry | CA | 20 | 1 | 20 |
7 | Mia | NJ | 50 | 1 | 30 |
8 | Ava | NJ | 30 | 4 | 30 |