GROUP BY is Broken?
Posted by: Kevin Wood Wood
Date: February 19, 2022 09:05AM
Date: February 19, 2022 09:05AM
Hi everyone,
Having an issue where the group by refuses to group by the month correctly...
If you group by one more column after sum, you can see that the months are not grouping correctly...
Here is the code:
Drop database if exists test;
Create Database test;
use test;
DROP TABLE if exists test_table ;
CREATE TABLE test_table (
BU varchar(15),
BU_Name VARCHAR(25),
Product VARCHAR(25),
Region VARCHAR(25),
Year INT,
Month Int,
Sum Int,
Total Int
);
INSERT INTO Test_Table (BU, BU_Name, Product, Region, Year, Month, Sum, Total)
VALUES
('Growth','Energy','Purple Pain','Midwest','2017','3','27','2835'),
('Growth','Energy','Purple Pain','Midwest','2017','8','34','3570'),
('Growth','Energy','Purple Pain','Midwest','2017','12','66','6930'),
('Growth','Energy','Purple Pain','Midwest','2018','1','131','13755'),
('Growth','Energy','Purple Pain','Midwest','2018','6','125','13125'),
('Growth','Energy','Purple Pain','Midwest','2018','12','80','8400'),
('Growth','Energy','Purple Pain','Midwest','2018','12','129','13545'),
('Growth','Energy','Purple Pain','Midwest','2019','6','96','9072'),
('Growth','Energy','Purple Pain','Midwest','2019','9','68','7140'),
('Growth','Energy','Purple Pain','Midwest','2019','11','12','1260'),
('Growth','Energy','Purple Pain','Midwest','2019','12','65','6825'),
('Growth','Energy','Purple Pain','Northeast','2017','3','7','735'),
('Growth','Energy','Purple Pain','Northeast','2017','8','44','4620'),
('Growth','Energy','Purple Pain','Northeast','2018','4','101','10605'),
('Growth','Energy','Purple Pain','Northeast','2018','11','55','5775'),
('Growth','Energy','Purple Pain','Northeast','2019','3','3','315'),
('Growth','Energy','Purple Pain','South','2017','4','1','105'),
('Growth','Energy','Purple Pain','South','2017','4','54','5670'),
('Growth','Energy','Purple Pain','South','2017','6','89','9345'),
('Growth','Energy','Purple Pain','South','2017','10','71','7455'),
('Growth','Energy','Purple Pain','South','2017','11','14','1470'),
('Growth','Energy','Purple Pain','South','2017','11','23','2415'),
('Growth','Energy','Purple Pain','South','2017','12','14','1470'),
('Growth','Energy','Purple Pain','South','2018','1','58','6090'),
('Growth','Energy','Purple Pain','South','2018','3','18','1890'),
('Growth','Energy','Purple Pain','South','2018','3','117','12285'),
('Growth','Energy','Purple Pain','South','2018','3','138','14490'),
('Growth','Energy','Purple Pain','South','2018','3','143','15015'),
('Growth','Energy','Purple Pain','South','2018','5','125','13125'),
('Growth','Energy','Purple Pain','South','2018','6','81','8505'),
('Growth','Energy','Purple Pain','South','2018','12','154','16170'),
('Growth','Energy','Purple Pain','South','2019','4','44','4620'),
('Growth','Energy','Purple Pain','South','2019','7','4','420'),
('Growth','Energy','Purple Pain','South','2019','7','23','2415'),
('Growth','Energy','Purple Pain','South','2019','7','37','3885'),
('Growth','Energy','Purple Pain','South','2019','7','41','4305'),
('Growth','Energy','Purple Pain','South','2019','7','77','8085'),
('Growth','Energy','Purple Pain','South','2019','8','12','1260'),
('Growth','Energy','Purple Pain','South','2019','11','79','8295'),
('Growth','Energy','Purple Pain','South','2019','11','86','9030'),
('Growth','Energy','Purple Pain','South','2019','12','38','3990'),
('Growth','Energy','Purple Pain','West','2017','1','86','9030'),
('Growth','Energy','Purple Pain','West','2017','2','93','9765'),
('Growth','Energy','Purple Pain','West','2017','6','3','315'),
('Growth','Energy','Purple Pain','West','2017','8','7','735'),
('Growth','Energy','Purple Pain','West','2017','11','5','525'),
('Growth','Energy','Purple Pain','West','2017','11','65','6825'),
('Growth','Energy','Purple Pain','West','2018','1','159','16695'),
('Growth','Energy','Purple Pain','West','2018','3','102','10710'),
('Growth','Energy','Purple Pain','West','2018','5','129','13545'),
('Growth','Energy','Purple Pain','West','2018','8','94','9870'),
('Growth','Energy','Purple Pain','West','2018','8','168','17640'),
('Growth','Energy','Purple Pain','West','2018','10','98','10290'),
('Growth','Energy','Purple Pain','West','2019','3','60','6300'),
('Growth','Energy','Purple Pain','West','2019','3','66','6930'),
('Growth','Energy','Purple Pain','West','2019','7','24','2520'),
('Growth','Energy','Purple Pain','West','2019','9','17','1785'),
('Growth','Energy','Purple Pain','West','2019','10','6','630'),
('Growth','Energy','Purple Pain','West','2019','10','9','945'),
('Growth','Energy','Purple Pain','West','2019','12','91','8599'),
('Growth','Energy','Red Hot Chili Peppers','Midwest','2017','2','64','14912'),
('Growth','Energy','Red Hot Chili Peppers','Midwest','2017','4','93','21669'),
('Growth','Energy','Red Hot Chili Peppers','Midwest','2017','5','32','7456'),
('Growth','Energy','Red Hot Chili Peppers','Midwest','2017','5','94','21902'),
('Growth','Energy','Red Hot Chili Peppers','Midwest','2018','1','94','21902'),
('Growth','Energy','Red Hot Chili Peppers','Midwest','2018','6','74','17242'),
('Growth','Energy','Red Hot Chili Peppers','Midwest','2018','6','180','41940'),
('Growth','Energy','Red Hot Chili Peppers','Midwest','2018','12','128','29824'),
('Growth','Energy','Red Hot Chili Peppers','Midwest','2019','1','12','2796'),
('Growth','Energy','Red Hot Chili Peppers','Midwest','2019','1','49','11417'),
('Growth','Energy','Red Hot Chili Peppers','Midwest','2019','2','82','19106'),
('Growth','Energy','Red Hot Chili Peppers','Midwest','2019','4','44','10252'),
('Growth','Energy','Red Hot Chili Peppers','Midwest','2019','10','77','17941'),
('Growth','Energy','Red Hot Chili Peppers','Northeast','2017','3','87','20271'),
('Growth','Energy','Red Hot Chili Peppers','Northeast','2017','4','77','17941'),
('Growth','Energy','Red Hot Chili Peppers','Northeast','2017','9','12','2796'),
('Growth','Energy','Red Hot Chili Peppers','Northeast','2018','5','130','30290'),
('Growth','Energy','Red Hot Chili Peppers','Northeast','2018','12','63','14679'),
('Growth','Energy','Red Hot Chili Peppers','Northeast','2019','1','20','4660'),
('Growth','Energy','Red Hot Chili Peppers','Northeast','2019','11','67','15611'),
('Growth','Energy','Red Hot Chili Peppers','Northeast','2019','12','17','3961'),
('Growth','Energy','Red Hot Chili Peppers','South','2017','1','23','5359'),
('Growth','Energy','Red Hot Chili Peppers','South','2017','4','82','19106'),
('Growth','Energy','Red Hot Chili Peppers','South','2017','5','44','10252'),
('Growth','Energy','Red Hot Chili Peppers','South','2017','7','11','2563'),
('Growth','Energy','Red Hot Chili Peppers','South','2018','1','153','35649'),
('Growth','Energy','Red Hot Chili Peppers','South','2018','1','159','37047'),
('Growth','Energy','Red Hot Chili Peppers','South','2018','5','45','10485'),
('Growth','Energy','Red Hot Chili Peppers','South','2018','6','162','37746'),
('Growth','Energy','Red Hot Chili Peppers','South','2018','10','155','36115'),
('Growth','Energy','Red Hot Chili Peppers','South','2019','1','24','5592'),
('Growth','Energy','Red Hot Chili Peppers','South','2019','5','57','13281'),
('Growth','Energy','Red Hot Chili Peppers','South','2019','9','59','13747'),
('Growth','Energy','Red Hot Chili Peppers','South','2019','10','68','15844'),
('Growth','Energy','Red Hot Chili Peppers','West','2017','1','42','9786'),
('Growth','Energy','Red Hot Chili Peppers','West','2017','2','36','8388'),
('Growth','Energy','Red Hot Chili Peppers','West','2017','10','9','2097'),
('Growth','Energy','Red Hot Chili Peppers','West','2017','11','87','20271'),
('Growth','Energy','Red Hot Chili Peppers','West','2017','12','39','9087'),
('Growth','Energy','Red Hot Chili Peppers','West','2018','2','57','13281'),
('Growth','Energy','Red Hot Chili Peppers','West','2018','3','38','8854'),
('Growth','Energy','Red Hot Chili Peppers','West','2018','6','106','24698'),
('Growth','Energy','Red Hot Chili Peppers','West','2018','8','131','30523'),
('Growth','Energy','Red Hot Chili Peppers','West','2018','10','81','18873'),
('Growth','Energy','Red Hot Chili Peppers','West','2018','10','115','26795'),
('Growth','Energy','Red Hot Chili Peppers','West','2018','11','172','40076'),
('Growth','Energy','Red Hot Chili Peppers','West','2019','4','14','3262'),
('Growth','Energy','Red Hot Chili Peppers','West','2019','4','79','18407'),
('Growth','Energy','Red Hot Chili Peppers','West','2019','12','38','8854'),
('Growth','Energy','Red Hot Chili Peppers','West','2019','12','54','12582'),
('Growth','Energy','Red Hot Chili Peppers','West','2019','12','66','15378'),
('Growth','Snack','Crocodile Tears','Midwest','2017','2','42','6006'),
('Growth','Snack','Crocodile Tears','Midwest','2017','3','90','12870'),
('Growth','Snack','Crocodile Tears','Midwest','2017','5','94','13442'),
('Growth','Snack','Crocodile Tears','Midwest','2018','1','101','14443'),
('Growth','Snack','Crocodile Tears','Midwest','2018','2','166','23738'),
('Growth','Snack','Crocodile Tears','Midwest','2018','6','30','4290'),
('Growth','Snack','Crocodile Tears','Midwest','2018','7','59','8437'),
('Growth','Snack','Crocodile Tears','Midwest','2018','8','10','1430'),
('Growth','Snack','Crocodile Tears','Midwest','2018','8','163','23309'),
('Growth','Snack','Crocodile Tears','Midwest','2018','10','69','9867'),
('Growth','Snack','Crocodile Tears','Midwest','2019','4','43','6149'),
('Growth','Snack','Crocodile Tears','Midwest','2019','9','5','715'),
('Growth','Snack','Crocodile Tears','Midwest','2019','12','57','8151'),
('Growth','Snack','Crocodile Tears','Northeast','2017','6','23','3289'),
('Growth','Snack','Crocodile Tears','Northeast','2017','10','18','2574'),
('Growth','Snack','Crocodile Tears','Northeast','2018','1','104','14872'),
('Growth','Snack','Crocodile Tears','Northeast','2018','6','47','6721'),
('Growth','Snack','Crocodile Tears','Northeast','2018','9','126','18018'),
('Growth','Snack','Crocodile Tears','Northeast','2019','7','55','7865'),
('Growth','Snack','Crocodile Tears','Northeast','2019','8','68','9724'),
('Growth','Snack','Crocodile Tears','South','2017','4','83','11869'),
('Growth','Snack','Crocodile Tears','South','2017','5','48','6864'),
('Growth','Snack','Crocodile Tears','South','2017','8','5','715'),
('Growth','Snack','Crocodile Tears','South','2017','11','67','9581'),
('Growth','Snack','Crocodile Tears','South','2017','12','73','10439'),
('Growth','Snack','Crocodile Tears','South','2018','1','138','19734'),
('Growth','Snack','Crocodile Tears','South','2018','1','147','21021'),
('Growth','Snack','Crocodile Tears','South','2018','1','154','22022'),
('Growth','Snack','Crocodile Tears','South','2018','2','104','14872'),
('Growth','Snack','Crocodile Tears','South','2018','3','92','13156'),
('Growth','Snack','Crocodile Tears','South','2018','3','125','17875'),
('Growth','Snack','Crocodile Tears','South','2018','4','102','14586'),
('Growth','Snack','Crocodile Tears','South','2018','5','120','17160'),
('Growth','Snack','Crocodile Tears','South','2018','6','160','22880'),
('Growth','Snack','Crocodile Tears','South','2018','7','129','18447'),
('Growth','Snack','Crocodile Tears','South','2018','8','49','7007'),
('Growth','Snack','Crocodile Tears','South','2018','9','144','20592'),
('Growth','Snack','Crocodile Tears','South','2019','1','7','1001'),
('Growth','Snack','Crocodile Tears','South','2019','2','17','2431'),
('Growth','Snack','Crocodile Tears','South','2019','3','34','4862'),
('Growth','Snack','Crocodile Tears','South','2019','3','71','10153'),
('Growth','Snack','Crocodile Tears','South','2019','4','40','5720'),
('Growth','Snack','Crocodile Tears','South','2019','4','88','12584'),
('Growth','Snack','Crocodile Tears','South','2019','5','16','2288'),
('Growth','Snack','Crocodile Tears','South','2019','5','93','11969'),
('Growth','Snack','Crocodile Tears','South','2019','6','7','1001'),
('Growth','Snack','Crocodile Tears','South','2019','6','76','10868'),
('Growth','Snack','Crocodile Tears','South','2019','7','25','3575'),
('Growth','Snack','Crocodile Tears','South','2019','8','48','6864'),
('Growth','Snack','Crocodile Tears','South','2019','12','23','3289'),
('Growth','Snack','Crocodile Tears','South','2019','12','68','9724'),
('Growth','Snack','Crocodile Tears','West','2017','6','66','9438'),
('Growth','Snack','Crocodile Tears','West','2017','9','69','9867'),
('Growth','Snack','Crocodile Tears','West','2017','10','92','13156'),
('Growth','Snack','Crocodile Tears','West','2017','12','64','9152'),
('Growth','Snack','Crocodile Tears','West','2018','1','116','16588'),
('Growth','Snack','Crocodile Tears','West','2018','12','61','8723'),
('Growth','Snack','Crocodile Tears','West','2019','7','12','1716'),
('Growth','Snack','Crocodile Tears','West','2019','12','7','1001'),
('Mature','Health','Panda Gummies','Midwest','2017','3','3','312'),
('Mature','Health','Panda Gummies','Midwest','2017','4','11','1144'),
('Mature','Health','Panda Gummies','Midwest','2017','12','87','9048'),
('Mature','Health','Panda Gummies','Midwest','2018','9','126','13104'),
('Mature','Health','Panda Gummies','Midwest','2018','12','107','11128'),
('Mature','Health','Panda Gummies','Midwest','2019','3','71','7384'),
('Mature','Health','Panda Gummies','Midwest','2019','6','79','8216'),
('Mature','Health','Panda Gummies','Midwest','2019','8','33','3432'),
('Mature','Health','Panda Gummies','Midwest','2019','11','2','208'),
('Mature','Health','Panda Gummies','Northeast','2017','3','11','1144'),
('Mature','Health','Panda Gummies','Northeast','2017','9','15','1560'),
('Mature','Health','Panda Gummies','Northeast','2017','9','91','9464'),
('Mature','Health','Panda Gummies','Northeast','2018','2','55','5720'),
('Mature','Health','Panda Gummies','Northeast','2018','3','33','3432'),
('Mature','Health','Panda Gummies','Northeast','2018','6','91','9464'),
('Mature','Health','Panda Gummies','Northeast','2018','11','101','10504'),
('Mature','Health','Panda Gummies','Northeast','2018','11','125','13000'),
('Mature','Health','Panda Gummies','Northeast','2019','4','1','104'),
('Mature','Health','Panda Gummies','Northeast','2019','12','38','3952'),
('Mature','Health','Panda Gummies','South','2017','1','14','1456'),
('Mature','Health','Panda Gummies','South','2017','2','98','10192'),
('Mature','Health','Panda Gummies','South','2017','3','2','208'),
('Mature','Health','Panda Gummies','South','2017','3','13','1352'),
('Mature','Health','Panda Gummies','South','2017','3','56','5824'),
('Mature','Health','Panda Gummies','South','2017','7','68','7072'),
('Mature','Health','Panda Gummies','South','2017','12','16','1664'),
('Mature','Health','Panda Gummies','South','2017','12','26','2704'),
('Mature','Health','Panda Gummies','South','2018','4','79','8216'),
('Mature','Health','Panda Gummies','South','2018','4','138','14352'),
('Mature','Health','Panda Gummies','South','2018','6','105','10920'),
('Mature','Health','Panda Gummies','South','2018','9','53','5512'),
('Mature','Health','Panda Gummies','South','2018','9','59','6136'),
('Mature','Health','Panda Gummies','South','2018','9','100','10400'),
('Mature','Health','Panda Gummies','South','2018','9','113','11752'),
('Mature','Health','Panda Gummies','South','2018','10','192','19968'),
('Mature','Health','Panda Gummies','South','2018','12','117','12168'),
('Mature','Health','Panda Gummies','South','2018','12','131','13624'),
('Mature','Health','Panda Gummies','South','2019','5','37','3848'),
('Mature','Health','Panda Gummies','South','2019','6','40','4160'),
('Mature','Health','Panda Gummies','South','2019','6','59','6136'),
('Mature','Health','Panda Gummies','South','2019','8','18','1872'),
('Mature','Health','Panda Gummies','South','2019','11','96','8986'),
('Mature','Health','Panda Gummies','West','2017','3','27','2808'),
('Mature','Health','Panda Gummies','West','2017','7','5','520'),
('Mature','Health','Panda Gummies','West','2017','9','19','1976'),
('Mature','Health','Panda Gummies','West','2017','10','30','3120'),
('Mature','Health','Panda Gummies','West','2017','11','84','8736'),
('Mature','Health','Panda Gummies','West','2018','5','125','13000'),
('Mature','Health','Panda Gummies','West','2018','7','40','4160'),
('Mature','Health','Panda Gummies','West','2018','10','94','9776'),
('Mature','Health','Panda Gummies','West','2018','10','101','10504'),
('Mature','Health','Panda Gummies','West','2018','11','157','16328'),
('Mature','Health','Panda Gummies','West','2019','1','75','7800'),
('Mature','Health','Panda Gummies','West','2019','5','95','8892'),
('Mature','Health','Panda Gummies','West','2019','6','19','1976'),
('Mature','Health','Panda Gummies','West','2019','9','20','2080'),
('Mature','Health','Panda Gummies','West','2019','12','96','8986'),
('Mature','Lunchtime','Green Lightning','Midwest','2018','2','33','5313'),
('Mature','Lunchtime','Green Lightning','Midwest','2018','3','114','18354'),
('Mature','Lunchtime','Green Lightning','Midwest','2018','3','119','19159'),
('Mature','Lunchtime','Green Lightning','Midwest','2018','10','155','24955'),
('Mature','Lunchtime','Green Lightning','Midwest','2019','4','91','13186'),
('Mature','Lunchtime','Green Lightning','Midwest','2019','5','64','10304'),
('Mature','Lunchtime','Green Lightning','Midwest','2019','12','52','8372'),
('Mature','Lunchtime','Green Lightning','Midwest','2019','12','66','10626'),
('Mature','Lunchtime','Green Lightning','Northeast','2018','5','105','16905'),
('Mature','Lunchtime','Green Lightning','Northeast','2018','6','30','4830'),
('Mature','Lunchtime','Green Lightning','Northeast','2018','8','90','14490'),
('Mature','Lunchtime','Green Lightning','Northeast','2018','8','126','20286'),
('Mature','Lunchtime','Green Lightning','Northeast','2018','8','131','21091'),
('Mature','Lunchtime','Green Lightning','Northeast','2018','11','134','21574'),
('Mature','Lunchtime','Green Lightning','Northeast','2019','2','45','7245'),
('Mature','Lunchtime','Green Lightning','Northeast','2019','10','9','1449'),
('Mature','Lunchtime','Green Lightning','South','2018','1','58','9338'),
('Mature','Lunchtime','Green Lightning','South','2018','2','105','16905'),
('Mature','Lunchtime','Green Lightning','South','2018','2','169','27209'),
('Mature','Lunchtime','Green Lightning','South','2018','5','41','6601'),
('Mature','Lunchtime','Green Lightning','South','2018','5','47','7567'),
('Mature','Lunchtime','Green Lightning','South','2018','5','85','13685'),
('Mature','Lunchtime','Green Lightning','South','2018','5','145','23345'),
('Mature','Lunchtime','Green Lightning','South','2018','10','123','19803'),
('Mature','Lunchtime','Green Lightning','South','2018','12','91','14651'),
('Mature','Lunchtime','Green Lightning','South','2019','1','29','4669'),
('Mature','Lunchtime','Green Lightning','South','2019','2','68','10948'),
('Mature','Lunchtime','Green Lightning','South','2019','5','47','7567'),
('Mature','Lunchtime','Green Lightning','South','2019','9','36','5796'),
('Mature','Lunchtime','Green Lightning','South','2019','9','87','14007'),
('Mature','Lunchtime','Green Lightning','West','2018','4','109','17549'),
('Mature','Lunchtime','Green Lightning','West','2018','5','72','11592'),
('Mature','Lunchtime','Green Lightning','West','2018','5','111','17871'),
('Mature','Lunchtime','Green Lightning','West','2018','8','32','5152'),
('Mature','Lunchtime','Green Lightning','West','2018','8','123','19803'),
('Mature','Lunchtime','Green Lightning','West','2019','3','62','9982'),
('Mature','Lunchtime','Green Lightning','West','2019','6','78','12558'),
('Mature','Lunchtime','Green Lightning','West','2019','7','81','13041'),
('Mature','Lunchtime','Green Lightning','West','2019','8','67','10787'),
('Mature','Lunchtime','Green Lightning','West','2019','10','67','10787'),
('Mature','Lunchtime','Green Lightning','West','2019','11','97','14055'),
('Mature','Lunchtime','Green Lightning','West','2019','12','40','6440'),
('Mature','Lunchtime','Green Lightning','West','2019','12','56','9016'),
('Mature','Lunchtime','Orange Creepies','Midwest','2019','1','10','3000'),
('Mature','Lunchtime','Orange Creepies','Midwest','2019','4','13','3900'),
('Mature','Lunchtime','Orange Creepies','Midwest','2019','7','71','21300'),
('Mature','Lunchtime','Orange Creepies','Midwest','2019','10','65','19500'),
('Mature','Lunchtime','Orange Creepies','Northeast','2019','6','58','17400'),
('Mature','Lunchtime','Orange Creepies','Northeast','2019','11','86','25800'),
('Mature','Lunchtime','Orange Creepies','South','2019','3','33','9900'),
('Mature','Lunchtime','Orange Creepies','South','2019','3','81','24300'),
('Mature','Lunchtime','Orange Creepies','South','2019','4','3','900'),
('Mature','Lunchtime','Orange Creepies','South','2019','4','28','8400'),
('Mature','Lunchtime','Orange Creepies','South','2019','6','8','2400'),
('Mature','Lunchtime','Orange Creepies','South','2019','6','26','7800'),
('Mature','Lunchtime','Orange Creepies','South','2019','7','62','18600'),
('Mature','Lunchtime','Orange Creepies','South','2019','10','55','16500'),
('Mature','Lunchtime','Orange Creepies','South','2019','12','88','26400'),
('Mature','Lunchtime','Orange Creepies','South','2019','12','100','27000'),
('Mature','Lunchtime','Orange Creepies','West','2019','1','4','1200'),
('Mature','Lunchtime','Orange Creepies','West','2019','1','47','14100'),
('Mature','Lunchtime','Orange Creepies','West','2019','1','59','17700'),
('Mature','Lunchtime','Orange Creepies','West','2019','2','76','22800'),
('Mature','Lunchtime','Orange Creepies','West','2019','5','76','22800'),
('Mature','Lunchtime','Orange Creepies','West','2019','6','67','20100'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2017','11','64','8576'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2017','12','91','12194'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2018','1','159','21306'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2018','3','136','18224'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2018','3','175','23450'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2018','4','120','16080'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2018','5','52','6968'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2018','6','86','11524'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2018','6','95','12730'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2018','6','143','19162'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2018','9','62','8308'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2018','12','137','18358'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2019','7','61','8174'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2019','11','29','3886'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2019','11','33','4422'),
('Mature','Lunchtime','Yellow Zonkers','Northeast','2017','2','7','938'),
('Mature','Lunchtime','Yellow Zonkers','Northeast','2017','2','77','10318'),
('Mature','Lunchtime','Yellow Zonkers','Northeast','2017','9','92','12328'),
('Mature','Lunchtime','Yellow Zonkers','Northeast','2018','5','119','15946'),
('Mature','Lunchtime','Yellow Zonkers','Northeast','2018','6','62','8308'),
('Mature','Lunchtime','Yellow Zonkers','Northeast','2018','8','98','13132'),
('Mature','Lunchtime','Yellow Zonkers','Northeast','2018','11','41','5494'),
('Mature','Lunchtime','Yellow Zonkers','Northeast','2018','12','127','17018'),
('Mature','Lunchtime','Yellow Zonkers','Northeast','2019','3','16','2144'),
('Mature','Lunchtime','Yellow Zonkers','Northeast','2019','5','24','3216'),
('Mature','Lunchtime','Yellow Zonkers','Northeast','2019','5','57','7638'),
('Mature','Lunchtime','Yellow Zonkers','Northeast','2019','7','100','12060'),
('Mature','Lunchtime','Yellow Zonkers','South','2017','4','97','12998'),
('Mature','Lunchtime','Yellow Zonkers','South','2017','5','94','12596'),
('Mature','Lunchtime','Yellow Zonkers','South','2017','6','20','2680'),
('Mature','Lunchtime','Yellow Zonkers','South','2017','6','94','12596'),
('Mature','Lunchtime','Yellow Zonkers','South','2017','8','51','6834'),
('Mature','Lunchtime','Yellow Zonkers','South','2017','10','61','8174'),
('Mature','Lunchtime','Yellow Zonkers','South','2017','11','67','8978'),
('Mature','Lunchtime','Yellow Zonkers','South','2018','4','141','18894'),
('Mature','Lunchtime','Yellow Zonkers','South','2018','11','98','13132'),
('Mature','Lunchtime','Yellow Zonkers','South','2019','5','2','268'),
('Mature','Lunchtime','Yellow Zonkers','South','2019','6','25','3350'),
('Mature','Lunchtime','Yellow Zonkers','South','2019','7','29','3886'),
('Mature','Lunchtime','Yellow Zonkers','South','2019','8','62','8308'),
('Mature','Lunchtime','Yellow Zonkers','South','2019','9','43','5762'),
('Mature','Lunchtime','Yellow Zonkers','South','2019','11','37','4958'),
('Mature','Lunchtime','Yellow Zonkers','West','2017','7','53','7102'),
('Mature','Lunchtime','Yellow Zonkers','West','2017','7','59','7906'),
('Mature','Lunchtime','Yellow Zonkers','West','2017','12','29','3886'),
('Mature','Lunchtime','Yellow Zonkers','West','2018','11','146','19564'),
('Mature','Lunchtime','Yellow Zonkers','West','2018','12','138','18492'),
('Mature','Lunchtime','Yellow Zonkers','West','2018','12','172','23048'),
('Mature','Lunchtime','Yellow Zonkers','West','2019','4','24','3216'),
('Mature','Lunchtime','Yellow Zonkers','West','2019','5','20','2680'),
('Mature','Lunchtime','Yellow Zonkers','West','2019','9','18','2412'),
('Mature','Lunchtime','Yellow Zonkers','West','2019','10','35','4690'),
('Mature','Lunchtime','Yellow Zonkers','West','2019','10','37','4958'),
('Mature','Lunchtime','Yellow Zonkers','West','2019','12','49','6566');
select * from test_table
group by BU,BU_Name,Product,Region,Year,Month;
# Remove SUM and the group by month drops values (doesn't include them in the sum)...
#look at row 6 and 7... run again without sum and the 129 disapears and is not added into the sum
Having an issue where the group by refuses to group by the month correctly...
If you group by one more column after sum, you can see that the months are not grouping correctly...
Here is the code:
Drop database if exists test;
Create Database test;
use test;
DROP TABLE if exists test_table ;
CREATE TABLE test_table (
BU varchar(15),
BU_Name VARCHAR(25),
Product VARCHAR(25),
Region VARCHAR(25),
Year INT,
Month Int,
Sum Int,
Total Int
);
INSERT INTO Test_Table (BU, BU_Name, Product, Region, Year, Month, Sum, Total)
VALUES
('Growth','Energy','Purple Pain','Midwest','2017','3','27','2835'),
('Growth','Energy','Purple Pain','Midwest','2017','8','34','3570'),
('Growth','Energy','Purple Pain','Midwest','2017','12','66','6930'),
('Growth','Energy','Purple Pain','Midwest','2018','1','131','13755'),
('Growth','Energy','Purple Pain','Midwest','2018','6','125','13125'),
('Growth','Energy','Purple Pain','Midwest','2018','12','80','8400'),
('Growth','Energy','Purple Pain','Midwest','2018','12','129','13545'),
('Growth','Energy','Purple Pain','Midwest','2019','6','96','9072'),
('Growth','Energy','Purple Pain','Midwest','2019','9','68','7140'),
('Growth','Energy','Purple Pain','Midwest','2019','11','12','1260'),
('Growth','Energy','Purple Pain','Midwest','2019','12','65','6825'),
('Growth','Energy','Purple Pain','Northeast','2017','3','7','735'),
('Growth','Energy','Purple Pain','Northeast','2017','8','44','4620'),
('Growth','Energy','Purple Pain','Northeast','2018','4','101','10605'),
('Growth','Energy','Purple Pain','Northeast','2018','11','55','5775'),
('Growth','Energy','Purple Pain','Northeast','2019','3','3','315'),
('Growth','Energy','Purple Pain','South','2017','4','1','105'),
('Growth','Energy','Purple Pain','South','2017','4','54','5670'),
('Growth','Energy','Purple Pain','South','2017','6','89','9345'),
('Growth','Energy','Purple Pain','South','2017','10','71','7455'),
('Growth','Energy','Purple Pain','South','2017','11','14','1470'),
('Growth','Energy','Purple Pain','South','2017','11','23','2415'),
('Growth','Energy','Purple Pain','South','2017','12','14','1470'),
('Growth','Energy','Purple Pain','South','2018','1','58','6090'),
('Growth','Energy','Purple Pain','South','2018','3','18','1890'),
('Growth','Energy','Purple Pain','South','2018','3','117','12285'),
('Growth','Energy','Purple Pain','South','2018','3','138','14490'),
('Growth','Energy','Purple Pain','South','2018','3','143','15015'),
('Growth','Energy','Purple Pain','South','2018','5','125','13125'),
('Growth','Energy','Purple Pain','South','2018','6','81','8505'),
('Growth','Energy','Purple Pain','South','2018','12','154','16170'),
('Growth','Energy','Purple Pain','South','2019','4','44','4620'),
('Growth','Energy','Purple Pain','South','2019','7','4','420'),
('Growth','Energy','Purple Pain','South','2019','7','23','2415'),
('Growth','Energy','Purple Pain','South','2019','7','37','3885'),
('Growth','Energy','Purple Pain','South','2019','7','41','4305'),
('Growth','Energy','Purple Pain','South','2019','7','77','8085'),
('Growth','Energy','Purple Pain','South','2019','8','12','1260'),
('Growth','Energy','Purple Pain','South','2019','11','79','8295'),
('Growth','Energy','Purple Pain','South','2019','11','86','9030'),
('Growth','Energy','Purple Pain','South','2019','12','38','3990'),
('Growth','Energy','Purple Pain','West','2017','1','86','9030'),
('Growth','Energy','Purple Pain','West','2017','2','93','9765'),
('Growth','Energy','Purple Pain','West','2017','6','3','315'),
('Growth','Energy','Purple Pain','West','2017','8','7','735'),
('Growth','Energy','Purple Pain','West','2017','11','5','525'),
('Growth','Energy','Purple Pain','West','2017','11','65','6825'),
('Growth','Energy','Purple Pain','West','2018','1','159','16695'),
('Growth','Energy','Purple Pain','West','2018','3','102','10710'),
('Growth','Energy','Purple Pain','West','2018','5','129','13545'),
('Growth','Energy','Purple Pain','West','2018','8','94','9870'),
('Growth','Energy','Purple Pain','West','2018','8','168','17640'),
('Growth','Energy','Purple Pain','West','2018','10','98','10290'),
('Growth','Energy','Purple Pain','West','2019','3','60','6300'),
('Growth','Energy','Purple Pain','West','2019','3','66','6930'),
('Growth','Energy','Purple Pain','West','2019','7','24','2520'),
('Growth','Energy','Purple Pain','West','2019','9','17','1785'),
('Growth','Energy','Purple Pain','West','2019','10','6','630'),
('Growth','Energy','Purple Pain','West','2019','10','9','945'),
('Growth','Energy','Purple Pain','West','2019','12','91','8599'),
('Growth','Energy','Red Hot Chili Peppers','Midwest','2017','2','64','14912'),
('Growth','Energy','Red Hot Chili Peppers','Midwest','2017','4','93','21669'),
('Growth','Energy','Red Hot Chili Peppers','Midwest','2017','5','32','7456'),
('Growth','Energy','Red Hot Chili Peppers','Midwest','2017','5','94','21902'),
('Growth','Energy','Red Hot Chili Peppers','Midwest','2018','1','94','21902'),
('Growth','Energy','Red Hot Chili Peppers','Midwest','2018','6','74','17242'),
('Growth','Energy','Red Hot Chili Peppers','Midwest','2018','6','180','41940'),
('Growth','Energy','Red Hot Chili Peppers','Midwest','2018','12','128','29824'),
('Growth','Energy','Red Hot Chili Peppers','Midwest','2019','1','12','2796'),
('Growth','Energy','Red Hot Chili Peppers','Midwest','2019','1','49','11417'),
('Growth','Energy','Red Hot Chili Peppers','Midwest','2019','2','82','19106'),
('Growth','Energy','Red Hot Chili Peppers','Midwest','2019','4','44','10252'),
('Growth','Energy','Red Hot Chili Peppers','Midwest','2019','10','77','17941'),
('Growth','Energy','Red Hot Chili Peppers','Northeast','2017','3','87','20271'),
('Growth','Energy','Red Hot Chili Peppers','Northeast','2017','4','77','17941'),
('Growth','Energy','Red Hot Chili Peppers','Northeast','2017','9','12','2796'),
('Growth','Energy','Red Hot Chili Peppers','Northeast','2018','5','130','30290'),
('Growth','Energy','Red Hot Chili Peppers','Northeast','2018','12','63','14679'),
('Growth','Energy','Red Hot Chili Peppers','Northeast','2019','1','20','4660'),
('Growth','Energy','Red Hot Chili Peppers','Northeast','2019','11','67','15611'),
('Growth','Energy','Red Hot Chili Peppers','Northeast','2019','12','17','3961'),
('Growth','Energy','Red Hot Chili Peppers','South','2017','1','23','5359'),
('Growth','Energy','Red Hot Chili Peppers','South','2017','4','82','19106'),
('Growth','Energy','Red Hot Chili Peppers','South','2017','5','44','10252'),
('Growth','Energy','Red Hot Chili Peppers','South','2017','7','11','2563'),
('Growth','Energy','Red Hot Chili Peppers','South','2018','1','153','35649'),
('Growth','Energy','Red Hot Chili Peppers','South','2018','1','159','37047'),
('Growth','Energy','Red Hot Chili Peppers','South','2018','5','45','10485'),
('Growth','Energy','Red Hot Chili Peppers','South','2018','6','162','37746'),
('Growth','Energy','Red Hot Chili Peppers','South','2018','10','155','36115'),
('Growth','Energy','Red Hot Chili Peppers','South','2019','1','24','5592'),
('Growth','Energy','Red Hot Chili Peppers','South','2019','5','57','13281'),
('Growth','Energy','Red Hot Chili Peppers','South','2019','9','59','13747'),
('Growth','Energy','Red Hot Chili Peppers','South','2019','10','68','15844'),
('Growth','Energy','Red Hot Chili Peppers','West','2017','1','42','9786'),
('Growth','Energy','Red Hot Chili Peppers','West','2017','2','36','8388'),
('Growth','Energy','Red Hot Chili Peppers','West','2017','10','9','2097'),
('Growth','Energy','Red Hot Chili Peppers','West','2017','11','87','20271'),
('Growth','Energy','Red Hot Chili Peppers','West','2017','12','39','9087'),
('Growth','Energy','Red Hot Chili Peppers','West','2018','2','57','13281'),
('Growth','Energy','Red Hot Chili Peppers','West','2018','3','38','8854'),
('Growth','Energy','Red Hot Chili Peppers','West','2018','6','106','24698'),
('Growth','Energy','Red Hot Chili Peppers','West','2018','8','131','30523'),
('Growth','Energy','Red Hot Chili Peppers','West','2018','10','81','18873'),
('Growth','Energy','Red Hot Chili Peppers','West','2018','10','115','26795'),
('Growth','Energy','Red Hot Chili Peppers','West','2018','11','172','40076'),
('Growth','Energy','Red Hot Chili Peppers','West','2019','4','14','3262'),
('Growth','Energy','Red Hot Chili Peppers','West','2019','4','79','18407'),
('Growth','Energy','Red Hot Chili Peppers','West','2019','12','38','8854'),
('Growth','Energy','Red Hot Chili Peppers','West','2019','12','54','12582'),
('Growth','Energy','Red Hot Chili Peppers','West','2019','12','66','15378'),
('Growth','Snack','Crocodile Tears','Midwest','2017','2','42','6006'),
('Growth','Snack','Crocodile Tears','Midwest','2017','3','90','12870'),
('Growth','Snack','Crocodile Tears','Midwest','2017','5','94','13442'),
('Growth','Snack','Crocodile Tears','Midwest','2018','1','101','14443'),
('Growth','Snack','Crocodile Tears','Midwest','2018','2','166','23738'),
('Growth','Snack','Crocodile Tears','Midwest','2018','6','30','4290'),
('Growth','Snack','Crocodile Tears','Midwest','2018','7','59','8437'),
('Growth','Snack','Crocodile Tears','Midwest','2018','8','10','1430'),
('Growth','Snack','Crocodile Tears','Midwest','2018','8','163','23309'),
('Growth','Snack','Crocodile Tears','Midwest','2018','10','69','9867'),
('Growth','Snack','Crocodile Tears','Midwest','2019','4','43','6149'),
('Growth','Snack','Crocodile Tears','Midwest','2019','9','5','715'),
('Growth','Snack','Crocodile Tears','Midwest','2019','12','57','8151'),
('Growth','Snack','Crocodile Tears','Northeast','2017','6','23','3289'),
('Growth','Snack','Crocodile Tears','Northeast','2017','10','18','2574'),
('Growth','Snack','Crocodile Tears','Northeast','2018','1','104','14872'),
('Growth','Snack','Crocodile Tears','Northeast','2018','6','47','6721'),
('Growth','Snack','Crocodile Tears','Northeast','2018','9','126','18018'),
('Growth','Snack','Crocodile Tears','Northeast','2019','7','55','7865'),
('Growth','Snack','Crocodile Tears','Northeast','2019','8','68','9724'),
('Growth','Snack','Crocodile Tears','South','2017','4','83','11869'),
('Growth','Snack','Crocodile Tears','South','2017','5','48','6864'),
('Growth','Snack','Crocodile Tears','South','2017','8','5','715'),
('Growth','Snack','Crocodile Tears','South','2017','11','67','9581'),
('Growth','Snack','Crocodile Tears','South','2017','12','73','10439'),
('Growth','Snack','Crocodile Tears','South','2018','1','138','19734'),
('Growth','Snack','Crocodile Tears','South','2018','1','147','21021'),
('Growth','Snack','Crocodile Tears','South','2018','1','154','22022'),
('Growth','Snack','Crocodile Tears','South','2018','2','104','14872'),
('Growth','Snack','Crocodile Tears','South','2018','3','92','13156'),
('Growth','Snack','Crocodile Tears','South','2018','3','125','17875'),
('Growth','Snack','Crocodile Tears','South','2018','4','102','14586'),
('Growth','Snack','Crocodile Tears','South','2018','5','120','17160'),
('Growth','Snack','Crocodile Tears','South','2018','6','160','22880'),
('Growth','Snack','Crocodile Tears','South','2018','7','129','18447'),
('Growth','Snack','Crocodile Tears','South','2018','8','49','7007'),
('Growth','Snack','Crocodile Tears','South','2018','9','144','20592'),
('Growth','Snack','Crocodile Tears','South','2019','1','7','1001'),
('Growth','Snack','Crocodile Tears','South','2019','2','17','2431'),
('Growth','Snack','Crocodile Tears','South','2019','3','34','4862'),
('Growth','Snack','Crocodile Tears','South','2019','3','71','10153'),
('Growth','Snack','Crocodile Tears','South','2019','4','40','5720'),
('Growth','Snack','Crocodile Tears','South','2019','4','88','12584'),
('Growth','Snack','Crocodile Tears','South','2019','5','16','2288'),
('Growth','Snack','Crocodile Tears','South','2019','5','93','11969'),
('Growth','Snack','Crocodile Tears','South','2019','6','7','1001'),
('Growth','Snack','Crocodile Tears','South','2019','6','76','10868'),
('Growth','Snack','Crocodile Tears','South','2019','7','25','3575'),
('Growth','Snack','Crocodile Tears','South','2019','8','48','6864'),
('Growth','Snack','Crocodile Tears','South','2019','12','23','3289'),
('Growth','Snack','Crocodile Tears','South','2019','12','68','9724'),
('Growth','Snack','Crocodile Tears','West','2017','6','66','9438'),
('Growth','Snack','Crocodile Tears','West','2017','9','69','9867'),
('Growth','Snack','Crocodile Tears','West','2017','10','92','13156'),
('Growth','Snack','Crocodile Tears','West','2017','12','64','9152'),
('Growth','Snack','Crocodile Tears','West','2018','1','116','16588'),
('Growth','Snack','Crocodile Tears','West','2018','12','61','8723'),
('Growth','Snack','Crocodile Tears','West','2019','7','12','1716'),
('Growth','Snack','Crocodile Tears','West','2019','12','7','1001'),
('Mature','Health','Panda Gummies','Midwest','2017','3','3','312'),
('Mature','Health','Panda Gummies','Midwest','2017','4','11','1144'),
('Mature','Health','Panda Gummies','Midwest','2017','12','87','9048'),
('Mature','Health','Panda Gummies','Midwest','2018','9','126','13104'),
('Mature','Health','Panda Gummies','Midwest','2018','12','107','11128'),
('Mature','Health','Panda Gummies','Midwest','2019','3','71','7384'),
('Mature','Health','Panda Gummies','Midwest','2019','6','79','8216'),
('Mature','Health','Panda Gummies','Midwest','2019','8','33','3432'),
('Mature','Health','Panda Gummies','Midwest','2019','11','2','208'),
('Mature','Health','Panda Gummies','Northeast','2017','3','11','1144'),
('Mature','Health','Panda Gummies','Northeast','2017','9','15','1560'),
('Mature','Health','Panda Gummies','Northeast','2017','9','91','9464'),
('Mature','Health','Panda Gummies','Northeast','2018','2','55','5720'),
('Mature','Health','Panda Gummies','Northeast','2018','3','33','3432'),
('Mature','Health','Panda Gummies','Northeast','2018','6','91','9464'),
('Mature','Health','Panda Gummies','Northeast','2018','11','101','10504'),
('Mature','Health','Panda Gummies','Northeast','2018','11','125','13000'),
('Mature','Health','Panda Gummies','Northeast','2019','4','1','104'),
('Mature','Health','Panda Gummies','Northeast','2019','12','38','3952'),
('Mature','Health','Panda Gummies','South','2017','1','14','1456'),
('Mature','Health','Panda Gummies','South','2017','2','98','10192'),
('Mature','Health','Panda Gummies','South','2017','3','2','208'),
('Mature','Health','Panda Gummies','South','2017','3','13','1352'),
('Mature','Health','Panda Gummies','South','2017','3','56','5824'),
('Mature','Health','Panda Gummies','South','2017','7','68','7072'),
('Mature','Health','Panda Gummies','South','2017','12','16','1664'),
('Mature','Health','Panda Gummies','South','2017','12','26','2704'),
('Mature','Health','Panda Gummies','South','2018','4','79','8216'),
('Mature','Health','Panda Gummies','South','2018','4','138','14352'),
('Mature','Health','Panda Gummies','South','2018','6','105','10920'),
('Mature','Health','Panda Gummies','South','2018','9','53','5512'),
('Mature','Health','Panda Gummies','South','2018','9','59','6136'),
('Mature','Health','Panda Gummies','South','2018','9','100','10400'),
('Mature','Health','Panda Gummies','South','2018','9','113','11752'),
('Mature','Health','Panda Gummies','South','2018','10','192','19968'),
('Mature','Health','Panda Gummies','South','2018','12','117','12168'),
('Mature','Health','Panda Gummies','South','2018','12','131','13624'),
('Mature','Health','Panda Gummies','South','2019','5','37','3848'),
('Mature','Health','Panda Gummies','South','2019','6','40','4160'),
('Mature','Health','Panda Gummies','South','2019','6','59','6136'),
('Mature','Health','Panda Gummies','South','2019','8','18','1872'),
('Mature','Health','Panda Gummies','South','2019','11','96','8986'),
('Mature','Health','Panda Gummies','West','2017','3','27','2808'),
('Mature','Health','Panda Gummies','West','2017','7','5','520'),
('Mature','Health','Panda Gummies','West','2017','9','19','1976'),
('Mature','Health','Panda Gummies','West','2017','10','30','3120'),
('Mature','Health','Panda Gummies','West','2017','11','84','8736'),
('Mature','Health','Panda Gummies','West','2018','5','125','13000'),
('Mature','Health','Panda Gummies','West','2018','7','40','4160'),
('Mature','Health','Panda Gummies','West','2018','10','94','9776'),
('Mature','Health','Panda Gummies','West','2018','10','101','10504'),
('Mature','Health','Panda Gummies','West','2018','11','157','16328'),
('Mature','Health','Panda Gummies','West','2019','1','75','7800'),
('Mature','Health','Panda Gummies','West','2019','5','95','8892'),
('Mature','Health','Panda Gummies','West','2019','6','19','1976'),
('Mature','Health','Panda Gummies','West','2019','9','20','2080'),
('Mature','Health','Panda Gummies','West','2019','12','96','8986'),
('Mature','Lunchtime','Green Lightning','Midwest','2018','2','33','5313'),
('Mature','Lunchtime','Green Lightning','Midwest','2018','3','114','18354'),
('Mature','Lunchtime','Green Lightning','Midwest','2018','3','119','19159'),
('Mature','Lunchtime','Green Lightning','Midwest','2018','10','155','24955'),
('Mature','Lunchtime','Green Lightning','Midwest','2019','4','91','13186'),
('Mature','Lunchtime','Green Lightning','Midwest','2019','5','64','10304'),
('Mature','Lunchtime','Green Lightning','Midwest','2019','12','52','8372'),
('Mature','Lunchtime','Green Lightning','Midwest','2019','12','66','10626'),
('Mature','Lunchtime','Green Lightning','Northeast','2018','5','105','16905'),
('Mature','Lunchtime','Green Lightning','Northeast','2018','6','30','4830'),
('Mature','Lunchtime','Green Lightning','Northeast','2018','8','90','14490'),
('Mature','Lunchtime','Green Lightning','Northeast','2018','8','126','20286'),
('Mature','Lunchtime','Green Lightning','Northeast','2018','8','131','21091'),
('Mature','Lunchtime','Green Lightning','Northeast','2018','11','134','21574'),
('Mature','Lunchtime','Green Lightning','Northeast','2019','2','45','7245'),
('Mature','Lunchtime','Green Lightning','Northeast','2019','10','9','1449'),
('Mature','Lunchtime','Green Lightning','South','2018','1','58','9338'),
('Mature','Lunchtime','Green Lightning','South','2018','2','105','16905'),
('Mature','Lunchtime','Green Lightning','South','2018','2','169','27209'),
('Mature','Lunchtime','Green Lightning','South','2018','5','41','6601'),
('Mature','Lunchtime','Green Lightning','South','2018','5','47','7567'),
('Mature','Lunchtime','Green Lightning','South','2018','5','85','13685'),
('Mature','Lunchtime','Green Lightning','South','2018','5','145','23345'),
('Mature','Lunchtime','Green Lightning','South','2018','10','123','19803'),
('Mature','Lunchtime','Green Lightning','South','2018','12','91','14651'),
('Mature','Lunchtime','Green Lightning','South','2019','1','29','4669'),
('Mature','Lunchtime','Green Lightning','South','2019','2','68','10948'),
('Mature','Lunchtime','Green Lightning','South','2019','5','47','7567'),
('Mature','Lunchtime','Green Lightning','South','2019','9','36','5796'),
('Mature','Lunchtime','Green Lightning','South','2019','9','87','14007'),
('Mature','Lunchtime','Green Lightning','West','2018','4','109','17549'),
('Mature','Lunchtime','Green Lightning','West','2018','5','72','11592'),
('Mature','Lunchtime','Green Lightning','West','2018','5','111','17871'),
('Mature','Lunchtime','Green Lightning','West','2018','8','32','5152'),
('Mature','Lunchtime','Green Lightning','West','2018','8','123','19803'),
('Mature','Lunchtime','Green Lightning','West','2019','3','62','9982'),
('Mature','Lunchtime','Green Lightning','West','2019','6','78','12558'),
('Mature','Lunchtime','Green Lightning','West','2019','7','81','13041'),
('Mature','Lunchtime','Green Lightning','West','2019','8','67','10787'),
('Mature','Lunchtime','Green Lightning','West','2019','10','67','10787'),
('Mature','Lunchtime','Green Lightning','West','2019','11','97','14055'),
('Mature','Lunchtime','Green Lightning','West','2019','12','40','6440'),
('Mature','Lunchtime','Green Lightning','West','2019','12','56','9016'),
('Mature','Lunchtime','Orange Creepies','Midwest','2019','1','10','3000'),
('Mature','Lunchtime','Orange Creepies','Midwest','2019','4','13','3900'),
('Mature','Lunchtime','Orange Creepies','Midwest','2019','7','71','21300'),
('Mature','Lunchtime','Orange Creepies','Midwest','2019','10','65','19500'),
('Mature','Lunchtime','Orange Creepies','Northeast','2019','6','58','17400'),
('Mature','Lunchtime','Orange Creepies','Northeast','2019','11','86','25800'),
('Mature','Lunchtime','Orange Creepies','South','2019','3','33','9900'),
('Mature','Lunchtime','Orange Creepies','South','2019','3','81','24300'),
('Mature','Lunchtime','Orange Creepies','South','2019','4','3','900'),
('Mature','Lunchtime','Orange Creepies','South','2019','4','28','8400'),
('Mature','Lunchtime','Orange Creepies','South','2019','6','8','2400'),
('Mature','Lunchtime','Orange Creepies','South','2019','6','26','7800'),
('Mature','Lunchtime','Orange Creepies','South','2019','7','62','18600'),
('Mature','Lunchtime','Orange Creepies','South','2019','10','55','16500'),
('Mature','Lunchtime','Orange Creepies','South','2019','12','88','26400'),
('Mature','Lunchtime','Orange Creepies','South','2019','12','100','27000'),
('Mature','Lunchtime','Orange Creepies','West','2019','1','4','1200'),
('Mature','Lunchtime','Orange Creepies','West','2019','1','47','14100'),
('Mature','Lunchtime','Orange Creepies','West','2019','1','59','17700'),
('Mature','Lunchtime','Orange Creepies','West','2019','2','76','22800'),
('Mature','Lunchtime','Orange Creepies','West','2019','5','76','22800'),
('Mature','Lunchtime','Orange Creepies','West','2019','6','67','20100'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2017','11','64','8576'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2017','12','91','12194'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2018','1','159','21306'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2018','3','136','18224'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2018','3','175','23450'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2018','4','120','16080'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2018','5','52','6968'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2018','6','86','11524'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2018','6','95','12730'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2018','6','143','19162'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2018','9','62','8308'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2018','12','137','18358'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2019','7','61','8174'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2019','11','29','3886'),
('Mature','Lunchtime','Yellow Zonkers','Midwest','2019','11','33','4422'),
('Mature','Lunchtime','Yellow Zonkers','Northeast','2017','2','7','938'),
('Mature','Lunchtime','Yellow Zonkers','Northeast','2017','2','77','10318'),
('Mature','Lunchtime','Yellow Zonkers','Northeast','2017','9','92','12328'),
('Mature','Lunchtime','Yellow Zonkers','Northeast','2018','5','119','15946'),
('Mature','Lunchtime','Yellow Zonkers','Northeast','2018','6','62','8308'),
('Mature','Lunchtime','Yellow Zonkers','Northeast','2018','8','98','13132'),
('Mature','Lunchtime','Yellow Zonkers','Northeast','2018','11','41','5494'),
('Mature','Lunchtime','Yellow Zonkers','Northeast','2018','12','127','17018'),
('Mature','Lunchtime','Yellow Zonkers','Northeast','2019','3','16','2144'),
('Mature','Lunchtime','Yellow Zonkers','Northeast','2019','5','24','3216'),
('Mature','Lunchtime','Yellow Zonkers','Northeast','2019','5','57','7638'),
('Mature','Lunchtime','Yellow Zonkers','Northeast','2019','7','100','12060'),
('Mature','Lunchtime','Yellow Zonkers','South','2017','4','97','12998'),
('Mature','Lunchtime','Yellow Zonkers','South','2017','5','94','12596'),
('Mature','Lunchtime','Yellow Zonkers','South','2017','6','20','2680'),
('Mature','Lunchtime','Yellow Zonkers','South','2017','6','94','12596'),
('Mature','Lunchtime','Yellow Zonkers','South','2017','8','51','6834'),
('Mature','Lunchtime','Yellow Zonkers','South','2017','10','61','8174'),
('Mature','Lunchtime','Yellow Zonkers','South','2017','11','67','8978'),
('Mature','Lunchtime','Yellow Zonkers','South','2018','4','141','18894'),
('Mature','Lunchtime','Yellow Zonkers','South','2018','11','98','13132'),
('Mature','Lunchtime','Yellow Zonkers','South','2019','5','2','268'),
('Mature','Lunchtime','Yellow Zonkers','South','2019','6','25','3350'),
('Mature','Lunchtime','Yellow Zonkers','South','2019','7','29','3886'),
('Mature','Lunchtime','Yellow Zonkers','South','2019','8','62','8308'),
('Mature','Lunchtime','Yellow Zonkers','South','2019','9','43','5762'),
('Mature','Lunchtime','Yellow Zonkers','South','2019','11','37','4958'),
('Mature','Lunchtime','Yellow Zonkers','West','2017','7','53','7102'),
('Mature','Lunchtime','Yellow Zonkers','West','2017','7','59','7906'),
('Mature','Lunchtime','Yellow Zonkers','West','2017','12','29','3886'),
('Mature','Lunchtime','Yellow Zonkers','West','2018','11','146','19564'),
('Mature','Lunchtime','Yellow Zonkers','West','2018','12','138','18492'),
('Mature','Lunchtime','Yellow Zonkers','West','2018','12','172','23048'),
('Mature','Lunchtime','Yellow Zonkers','West','2019','4','24','3216'),
('Mature','Lunchtime','Yellow Zonkers','West','2019','5','20','2680'),
('Mature','Lunchtime','Yellow Zonkers','West','2019','9','18','2412'),
('Mature','Lunchtime','Yellow Zonkers','West','2019','10','35','4690'),
('Mature','Lunchtime','Yellow Zonkers','West','2019','10','37','4958'),
('Mature','Lunchtime','Yellow Zonkers','West','2019','12','49','6566');
select * from test_table
group by BU,BU_Name,Product,Region,Year,Month;
# Remove SUM and the group by month drops values (doesn't include them in the sum)...
#look at row 6 and 7... run again without sum and the 129 disapears and is not added into the sum
Subject
Views
Written By
Posted
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.