leastlikelycar.dmx

来自「< SQL Server2005程序设计>」· DMX 代码 · 共 15 行

--250 customers who are least likely to have a car
SELECT TOP 250 t.FirstName, t.LastName, t.Phone, 
	   PredictProbability([Is Car Owner],'N') AS ProbNotCarOwner
FROM	CarOwner_DT 
PREDICTION JOIN 
	OPENQUERY([Adventure Works DW],
			  'SELECT c.FirstName,c.LastName,tc.* 
			   FROM vCustomerProfitability tc INNER JOIN dimCustomer c 
               ON tc.CustomerKey = c.CustomerKey') 
    AS t
    ON t.Gender = CarOwner_DT.Gender AND
	   t.IncomeGroup = CarOwner_dt.[Income Group] AND
	   t.MaritalStatus = CarOwner_dt.[Marital Status] AND
	   t.Region = CarOwner_dt.Region
ORDER BY PredictProbability([Is Car Owner],'N') DESC