select left(composite_id,4), count(*) from  pesp_db_p23_live.receiveddata
where school_code in (91411052206)
-- and remark in ('R', 'r');
group by left(composite_id,4);

select left(composite_id,4), count(*) from  pesp_db_p23_live.receiveddata
where school_code in (91411052212)
-- and remark in ('R', 'r');
group by left(composite_id,4);




select school_code, count(distinct composite_id) cnt
from pesp_db_p23_live.receiveddata
group by school_code
having  cnt = 0;

select count(distinct school_code)
from pesp_db_p23_live.receiveddata;