HCCP 근로자 SQL 실습 변수표
HCCP 근로자 데이터 SQL 실습 과제
데이터
python scripts/build_hccp_worker_csv.py
생성 결과:
주의사항
과제 1. 데이터 구조 확인
예시:
SELECT industry_group, COUNT(*) AS worker_count FROM hccp_workers GROUP BY industry_group ORDER BY worker_count DESC;
과제 2. 교육훈련 참여 분석
예시:
SELECT AVG(CASE WHEN training_job_related = 1 THEN 1.0 ELSE 0.0 END) * 100 AS job_training_rate FROM hccp_workers WHERE training_job_related IS NOT NULL;
과제 3. 교육훈련 인식과 직무만족
예시:
SELECT CASE WHEN training_sufficient >= 4 THEN '높음' WHEN training_sufficient <= 2 THEN '낮음' ELSE '보통' END AS training_sufficient_group, COUNT(*) AS worker_count, ROUND(AVG(overall_job_satisfaction), 2) AS avg_job_satisfaction FROM hccp_workers WHERE training_sufficient IS NOT NULL AND overall_job_satisfaction IS NOT NULL GROUP BY training_sufficient_group;
과제 4. 조직문화와 이직의향
예시:
SELECT CASE WHEN organizational_loyalty >= 4 THEN '충성도 높음' WHEN organizational_loyalty <= 2 THEN '충성도 낮음' ELSE '보통' END AS loyalty_group, COUNT(*) AS worker_count, ROUND(AVG(turnover_intention), 2) AS avg_turnover_intention FROM hccp_workers WHERE organizational_loyalty IS NOT NULL AND turnover_intention IS NOT NULL GROUP BY loyalty_group ORDER BY avg_turnover_intention DESC;
과제 5. 근로시간과 소득
예시:
SELECT gender, COUNT(*) AS worker_count, ROUND(AVG(annual_income_10k_krw), 1) AS avg_annual_income_10k_krw FROM hccp_workers WHERE annual_income_10k_krw IS NOT NULL GROUP BY gender ORDER BY avg_annual_income_10k_krw DESC;