select liquorname, sum(specialcount), categoryname, liquorretailweight, liquorretailprice from specialinventory join master on specialinventory.masterrecid = master.masterrecid join locationcategories on locationcategories.locationcategoryid = master.locationcategoryid where liquorname ilike '!%' and date >= '12/31/1969 ' and date <= '// ' group by liquorname, categoryname, liquorretailweight, liquorretailprice order by liquorname;
| specials and PLUs |
numbersold |
category |
% total |
% category |
individual price |
total price |
indvidual cost |
Total Cost |
Cost % |
| Total |
0 |
|
100% |
|
|
$0 |
|
$0 |
0% |