Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- TD_TIME_FORMAT(time, 'yyyy-MM-dd', 'JST') as d,
- COUNT(DISTINCT user_id) as uu,
- SUM( impression ) / COUNT(DISTINCT user_id ) as imp_uu,
- SUM( click ) / COUNT(DISTINCT user_id ) as click_uu
- FROM access_log
Add Comment
Please, Sign In to add comment