SELECT 
DISTINCT date,
id,
CASE WHEN app_info like '%purchase%' THEN 1 ELSE 0 END as purchase_ind,
CASE WHEN app_info like '