question

Warning: I am a beginner. I want to group event_timestamp so I can see distinct actions rolled up on a daily basis. How do I do this? This is the query I wrote, but it's not really pulling back what I want. SELECT v.user_profile_sk, COUNT (distinct v.event_timestamp), v.init_source, v.previous_event_id, v.current_event_id, v.source, a.previous_event_id, a.current_event_id FROM prod_dwh_event as v LEFT OUTER JOIN prod_dwh_event_action as a on v.user_profile_sk=a.user_profile_sk WHERE v.event_timestamp >= '2015-06-22' AND init_source in ('nsloe','bsremail','promo40','digest_promo','iosemail','androidemail','sitterhelpdoc') GROUP BY v.user_profile_sk, v.init_source, v.previous_event_id, v.current_event_id, v.source, a.previous_event_id, a.current_event_id ORDER BY v.event_timestamp ASC