SELECT COUNT(DISTINCT employee_profile_id) as total_employees FROM shieldtech_hcm.employee_family_members WHERE is_school = 1;

SELECT SUM(CASE WHEN id_card_nr IS NULL OR id_card_nr = '' THEN 1 ELSE 0 END) as no_ktp, SUM(CASE WHEN npwp IS NULL OR npwp = '' THEN 1 ELSE 0 END) as no_npwp, SUM(CASE WHEN emergency_contact_fullname IS NULL OR emergency_contact_fullname = '' THEN 1 ELSE 0 END) as no_emergency_contact FROM shieldtech_hcm.employee_profiles WHERE resigned_date IS NULL;