we have the following table
tbl_goods
with colums:
id | order | reference | value | goods
I need the amount of different goods of one order
for example the table can be filled like underneath:
id | order | reference | value | goods
1 | A | sample | 50 | cherries
2 | A | sample | 50 | apples
3 | A | order591 | 200 | apples
4 | A | order621 | 150 | strawberries
5 | B | sample | 25 | cherries
So the correct awnser for order A in this case would be 3
anyone knows how this can be solved wthout using SQL?