获得本周截止到当前为止，所有用户的签到次数

select t.usermobile,       themeId,       to_char(trunc(sysdate, 'iw'), 'yyyy-mm-dd') begintime,       to_char(trunc(sysdate, 'iw') + 6, 'yyyy-mm-dd') endtime,       count(distinct t.attenddate) countOfAttendance  from user_attendance t where attenddate >= to_char(trunc(sysdate, 'iw'), 'yyyy-mm-dd')   and attenddate <= to_char(sysdate, 'yyyy-mm-dd') group by usermobile, themeid;

表结构
create table USER_ATTENDANCE
(
ID NUMBER(9) not null,
USERMOBILE VARCHAR2(15) not null,
THEMEID NUMBER(9),
ATTENDDATE VARCHAR2(19) not null
)