-- Total Unique Products
-- Total Unique products in deal_cartitem
-- FILTER: {
--   filter: "date",
--   column: "Send_Date",
--   params: {
--     "format": "m/d/y"
--   }
-- }
-- FILTER: {
--   filter: "class",
--   column: "products",
--   params: {
--     class: "text-right"
--   }
-- }


-- SELECT
--     to_char(count( distinct deal_cartitem.product_id), '999,999,999,999') as products
-- FROM simplebrsprod.deal_cartitem deal_cartitem

SELECT
    to_char(count( deal_cartitem.product_id), '999,999,999,999') as products
FROM simplebrsprod.deal_cartitem deal_cartitem
GROUP BY deal_cartitem.product_id;