20240408
select day_id1, count(1)
from tsl_data.complaint_details_fix_ywd_day cdfyd
where month_id = '202404' and day_id = '06'
and duty_reason_id_day in ('移网质量>>网络覆盖>>Vo-LTE>>未开通/不支撑Vo-LTE功能', '移网质量>>网络覆盖>>2/3G网络精简>>2/3G网络精简')
group by day_id1
select day_id1, count(1)
from tsl_data.complaint_details_fix_ywd_day cdfyd
where month_id = '202403' and day_id = '31'
and duty_reason_id_day in ('移网质量>>网络覆盖>>Vo-LTE>>未开通/不支撑Vo-LTE功能', '移网质量>>网络覆盖>>2/3G网络精简>>2/3G网络精简')
group by day_id1
SELECT acct_date, count(1)
FROM tsl_data.mobile_complaint_day mcd
where month_id = '202403' and day_id = '31'
and duty_reason_id_day in ('移网质量>>网络覆盖>>Vo-LTE>>未开通/不支撑Vo-LTE功能', '移网质量>>网络覆盖>>2/3G网络精简>>2/3G网络精简')
group by acct_date
SELECT acct_date, count(1)
FROM tsl_data.mobile_complaint_day mcd
where month_id = '202403' and day_id = '31'
and duty_reason_id_day in ('移网质量>>网络覆盖>>Vo-LTE>>未开通/不支撑Vo-LTE功能')
group by acct_date
order by acct_date
SELECT acct_date, count(1)
FROM tsl_data.mobile_complaint_day mcd
where month_id = '202403' and day_id = '31'
and duty_reason_id_day in ('移网质量>>网络覆盖>>Vo-LTE>>未开通/不支撑Vo-LTE功能', '移网质量>>网络覆盖>>2/3G网络精简>>2/3G网络精简')
group by acct_date
order by acct_date
select *
from tsl_data.mobile_complaint_day mcd
where sheet_no in ('TS202403011513473716')
select count(1)
FROM tsl_data.mobile_complaint_day mcd
where month_id = '202403' and day_id = '31'
order by acct_date
select acct_date, count(1)
FROM tsl_data.mobile_complaint_day mcd
where month_id = '202403' and day_id = '31'
and duty_reason_id_day = '移网质量>>网络覆盖>>Vo-LTE>>未开通/不支撑Vo-LTE功能'
group by acct_date
order by acct_date
