Skip to content

QUESTIONS_AND_RESULTS.md

Latest commit

 

History

History
613 lines (524 loc) · 24.7 KB

QUESTIONS_AND_RESULTS.md

File metadata and controls

613 lines (524 loc) · 24.7 KB

Wheat Flour Data Analysis

pic

The report presents an analysis of various values derived from wheat flour production

🚩 Sales revenue
🚩 Product SKUs (Stock Keeping Units)
🚩 Cost
🚩 Selling price
🚩 Profit
🚩 Customer company names 

Explanation:

Sales revenue          : This refers to the total income generated from selling the wheat flour products.  

Product SKUs           : SKUs (Stock Keeping Units) are unique identifiers for each distinct product or item for sale.  

Cost                   : This includes all expenses incurred in the production of wheat flour.  

Selling price          : The price at which the wheat flour products are sold to customers.  

Profit       	       : The financial gain calculated as the difference between the selling price and the cost.  

Customer company names : The names of the companies that purchase the wheat flour products.

🎏 Q.1 The quantity of noodle flour sold in 2023 🎏

SELECT 
	Group_Product,
	strftime('%Y-%m',Posting_Date) AS MonthID,
	SUM(Quantity_Total) AS SUM_Quantity
From Sale_Order_Batch 
WHERE Group_Product = "NOODLE FLOUR"
AND MonthID like '2023%'
Group by MonthID ;

🔻Results:

Click to expand results!
Materialdescription MonthID SUM_Quantity
NOODLE FLOUR 2023-01 296910
NOODLE FLOUR 2023-02 297832.5
NOODLE FLOUR 2023-03 484042.4
NOODLE FLOUR 2023-04 388777.5
NOODLE FLOUR 2023-05 621855
NOODLE FLOUR 2023-06 479295
NOODLE FLOUR 2023-07 526815
NOODLE FLOUR 2023-08 576967.5
NOODLE FLOUR 2023-09 578317.5
NOODLE FLOUR 2023-10 541890
NOODLE FLOUR 2023-11 552645
NOODLE FLOUR 2023-12 417735

To find the total quantity of noodle flour sold in 2023, we can sum up the quantities listed for each month. Here's the calculation:

296,910 + 297,832.5 + 484,042.4 + 388,777.5 + 621,855 + 479,295 + 526,815 + 576,967.5 + 578,317.5 + 541,890 + 552,645 + 417,735

Let's calculate the sum: 

5,762,082.4

So, the total quantity of noodle flour sold in 2023 is 5,762,082.4

🎏 Q.2 Top 10 customers with the most Products purchases in 2022 🎏

SELECT 
	SL.Company_name,
	strftime('%Y',SB.Posting_Date) AS YEAR,
	SUM(SB.Quantity_Total) AS SUM_Quantity
From Sale_Order_Batch AS SB , Sale_Order_List AS SL
WHERE SB.Customer = SL.Sale_Order
AND YEAR like '%2022%'
GROUP BY SL.Company_name
ORDER BY SUM_Quantity DESC
Limit 10;

🔻Results:

Click to expand results!
Company_name YEAR SUM_Quantity
DY_COMPANY 2022 2636586
CH_COMPANY 2022 1136317.5
IR_COMPANY 2022 1105820
BI_COMPANY 2022 879525
BL_COMPANY 2022 671745
HQ_COMPANY 2022 618750
BT_COMPANY 2022 592042.5
IG_COMPANY 2022 495630
BH_COMPANY 2022 449100
CA_COMPANY 2022 431597.52 
Based on the Result , here are the top 10 customers with the most product purchases in 2022, ranked by Quantity

🎏 Q.3 Cost price, selling price, and profit in 2023 🎏

SELECT 
	RM.MonthID,
	Round(SUM(RM.Quantity),2) AS Quantity_RM ,
	Round(SUM(FG.Quantity),2) AS Quantity_FG,
	Round(SUM(RM.Quantity - FG.Quantity),2) AS Diff,
	Round(SUM(RM.Cost),2)  AS RM_Cost,
	Round(SUM(FG.Cost),2)  AS FG_Cost,
	Round(SUM(FG.Cost - RM.Cost),2) AS Profit
FROM 
   (SELECT 
   substr(Process_Order, 9, 4) AS PO,
   strftime('%Y-%m',Posting_Date) AS MonthID,
   CASE
		WHEN Movement_type = '261' or Movement_type = '262' THEN 'RM'
		ELSE 'FG'
	END AS Type,
	ROUND(SUM(Quantity_Total),2) AS Quantity,
	ROUND(SUM(Cost),2) AS Cost
	FROM Transaction_Table
	WHERE Type = 'RM'
	GROUP by PO) AS RM ,
   (SELECT 
   substr(Process_Order, 9, 4) AS PO,
   strftime('%Y-%m',Posting_Date) AS MonthID,
   CASE
		WHEN Movement_type = '261' or Movement_type = '262' THEN 'RM'
		ELSE 'FG'
	END AS Type,
	SUM(Quantity_Total)*-1 AS Quantity,
	SUM(Cost)*-1 AS Cost
	FROM Transaction_Table
	WHERE Type = 'FG'
	GROUP by PO) AS FG
WHERE RM.PO = FG.PO
AND RM.MonthID Like '%2023%'
GROUP by RM.MonthID;

🔻Results:

Click to expand results!
MonthID Quantity_RM Quantity_FG Diff RM_Cost FG_Cost Profit
2023-01 7657102.25 7461143.5 195958.75 134630890.5 137046991.5 2416100.97
2023-02 5858748.2 5707113.5 151634.7 103205010.6 107361976.3 4156965.72
2023-03 8593895.86 8357339.97 236555.89 151529618.9 157590265.1 6060646.21
2023-04 8572267.08 8447285.41 124981.67 147746928.7 159358774.8 11611846.1
2023-05 10319308.94 10107754 211554.94 176783192.2 190244678.5 13461486.27
2023-06 8955396.48 8779719.44 175677.04 151387816.6 165297985.5 13910168.82
2023-07 10027767.47 9834565 193202.47 162673646.3 182758128.2 20084481.87
2023-08 11017791.02 10878489.5 139301.52 173873267.2 200714362.3 26841095.17
2023-09 10675417.4 10495629.89 179787.51 165709899.8 191869422.6 26159522.84
2023-10 9764250.89 9690245.49 74005.4 151157013.6 175932338.6 24775325.03
2023-11 10499137.76 10449469.52 49668.24 157283391.7 165424949.9 8141558.17
2023-12 8477412.02 8472340.63 5071.39 125722161.1 132111089.6 6388928.51 
Summary of Cost Price, Selling Price, and Profit for 2023
Total Raw Material Cost   :  1,801,702,837.20
Total Finished Goods Cost : 1,965,710,962.90
Total Profit		  : 164,008,125.68

🎏 Q.4 Traceability inspection of product lot 230621 for food products 🎏

SELECT
 PKGR.PO AS PO_Packing,
 PKGR.MonthID,
 PKGR.Lot AS Lot_Packing,
 PKGR.Product_NAME,
 (CASE
		WHEN Product_NAME Like 'VITAL%' THEN 'VITAL'
		ELSE 'FOOD'
	END) AS Type,
 PKGR.Quantity_Product*-1 AS Quantity_Product,
 PDGR.PO AS PO_PD,
 PKGI.Material_Name AS WIP_NAME,
 PKGI.Batch AS Batch_WIP,
 PKGI.Quantity_Production AS Quantity_WIP,
 PDGI.Material_Name AS RM_Name,
 PDGI.Lot AS LOT_RM,
 PDGI.Quantity_Production AS Quantity_RM
FROM
	(SELECT 
		substr(TS.Process_Order, 9, 4) AS PO,
		strftime('%Y-%m',TS.Posting_Date) AS MonthID,
		substr(TS.Batch, 1, 6) AS Lot,
		ML.Material_Name AS Product_NAME,
			(CASE
			   WHEN Movement_type = '261' or Movement_type = '262' THEN 'GI'
			   ELSE 'GR'
			 END) AS Type_Process,
		OH.Order_Type,
		SUM(TS.Quantity_Total) AS Quantity_Product
		FROM Transaction_Table AS TS , Material_list AS ML , Order_Hearder AS OH
		WHERE TS.Material =  ML.Material_Number
		AND TS.Process_Order = OH.Process_Order
		AND OH.Order_Type IN ('102','199')
		AND Type_Process = 'GR'
		AND ML.Material_Name not like '%RE%'
		AND TS.Batch not like '%0'
		GROUP by TS.Process_Order,Product_NAME,Lot
		HAVING 
			SUM(TS.Quantity_Total) != 0 ) 	AS PKGR ,
	 (SELECT 
		substr(TS.Process_Order, 9, 4) AS PO,
		strftime('%Y-%m',TS.Posting_Date) AS MonthID,
		ML.Material_Name,
		TS.Batch As Batch,
			(CASE
			  WHEN Movement_type = '261' or Movement_type = '262' THEN 'GI'
			  ELSE 'GR'
			END) AS Type_Process,
		OH.Order_Type,
		SUM(TS.Quantity_Total) AS Quantity_Production
		FROM Transaction_Table AS TS , Material_list AS ML , Order_Hearder AS OH
		WHERE TS.Material =  ML.Material_Number
		AND TS.Process_Order = OH.Process_Order
		AND OH.Order_Type IN ('102','199')
		AND Type_Process = 'GI'
		AND ML.Material_name like 'PL%'
		GROUP by TS.Process_Order,ML.Material_Name,TS.Batch
		HAVING 
			SUM(TS.Quantity_Total) != 0) 	AS PKGI ,
	 (SELECT 
		substr(TS.Process_Order, 9, 4) AS PO,
		strftime('%Y-%m',TS.Posting_Date) AS MonthID,
		ML.Material_Name,
		TS.Batch,
			(CASE
			  WHEN Movement_type = '261' or Movement_type = '262' THEN 'GI'
			  ELSE 'GR'
			END) AS Type_Process,
		OH.Order_Type,
		SUM(TS.Quantity_Total) AS Quantity_Production
		FROM Transaction_Table AS TS , Material_list AS ML , Order_Hearder AS OH
		WHERE TS.Material =  ML.Material_Number
		AND TS.Process_Order = OH.Process_Order
		AND OH.Order_Type = '101' 
		AND Type_Process = 'GR'
		AND ML.Material_name like 'PL%'
		GROUP by TS.Process_Order,ML.Material_Name,TS.Batch
		HAVING 
			SUM(TS.Quantity_Total) != 0 ) AS PDGR ,
	 (SELECT 
		substr(TS.Process_Order, 9, 4) AS PO,
		strftime('%Y-%m',TS.Posting_Date) AS MonthID,
		substr(TS.Batch, 1, 6) AS Lot,
		ML.Material_Name,
			(CASE
			  WHEN Movement_type = '261' or Movement_type = '262' THEN 'GI'
			  ELSE 'GR'
			END) AS Type_Process,
		OH.Order_Type,
		SUM(TS.Quantity_Total) AS Quantity_Production
		FROM Transaction_Table AS TS , Material_list AS ML , Order_Hearder AS OH
		WHERE TS.Material =  ML.Material_Number
		AND TS.Process_Order = OH.Process_Order
		AND OH.Order_Type = '101' 
		AND Type_Process = 'GI'
		AND ML.Material_Name Like '%RM%'
		GROUP by TS.Process_Order,ML.Material_Name,Lot
		HAVING 
			SUM(TS.Quantity_Total) != 0) AS PDGI 
WHERE PKGR.PO = PKGI.PO
AND PKGI.Batch = PDGR.Batch
AND PDGR.PO = PDGI.PO
AND Lot_Packing Like '230621'
AND Type Like 'Food'
GROUP by PKGR.PO,PKGR.Lot,PDGR.PO
ORDER by PKGR.PO,PDGR.PO,PKGI.Batch;

🔻Results:

Click to expand results!
PO_Packing MonthID Lot_Packing Product_NAME Type Quantity_Product PO_PD WIP_NAME Batch_WIP Quantity_WIP RM_Name LOT_RM Quantity_RM
3477 2023-06 230621 NOODLE FLOUR 10 FOOD 6907.5 3550 PL-11 230612002A 1791 RM-18 230106 12659
3477 2023-06 230621 NOODLE FLOUR 10 FOOD 6907.5 3557 PL-22 230614001A 713.5 RM-6 230222 78391
3477 2023-06 230621 NOODLE FLOUR 10 FOOD 6907.5 3594 PL-25 230620002A 4679.5 RM-8 230316 19575
3571 2023-06 230621 BISCUITS FLOUR 6 FOOD 23062.5 3550 PL-11 230612002A 21731.5 RM-18 230106 12659
3571 2023-06 230621 BISCUITS FLOUR 6 FOOD 23062.5 3556 PL-1 230613003A 199 RM-16 220928 40612
3606 2023-06 230621 NOODLE FLOUR 6 FOOD 11250 3569 PL-25 230615001A 11490.5 RM-8 230313 785
3607 2023-06 230621 NOODLE FLOUR 9 FOOD 11587.5 3569 PL-25 230615001A 9181 RM-8 230313 785
3607 2023-06 230621 NOODLE FLOUR 9 FOOD 11587.5 3594 PL-25 230620002A 2655.5 RM-8 230316 19575
3610 2023-06 230621 ALL PURPOSE FLOUR 31 FOOD 29340 3542 PL-18 230610001A 16439 RM-22 230609 56636
3610 2023-06 230621 ALL PURPOSE FLOUR 31 FOOD 29340 3557 PL-22 230614001A 3447 RM-6 230222 78391
3610 2023-06 230621 ALL PURPOSE FLOUR 31 FOOD 29340 3592 PL-22 230619001A 9973.5 RM-6 230222 88608
3614 2023-06 230621 BISCUITS FLOUR 12 FOOD 4700 3471 PL-24 230530003A 305 RM-7 221028 78521
3614 2023-06 230621 BISCUITS FLOUR 12 FOOD 4700 3550 PL-11 230612002A 1734.5 RM-18 230106 12659
3614 2023-06 230621 BISCUITS FLOUR 12 FOOD 4700 3583 PL-11 230617002A 1196.5 RM-18 230112 38895.12
3614 2023-06 230621 BISCUITS FLOUR 12 FOOD 4700 3592 PL-22 230619001A 739 RM-6 230222 88608
3614 2023-06 230621 BISCUITS FLOUR 12 FOOD 4700 3595 PL-13 230620003A 293.5 RM-8 230529 80540
3614 2023-06 230621 BISCUITS FLOUR 12 FOOD 4700 3602 PL-24 230621001A 658.5 RM-7 221028 89309 
	
Product Details: Identify the products associated with lot 230621.

NOODLE FLOUR 10
BISCUITS FLOUR 6
NOODLE FLOUR 6
NOODLE FLOUR 9
ALL PURPOSE FLOUR 31
BISCUITS FLOUR 12


Quantity Produced: Sum up the quantities of the final products.

NOODLE FLOUR 10	     : 6907.5 
BISCUITS FLOUR 6     : 23062.5
NOODLE FLOUR 6	     : 11250 
NOODLE FLOUR 9	     : 11587.5 
ALL PURPOSE FLOUR 31 : 29340 
BISCUITS FLOUR 12    : 4700

🎏 Q.5 How many SKUs of bread are there? 🎏

SELECT 
	Material_Name
FROM Material_list
WHERE Material_Name Like '%BREAD FlOUR%'

🔻Results:

Click to expand results!
Material_Name
BREAD FLOUR 1
BREAD FLOUR 2
BREAD FLOUR 3
BREAD FLOUR 4
BREAD FLOUR 5
BREAD FLOUR 6
BREAD FLOUR 7
BREAD FLOUR 8
BREAD FLOUR 9
BREAD FLOUR 10
BREAD FLOUR 11
BREAD FLOUR 12
BREAD FLOUR 13
BREAD FLOUR 14
BREAD FLOUR 15
BREAD FLOUR 16
BREAD FLOUR 17
BREAD FLOUR 18
BREAD FLOUR 19
BREAD FLOUR 20
BREAD FLOUR 21
BREAD FLOUR 22 
 There are 22 SKUs of bread.

🎏 Q.6 Monthly sales of each type of flour in 2022 🎏

SELECT 
 (CASE
		WHEN ML.Material_Name Like '%BREAD%' THEN 'BREAD FLOUR'
		WHEN ML.Material_Name Like '%ALL PURPOSE%' THEN 'ALL PURPOSE FLOUR'
		WHEN ML.Material_Name Like '%NOODLE%' THEN 'NOODLE FLOUR'
		WHEN ML.Material_Name Like '%INSTANT%' THEN 'INSTANT NOODLE FLOUR'
		WHEN ML.Material_Name Like '%BISCUITS%' THEN 'BISCUITS FLOUR' 
		WHEN ML.Material_Name Like '%PIZZA%' THEN 'PIZZA FLOUR'
		WHEN ML.Material_Name Like '%SALAPAO%' THEN 'SALAPAO FLOUR'
		WHEN ML.Material_Name Like '%CAKE%' THEN 'CAKE FLOUR'
		ELSE 'VITAL FLOUR'
	END) AS Type_FLOUR ,
	SUM(SB.Quantity_Total) ,
 (CASE
		WHEN Material_Name Like 'VITAL%' THEN 'VITAL'
		ELSE 'FOOD'
	END) AS Type_Product ,
	strftime('%Y-%m',SB.Posting_Date) AS MonthID
	FROM Material_list AS ML ,Sale_Order_Batch AS SB
	WHERE ML.Material_Number = SB.Material
	AND ML.Material_Name like '%FLOUR%'
	AND ML.Material_Name NOT like '%F3%'
	AND ML.Material_Name NOT like '%MIX%' 
	AND MonthID Like '2022%'
	GROUP by Type_FLOUR , MonthID ;

🔻Results:

Click to expand results!
Type_FLOUR SUM(SB.Quantity_Total) Type_Product MonthID
ALL PURPOSE FLOUR 237700 FOOD 2022-01
ALL PURPOSE FLOUR 178707.5 FOOD 2022-02
ALL PURPOSE FLOUR 293785 FOOD 2022-03
ALL PURPOSE FLOUR 114362.5 FOOD 2022-04
ALL PURPOSE FLOUR 206930 FOOD 2022-05
ALL PURPOSE FLOUR 326052.5 FOOD 2022-06
ALL PURPOSE FLOUR 321457.5 FOOD 2022-07
ALL PURPOSE FLOUR 390857.5 FOOD 2022-08
ALL PURPOSE FLOUR 419512.5 FOOD 2022-09
ALL PURPOSE FLOUR 544602.5 FOOD 2022-10
ALL PURPOSE FLOUR 565427.5 FOOD 2022-11
ALL PURPOSE FLOUR 325702.5 FOOD 2022-12
BISCUITS FLOUR 39847.5 FOOD 2022-01
BISCUITS FLOUR 96437.5 FOOD 2022-02
BISCUITS FLOUR 203978.5 FOOD 2022-03
BISCUITS FLOUR 170222.5 FOOD 2022-04
BISCUITS FLOUR 365810 FOOD 2022-05
BISCUITS FLOUR 451045 FOOD 2022-06
BISCUITS FLOUR 776365 FOOD 2022-07
BISCUITS FLOUR 803297.5 FOOD 2022-08
BISCUITS FLOUR 948860 FOOD 2022-09
BISCUITS FLOUR 734767.5 FOOD 2022-10
BISCUITS FLOUR 785320 FOOD 2022-11
BISCUITS FLOUR 545992.5 FOOD 2022-12
BREAD FLOUR 224930.01 FOOD 2022-01
BREAD FLOUR 359352.5 FOOD 2022-02
BREAD FLOUR 240807.5 FOOD 2022-03
BREAD FLOUR 112792.51 FOOD 2022-04
BREAD FLOUR 374667.5 FOOD 2022-05
BREAD FLOUR 460770 FOOD 2022-06
BREAD FLOUR 315285 FOOD 2022-07
BREAD FLOUR 314597.5 FOOD 2022-08
BREAD FLOUR 385497.5 FOOD 2022-09
BREAD FLOUR 380160 FOOD 2022-10
BREAD FLOUR 507485 FOOD 2022-11
BREAD FLOUR 265572.5 FOOD 2022-12
NOODLE FLOUR 617400 FOOD 2022-01
NOODLE FLOUR 490275 FOOD 2022-02
NOODLE FLOUR 597060 FOOD 2022-03
NOODLE FLOUR 214560 FOOD 2022-04
NOODLE FLOUR 275400 FOOD 2022-05
NOODLE FLOUR 382005 FOOD 2022-06
NOODLE FLOUR 371137.5 FOOD 2022-07
NOODLE FLOUR 290992.5 FOOD 2022-08
NOODLE FLOUR 420075 FOOD 2022-09
NOODLE FLOUR 481500 FOOD 2022-10
NOODLE FLOUR 580717.5 FOOD 2022-11
NOODLE FLOUR 411120 FOOD 2022-12
PIZZA FLOUR 29925 FOOD 2022-01
PIZZA FLOUR 20475 FOOD 2022-02
PIZZA FLOUR 15750 FOOD 2022-03
PIZZA FLOUR 17325 FOOD 2022-04
PIZZA FLOUR 19575 FOOD 2022-05
PIZZA FLOUR 23625 FOOD 2022-06
PIZZA FLOUR 34650 FOOD 2022-07
PIZZA FLOUR 34875 FOOD 2022-08
PIZZA FLOUR 29925 FOOD 2022-09
PIZZA FLOUR 23625 FOOD 2022-10
PIZZA FLOUR 28800 FOOD 2022-11
PIZZA FLOUR 21600 FOOD 2022-12
VITAL FLOUR 30000 VITAL 2022-01
VITAL FLOUR 3000 VITAL 2022-02
VITAL FLOUR 1500 VITAL 2022-04
VITAL FLOUR 192000 VITAL 2022-05
VITAL FLOUR 91000 VITAL 2022-10
VITAL FLOUR 155675 VITAL 2022-11
VITAL FLOUR 99000 VITAL 2022-12 
	 
The provided table summarizes the monthly sales quantities for each type of flour in 2022. Here's the breakdown for each month and each type of flour:

All Purpose Flour Sales:		Biscuits Flour Sales:			Bread Flour Sales:
January	  : 237,700			January	  : 39,847.5			January    : 224,930.01
February  : 178,707.5			February  : 96,437.5			February   : 359,352.5
March     : 293,785			March	  : 203,978.5			March      : 240,807.5	
April     : 114,362.5			April	  : 170,222.5			April	   : 112,792.51
May	  : 206,930			May	  : 365,810			May	   : 374,667.5
June      : 326,052.5			June	  : 451,045			June	   : 460,770
July      : 321,457.5			July	  : 776,365			July	   : 315,285
August    : 390,857.5			August	  : 803,297.5			August	   : 314,597.5
September : 419,512.5			September : 948,860			September  : 385,497.5
October   : 544,602.5			October   : 734,767.5			October	   : 380,160
November  : 565,427.5			November  : 785,320			November   : 507,485
December  : 325,702.5			December  : 545,992.5			December   : 265,572.5
	 


Noodle Flour Sales:			Pizza Flour Sales:	  		Vital Flour Sales:
January   : 617,400			January   : 29,925			January	    : 30,000
February  : 490,275			February  : 20,475			February    : 3,000
March	  : 597,060			March     : 15,750			March	    : 0
April     : 214,560			April     : 17,325			April	    : 1,500		
May	  : 275,400			May       : 19,575			May	    : 192,000
June      : 382,005			June	  : 23,625			June	    : 0
July      : 371,137.5			July      : 34,650			July	    : 0
August    : 290,992.5			August    : 34,875			August	    : 0
September : 420,075			September : 29,925			September   : 0
October   : 481,500			October   : 23,625			October     : 91,000
November  : 580,717.5			November  : 28,800			November    : 155,675
December  : 411,120			December  : 21,600			December    : 99,000

🎏 Q.7 What type of flour has sold best between 2021 to 2023 🎏

SELECT 
 (CASE
		WHEN ML.Material_Name Like '%BREAD%' THEN 'BREAD FLOUR'
		WHEN ML.Material_Name Like '%ALL PURPOSE%' THEN 'ALL PURPOSE FLOUR'
		WHEN ML.Material_Name Like '%NOODLE%' THEN 'NOODLE FLOUR'
		WHEN ML.Material_Name Like '%INSTANT%' THEN 'INSTANT NOODLE FLOUR'
		WHEN ML.Material_Name Like '%BISCUITS%' THEN 'BISCUITS FLOUR' 
		WHEN ML.Material_Name Like '%PIZZA%' THEN 'PIZZA FLOUR'
		WHEN ML.Material_Name Like '%SALAPAO%' THEN 'SALAPAO FLOUR'
		WHEN ML.Material_Name Like '%CAKE%' THEN 'CAKE FLOUR'
		ELSE 'VITAL FLOUR'
	END) AS Type_FLOUR ,
	SUM(SB.Quantity_Total) ,
 (CASE
		WHEN Material_Name Like 'VITAL%' THEN 'VITAL'
		ELSE 'FOOD'
	END) AS Type_Product ,
	strftime('%Y',SB.Posting_Date) AS MonthID
	FROM Material_list AS ML ,Sale_Order_Batch AS SB
	WHERE ML.Material_Number = SB.Material
	AND ML.Material_Name like '%FLOUR%'
	AND ML.Material_Name NOT like '%F3%'
	AND ML.Material_Name NOT like '%MIX%' 
	AND MonthID Not like '2024'
	GROUP by Type_FLOUR , MonthID ;

🔻Results:

Click to expand results!
Type_FLOUR SUM(SB.Quantity_Total) Type_Product MonthID
ALL PURPOSE FLOUR 1928637.43 FOOD 2021
ALL PURPOSE FLOUR 3925097.5 FOOD 2022
ALL PURPOSE FLOUR 3695120.14 FOOD 2023
BISCUITS FLOUR 580895 FOOD 2021
BISCUITS FLOUR 5921943.5 FOOD 2022
BISCUITS FLOUR 5318690 FOOD 2023
BREAD FLOUR 2133713.4 FOOD 2021
BREAD FLOUR 3941917.52 FOOD 2022
BREAD FLOUR 5043755 FOOD 2023
NOODLE FLOUR 3143073.49 FOOD 2021
NOODLE FLOUR 5132242.5 FOOD 2022
NOODLE FLOUR 5763082.4 FOOD 2023
PIZZA FLOUR 299452.5 FOOD 2021
PIZZA FLOUR 300150 FOOD 2022
PIZZA FLOUR 305595 FOOD 2023
VITAL FLOUR 1752668.46 VITAL 2021
VITAL FLOUR 572175 VITAL 2022
VITAL FLOUR 3250000 VITAL 2023 
	 
2021: Best selling flour was NOODLE FLOUR.
2022: Best selling flour was BISCUITS FLOUR.
2023: Best selling flour was NOODLE FLOUR.