By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ToolCode | count(WorkCenter) |
|---|---|
| Drill | 2 |
| Screwdriver | 2 |
| Saw | 3 |
| ToolCode | (SELECT Count(*) FROM CTE2 WHERE CTE2.WorkCenter Like concat('%',CTE1.TOOLCODE,'%')) |
|---|---|
| Drill | 2 |
| Screwdriver | 2 |
| Saw | 3 |