By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
| day | day | num_overlaps |
|---|---|---|
| Monday | Monday | 2 |
| Monday | Thursday | 1 |
| Monday | Tuesday | 1 |
| Monday | Wednesday | 2 |
| Thursday | Monday | 1 |
| Thursday | Thursday | 1 |
| Thursday | Wednesday | 1 |
| Tuesday | Monday | 1 |
| Tuesday | Tuesday | 1 |
| Tuesday | Wednesday | 1 |
| Wednesday | Monday | 2 |
| Wednesday | Thursday | 1 |
| Wednesday | Tuesday | 1 |
| Wednesday | Wednesday | 2 |
| day | day | (No column name) |
|---|---|---|
| Monday | Monday | 2 |
| Monday | Thursday | 1 |
| Monday | Tuesday | 1 |
| Monday | Wednesday | 2 |
| Thursday | Monday | 1 |
| Thursday | Thursday | 1 |
| Thursday | Tuesday | 0 |
| Thursday | Wednesday | 1 |
| Tuesday | Monday | 1 |
| Tuesday | Thursday | 0 |
| Tuesday | Tuesday | 1 |
| Tuesday | Wednesday | 1 |
| Wednesday | Monday | 2 |
| Wednesday | Thursday | 1 |
| Wednesday | Tuesday | 1 |
| Wednesday | Wednesday | 2 |
Warning: Null value is eliminated by an aggregate or other SET operation.