By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| productcode | producttype | orders |
|---|---|---|
| ref02 | ALBUMS | 12 |
| ref07 | ALBUMS | 11 |
| ref06 | BOOKS | 20 |
| ref10 | TOYS | 19 |
SELECT 4
| productcode | producttype | orders |
|---|---|---|
| ref02 | ALBUMS | 12 |
| ref07 | ALBUMS | 11 |
| ref06 | BOOKS | 20 |
| ref10 | TOYS | 19 |
SELECT 4