By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 8 Duplicates: 0 Warnings: 0
| id | Description | Amount | Category |
|---|---|---|---|
| 1 | Food #1 | 1 | 1 |
| 2 | Non-food bla | 3 | 2 |
| 3 | Food banana | 5 | 1 |
| 4 | Non-food foo | 1 | 2 |
| 5 | Multiword prefix #1 | 3 | 2 |
| 6 | Multiword prefix #2 | 1 | 1 |
| 7 | Lonely prefix | 1 | 1 |
| 8 | Multiword | 1 | 1 |
| id | description | prefix |
|---|---|---|
| 1 | Food #1 | Food |
| 2 | Non-food bla | Non-food |
| 3 | Food banana | Food |
| 4 | Non-food foo | Non-food |
| 5 | Multiword prefix #1 | Multiword |
| 5 | Multiword prefix #1 | Multiword prefix |
| 6 | Multiword prefix #2 | Multiword |
| 6 | Multiword prefix #2 | Multiword prefix |
| 7 | Lonely prefix | Lonely |
| 8 | Multiword | Multiword |