By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| Id | year | employer_ein |
|---|---|---|
| 34323 | 2018 | A |
| 34323 | 2018 | B |
| 34323 | 2018 | C |
| 34323 | 2017 | A |
| 34323 | 2017 | B |
| 34323 | 2017 | F |
| 34383 | 2018 | A |
| 34383 | 2017 | A |
| id | year | new_ein_flag |
|---|---|---|
| 34383 | 2018 | 0 |
| 34323 | 2018 | 1 |