LISTING 1: Query That Creates a Data-Mining Model

CREATE MINING MODEL [Age Prediction]
(
	[Customer ID]				LONG 	KEY,	
	[Gender]					TEXT 	DISCRETE,		
	[Age]						DOUBLE	DISCRETIZED() PREDICT,
	[Product Purchases]		TABLE
		(
			[Product Name]		TEXT	KEY,	
			[Quantity]			DOUBLE	NORMAL CONTINUOUS,
			[Product Type]		TEXT 	DISCRETE RELATED TO [Product Name]
		)
)
USING [Decision Trees]