Cacher is the code snippet organizer for pro developers

SELECT 'Clinical Nurses (Other than APNs)' AS CFM_LIST,
  p.DEPT                                   AS DEPT,
  d.COMMON_NAME                            AS NAME,
  d.SERVICE                                AS SERVICE,
  p.UNIT_ID                                AS UNIT_ID,
  p.EMPLOYEE_ID                            AS EMPLOYEE_ID,
  p.LAST_NAME                              AS LAST_NAME,
  p.FIRST_NAME                             AS FIRST_NAME,
  p.POS_CODE                               AS POS_CODE,
  p.TITLE                                  AS TITLE,
  P.MIN_WKLY_HRS/40                        AS FTE,
  E.DEGREE_TYPE                            AS DEGREE,
  E.NURSING                                AS NURSING,
  'HH'                                     AS FACILITY
FROM MAGNET_PROFILES_HH p
JOIN MAGNET_DIF_UNITS_HH d
ON P.DEPT               = D.HRMS_DEPT
LEFT JOIN IER_DEGREE_HH E
ON E.EMPLOYEE_ID = P.EMPLOYEE_ID
AND E.DEGREE_TYPE = 'Bachelors Degree'
AND E.NURSING = 'Yes'
WHERE ( p.min_wkly_hrs >= 4
AND p.dept NOT         IN ('601','847') )
AND p.POS_CODE         IN (112,212,219,220,221,277,278,290,291,292,293,294,295,298,303,313,315,323,373,380,737,1226,2231)
ORDER BY FACILITY,
  p.last_name,
  P.FIRST_NAME,
  p.pos_code;