João Carabetta

Precision Test - Filtering and Aggregation

This page tests LLM accuracy when filtering and aggregating structured data.

Test Type: Filter + Aggregate
Last Updated: 2024-01-15

Inventory Database

SKU	Product_Name	Category	Price	Stock	Warehouse	Supplier	Last_Restock
SKU001	Wireless Keyboard	Electronics	49.99	234	WH-North	TechSupply Co	2024-01-10
SKU002	USB-C Cable 2m	Electronics	12.99	1567	WH-South	CableMaster	2024-01-12
SKU003	Office Chair Deluxe	Furniture	299.99	45	WH-North	FurniPro Ltd	2024-01-05
SKU004	Standing Desk	Furniture	449.99	28	WH-East	FurniPro Ltd	2024-01-08
SKU005	Monitor 27” 4K	Electronics	349.99	89	WH-West	TechSupply Co	2024-01-11
SKU006	Desk Lamp LED	Furniture	34.99	456	WH-South	LightingPlus	2024-01-09
SKU007	Webcam HD 1080p	Electronics	79.99	178	WH-North	TechSupply Co	2024-01-14
SKU008	Notebook Pack (10)	Office	24.99	892	WH-East	PaperWorld	2024-01-07
SKU009	Pen Set Premium	Office	15.99	1234	WH-South	PaperWorld	2024-01-06
SKU010	Wireless Mouse	Electronics	29.99	567	WH-West	TechSupply Co	2024-01-13
SKU011	Filing Cabinet	Furniture	189.99	67	WH-North	FurniPro Ltd	2024-01-04
SKU012	Whiteboard 120cm	Office	89.99	123	WH-East	BoardSupply	2024-01-10
SKU013	HDMI Cable 3m	Electronics	18.99	2341	WH-South	CableMaster	2024-01-15
SKU014	Ergonomic Keyboard	Electronics	129.99	156	WH-West	TechSupply Co	2024-01-12
SKU015	Bookshelf 5-tier	Furniture	159.99	34	WH-East	FurniPro Ltd	2024-01-03
SKU016	Stapler Heavy Duty	Office	19.99	678	WH-North	OfficeBasics	2024-01-11
SKU017	Monitor Stand	Furniture	44.99	289	WH-South	FurniPro Ltd	2024-01-09
SKU018	USB Hub 7-port	Electronics	39.99	445	WH-West	TechSupply Co	2024-01-14
SKU019	Desk Organizer	Office	29.99	567	WH-East	OfficeBasics	2024-01-08
SKU020	Power Strip 6-outlet	Electronics	24.99	1123	WH-North	PowerPlus	2024-01-13

Pre-Calculated Filter Results

Category Filters

• Electronics products count: 9
• Furniture products count: 6
• Office products count: 5
• Electronics total stock: 6700
• Furniture total stock: 919
• Office total stock: 3494

Price Filters

• Products with Price > 100: 4 (Office Chair Deluxe, Standing Desk, Monitor 27” 4K, Ergonomic Keyboard)
• Products with Price < 30: 7
• Products with Price between 30 and 100: 9
• Average price of Electronics: 81.88
• Average price of Furniture: 196.65
• Average price of Office: 36.19

Stock Filters

• Products with Stock > 500: 7
• Products with Stock < 100: 5
• Total inventory value (Price × Stock for all): 308,891.01
• Electronics inventory value: 167,674.55
• Low stock items (Stock < 50): 3 (Office Chair Deluxe, Standing Desk, Bookshelf 5-tier)

Warehouse Filters

• Products in WH-North: 5
• Products in WH-South: 5
• Products in WH-East: 5
• Products in WH-West: 5
• Total stock in WH-North: 2757
• Total stock in WH-South: 4645

Supplier Filters

• Products from TechSupply Co: 6
• Products from FurniPro Ltd: 5
• Total value from TechSupply Co: 108,424.24
• Suppliers with only 1 product: 4 (LightingPlus, BoardSupply, PowerPlus)

Combined Filters

• Electronics in WH-North: 2 (Wireless Keyboard, Webcam HD 1080p)
• Furniture with Price > 100: 4
• Office products restocked after 2024-01-08: 3
• Electronics from TechSupply Co with Stock > 200: 2 (Wireless Mouse, USB Hub 7-port)

Date Filters

• Products restocked on or after 2024-01-12: 6
• Products restocked before 2024-01-07: 3
• Most recently restocked product: HDMI Cable 3m (2024-01-15)
• Oldest restocked product: Bookshelf 5-tier (2024-01-03)