Let's say my compagny delivers some specific food to restaurants when either when they buy some or automatically once a month.
In my database i have a table which lists every delivery, with the client, the product and the date.
How can i display something like that :
Delivery ID | Product | Date |
631 | rice | 05/08/2023 |
587 | sausage | 19/07/2023 |
561 | sausage, milk | 19/06/2023 |
which is the list of the last 3 delivery made to this client.