tsl-data/doc/sql/sql备份.sql

select acct_date, count(1)
from tsl_data.high_quality_count_day
group by acct_date
order by acct_date;

select month_id, day_id, count(1)
from tsl_data.high_quality_list_day
group by month_id, day_id
order by month_id, day_id;

select month_id, day_id, count(1)
from tsl_data.mobile_complaint_day
group by month_id, day_id
order by month_id, day_id;

select day_id, count(1)
from tsl_data.high_quality_data
group by day_id
order by day_id;

select month_id, city_name, management_target_ts_ratio, target_ts_ratio
from report_auto.target_ts_ratio
where month_id = '202312'
order by city_name;

update report_auto.target_ts_ratio
set management_target_ts_ratio = 4.10, target_ts_ratio =4.1
where month_id = '202312'
  and city_name in ('保定', '秦皇岛', '唐山');
update report_auto.target_ts_ratio
set management_target_ts_ratio = 3.90, target_ts_ratio =3.9
where month_id = '202312'
  and city_name in ('沧州', '承德', '邯郸', '邢台');
update report_auto.target_ts_ratio
set management_target_ts_ratio = 3.40, target_ts_ratio =3.4
where month_id = '202312'
  and city_name = '衡水';
update report_auto.target_ts_ratio
set management_target_ts_ratio = 4.20, target_ts_ratio =4.2
where month_id = '202312'
  and city_name = '廊坊';
update report_auto.target_ts_ratio
set management_target_ts_ratio = 4.00, target_ts_ratio =4.0
where month_id = '202312'
  and city_name in ('石家庄', '张家口', '全省');
update report_auto.target_ts_ratio
set management_target_ts_ratio = 4.90, target_ts_ratio =4.9
where month_id = '202312'
  and city_name = '雄安';