BEGIN TRANSACTION;
 
CREATE TABLE prod(Id integer /*PRIMARY KEY*/, colors text, types text, weight text);
 
/* Create few records in this table */
INSERT INTO prod VALUES(111,'желтый', 'апельсин', 'кг');
INSERT INTO prod VALUES(111,'красный', 'апельсин', 'г');
INSERT INTO prod VALUES(111,'желтый', 'помидор', 'кг');
INSERT INTO prod VALUES(222,'желтый', 'помидор', 'г');
INSERT INTO prod VALUES(222,'красный', 'помидор','г');
INSERT INTO prod VALUES(333,'красный', 'помидор', 'г');
 
COMMIT;
 
SELECT p.colors, p.types, p.weight, count(p.id) as cnt
FROM prod p
group by p.colors, p.types, p.weight WITH ROLLUP;

QkVHSU4gVFJBTlNBQ1RJT047CgpDUkVBVEUgVEFCTEUgcHJvZChJZCBpbnRlZ2VyIC8qUFJJTUFSWSBLRVkqLywgY29sb3JzIHRleHQsIHR5cGVzIHRleHQsIHdlaWdodCB0ZXh0KTsKCi8qIENyZWF0ZSBmZXcgcmVjb3JkcyBpbiB0aGlzIHRhYmxlICovCklOU0VSVCBJTlRPIHByb2QgVkFMVUVTKDExMSwn0LbQtdC70YLRi9C5JywgJ9Cw0L/QtdC70YzRgdC40L0nLCAn0LrQsycpOwpJTlNFUlQgSU5UTyBwcm9kIFZBTFVFUygxMTEsJ9C60YDQsNGB0L3Ri9C5JywgJ9Cw0L/QtdC70YzRgdC40L0nLCAn0LMnKTsKSU5TRVJUIElOVE8gcHJvZCBWQUxVRVMoMTExLCfQttC10LvRgtGL0LknLCAn0L/QvtC80LjQtNC+0YAnLCAn0LrQsycpOwpJTlNFUlQgSU5UTyBwcm9kIFZBTFVFUygyMjIsJ9C20LXQu9GC0YvQuScsICfQv9C+0LzQuNC00L7RgCcsICfQsycpOwpJTlNFUlQgSU5UTyBwcm9kIFZBTFVFUygyMjIsJ9C60YDQsNGB0L3Ri9C5JywgJ9C/0L7QvNC40LTQvtGAJywn0LMnKTsKSU5TRVJUIElOVE8gcHJvZCBWQUxVRVMoMzMzLCfQutGA0LDRgdC90YvQuScsICfQv9C+0LzQuNC00L7RgCcsICfQsycpOwoKQ09NTUlUOwoKU0VMRUNUIHAuY29sb3JzLCBwLnR5cGVzLCBwLndlaWdodCwgY291bnQocC5pZCkgYXMgY250CkZST00gcHJvZCBwCmdyb3VwIGJ5IHAuY29sb3JzLCBwLnR5cGVzLCBwLndlaWdodCBXSVRIIFJPTExVUDs=