USE AdventureWorksDW
GO

SELECT ID,FirstName,LastName,EmailAddress,Age,MaritalStatus,Gender,TotalChildren,
NumberChildrenAtHome,Education,Occupation,YearlyIncome,HouseOwnerFlag,NumberCarsOwned,
MonthsAsCustomer,
CASE 	WHEN [BikesAmount]>0 THEN 'Bikes'
		WHEN [AccessoriesAmount]>0 THEN 'Accessories' 
		WHEN [ClothingAmount]>0 THEN 'Clothing'
		ELSE 'Nothing' END as WillBuy
FROM [CustomersHistory];
GO

