select day, user_name, userid,
sum_exect_jtf+sum_exect_oaf+sum_exect_form sum_exect,
sum_thinkt_jtf+sum_thinkt_oaf+sum_thinkt_form sum_exect,
cnt_pages_all cnt_pages,
ucnt_ses, ucnt_pages, ucnt_apps, ucnt_resps, ucnt_langs, startt, endt, cnt_fail
from jtf_pf_user_summ
SELECT DAY
, USER_NAME
, USERID
,
SUM_EXECT_JTF+SUM_EXECT_OAF+SUM_EXECT_FORM SUM_EXECT
,
SUM_THINKT_JTF+SUM_THINKT_OAF+SUM_THINKT_FORM SUM_EXECT
,
CNT_PAGES_ALL CNT_PAGES
,
UCNT_SES
, UCNT_PAGES
, UCNT_APPS
, UCNT_RESPS
, UCNT_LANGS
, STARTT
, ENDT
, CNT_FAIL
FROM JTF_PF_USER_SUMM
|
|
|