Drop links or images here to add them to the editor.
Toon per bestelling (bestelcode) het grootste aantal pizza’s van één soort. Noem de kolom max_aantal.
Bekijk de tabel besteldePizza
| besteldepizzacode | bestelcode | aantal | ... |
|---|---|---|---|
| 1 | 1 | 1 | ... |
| 2 | 1 | 1 | ... |
| 3 | 1 | 1 | ... |
| 4 | 2 | 3 | ... |
| 5 | 2 | 2 | ... |
| 6 | 2 | 3 | ... |
| 7 | 2 | 1 | ... |
| 8 | 2 | 3 | ... |
| 9 | 3 | 1 | ... |
| 10 | 3 | 2 | ... |
| ... | ... | ... | ... |