cross-tabulation values to display the total salary for IT_PROG code example

Example: find out all employees with department id of 60 or 100 in sql

SELECT * FROM EMPLOYEES 
WHERE DEPARTMENT_ID = 60 OR DEPARTMENT_ID = 100 ;