By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| word0 | word1 | word2 | word3 |
|---|---|---|---|
| word 1 | word 2 | word 3 | word 4 |
| word 2 | word 2 | word 4 | word 5 |
| word 3 | word 4 | word 2 | word 2 |
| word 4 | word 5 | word 1 | word 3 |
| LEAST(t1.word, t2.word) | GREATEST(t1.word, t2.word) | COUNT(DISTINCT identity) |
|---|---|---|
| word 1 | word 2 | 1 |
| word 1 | word 3 | 2 |
| word 1 | word 4 | 2 |
| word 1 | word 5 | 1 |
| word 2 | word 3 | 2 |
| word 2 | word 4 | 3 |
| word 2 | word 5 | 1 |
| word 3 | word 4 | 3 |
| word 3 | word 5 | 1 |
| word 4 | word 5 | 2 |