select count(c.id)
from tb_clue c,tb_assign_record ar
where c.id=ar.assign_id
  and ar.user_name='zhangsan'
  and ar.type='0'
  and ar.latest='1'
  and date_format(ar.create_time,'%Y-%m-%d')='2022-04-18';

select count(b.id)
from tb_business b,tb_assign_record ar
where b.id=ar.assign_id
  and ar.user_name='lisi'
  and ar.type='1'
  and ar.latest='1'
  and date_format(ar.create_time,'%Y-%m-%d')='2022-05-03';


select count(course_id)
from tb_contract
where create_by='lisi'
  and date_format(create_time,'%Y-%m-%d')='2022-04-20';

select sum(contract_order)
from tb_contract tc
where create_by='lisi'
  and date_format(create_time,'%Y-%m-%d')='2022-04-20';