SELECT D.Dept_ID, D.Dept_Name, D.Dept_Abrev, D.Faculty_ID, D.School_ID, S.School_ID, S.School_Abr FROM Department D, School S Where D.School_ID < 5 AND D.Faculty_ID = 1 AND D.School_Id = S.School_ID ORDER BY School_Abr, Dept_Name

DID DEPARTMENT NAME #School_Abr#   #Dept_ID# #Dept_Name#