Applying It

Independent Exercise 1:

• SELECT the departments with a count of the rows for each department.
  
  

Independent Exercise 2:

• Build a Master/Detail report using DEPT and EMP.
  
  
• Show just the Department Name on the master record.
  
  
• Show the employees name and salary in the Detail.
  
  
• Create a Cross-matrix report using EMP, showing the salaries summed by JOB and by DEPTNO.
  
  

Independent Exercise 3:

• UPDATE the EMP table, give everyone a 10% increase in salary.
  
  
• Show the values of ENAME and SAL prior to the UPDATE.