Advertisement
TDCustmerSupportJP

Untitled

Jul 3rd, 2017
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.23 KB | None | 0 0
  1. SELECT
  2.    TD_TIME_FORMAT(time,  'yyyy-MM-dd', 'JST') as d,
  3.    COUNT(DISTINCT user_id) as uu,
  4.    SUM( impression ) / approx_distinct( user_id )  as imp_uu,
  5.    SUM( click ) / approx_distinct( user_id ) as click_uu
  6. FROM access_log
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement