all-project/教职工数据迁移/verify_import.sql

-- 验证教职工数据导入结果
-- 执行时间: 2026-01-06

-- 1. 查看临时表结构
DESCRIBE temp_staff_data;

-- 2. 查看总记录数
SELECT COUNT(*) as total_records FROM temp_staff_data;

-- 3. 查看各部门员工数量统计
SELECT
    `部门` as department,
    COUNT(*) as employee_count
FROM temp_staff_data
GROUP BY `部门`
ORDER BY employee_count DESC;

-- 4. 查看性别分布
SELECT
    `性别` as gender,
    COUNT(*) as count
FROM temp_staff_data
GROUP BY `性别`;

-- 5. 查看是否在编状态分布
SELECT
    `是否在编_临时员工写L，外聘老师写W，正式写0_` as employment_status,
    COUNT(*) as count
FROM temp_staff_data
GROUP BY `是否在编_临时员工写L，外聘老师写W，正式写0_`;

-- 6. 查看前10条记录详情
SELECT
    `序号`,
    `姓名`,
    `性别`,
    `职务`,
    `部门`,
    `是否在编_临时员工写L，外聘老师写W，正式写0_`,
    `手机号_常用的一个_`
FROM temp_staff_data
ORDER BY `序号`
LIMIT 10;

-- 7. 检查是否有空值
SELECT
    COUNT(*) as total,
    SUM(CASE WHEN `姓名` IS NULL OR `姓名` = '' THEN 1 ELSE 0 END) as null_names,
    SUM(CASE WHEN `手机号_常用的一个_` IS NULL OR `手机号_常用的一个_` = '' THEN 1 ELSE 0 END) as null_phones,
    SUM(CASE WHEN `部门` IS NULL OR `部门` = '' THEN 1 ELSE 0 END) as null_departments
FROM temp_staff_data;