hi there - am working on Sales table with COGS data within as below here; am trying to get Brand name with High sales value for INV & where Sales value is "zero" & Purchase is "greater" than "Zero"
i.e. line 3 should show "Brand" as "ABC" instead of "Misc - HW"
<tbody>
Type
Date
Num
Item...