UNPIVOT (NoEmp for DepartmentName IN ( [Production],[Engineering], [Sales])) AS ok -- Task 2. Đọc bổ sung kiến thức về Set operators (Tham khảo: https ...

SELECT a.id as id_commune,a.insee_com,a.insee_dep,a.code_post,a.nom,a.cl_arrond,a.cl_collter,a.siren_epci,a.code_siren, o.id as oge_id , o.code_cs,o.code_us,o ...