# 稽核用查詢

-- 資料庫留存之會員契約紀錄，個人每月前25筆，法人使用者每月第一筆
select MD_MEMID, MD_LEVEL, MD_CREATETIME, MD_MEMTYPE, MA_ID, MA_AGMNID, MA_AGREETIME from ITPADMOR.itp_mem_data a join itp_mem_aggrement b on a.md_memid = b.ma_memid
where trunc(md_createtime) between '2020-09-01' and '2020-09-30' and MD_MEMTYPE = 'PSN' AND rownum <= 25 order by md_createtime;

-- 個人使用者及法人使用者新增之總筆數
select COUNT(*), MD_memtype from ITPADMOR.itp_mem_data where trunc(md_createtime) between '2020-09-01' and '2020-11-30' group by MD_MEMTYPE;

-- 個人使用者註冊名單
select md_memid, md_level, md_createtime from ITPADMOR.itp_mem_data where trunc(md_createtime) between '2020-09-01' and '2020-11-30' and MD_MEMTYPE='PSN' order by md_createtime;