By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ID | SUBJECT | OPTION1 | OPTION2 | OPTION3 |
---|---|---|---|---|
1 | A | 1 | 0 | 0 |
2 | B | 2 | 0 | 0 |
3 | C | 0 | 10 | 0 |
4 | D | 0 | 20 | 0 |
5 | E | 0 | 30 | 0 |
6 | F | 0 | 40 | 0 |
7 | G | 0 | 0 | 100 |
8 | H | 0 | 0 | 200 |
9 | I | 0 | 0 | 300 |
10 | J | 1 | 10 | 0 |
11 | K | 1 | 0 | 100 |
12 | L | 0 | 10 | 100 |
ID | SUBJECT | SALE | DATESALE |
---|---|---|---|
1 | A | 25 | 2019-02-12 |
2 | A | 10 | 2020-04-20 |
3 | C | 15 | 2019-03-15 |
4 | C | 42 | 2019-05-17 |
5 | C | 75 | 2019-10-10 |
6 | D | 12 | 2020-06-07 |
7 | E | 29 | 2019-02-12 |
8 | F | 77 | 2020-05-14 |
9 | F | 88 | 2020-11-12 |
10 | K | 99 | 2018-09-30 |
OPT | SALED | NBR_SUB |
---|---|---|
option1 | 0 | 1 |
option1 | 1 | 1 |
option2 | 0 | 2 |
option2 | 1 | 2 |
option3 | 0 | 3 |
unknown | 0 | 3 |