Instructions: Write the suitable SQL statement to answer the following questions based on the following tables ( image for better table) Table Name: Employee EMP_ID FNAME LNAME SALARY JOIN_DATE DEP_NO 101 John Abraham 10000 01-JAN-13 11 202 Michael Clarke 80000 01-JAN-13 22 303 Roy Thomas 70000 01-FEB-13 11 404 Tom Jose 60000 01-FEB-13 22 505 Jerry Pinto 65000 01-FEB-13 22 606 Philip Mathew 75000 01-JAN-13 33 707 Thomas Jack 65000 01-JAN-13 33 Table Name: Reward EMP_ID REWARD_DATE AMOUNT 101 01-FEB-13 5000 202 01-FEB-13 3000 303 01-FEB-13 4000 101 01-JAN-13 4500 202 01-JAN-13 3500 Table Name: Department DEP_NO DEP_NAME 11 Banking 22 Insurance 33 Services 44 Marketing the question is: 5. Retrieve number of Employee under each Department.

Instructions:

Write the suitable SQL statement to answer the following questions based on the following tables ( image for better table)

Table Name: Employee
EMP_ID FNAME LNAME SALARY JOIN_DATE DEP_NO
101 John Abraham 10000 01-JAN-13 11
202 Michael Clarke 80000 01-JAN-13 22
303 Roy Thomas 70000 01-FEB-13 11
404 Tom Jose 60000 01-FEB-13 22
505 Jerry Pinto 65000 01-FEB-13 22
606 Philip Mathew 75000 01-JAN-13 33
707 Thomas Jack 65000 01-JAN-13 33

Table Name: Reward
EMP_ID REWARD_DATE AMOUNT
101 01-FEB-13 5000
202 01-FEB-13 3000
303 01-FEB-13 4000
101 01-JAN-13 4500
202 01-JAN-13 3500

Table Name: Department
DEP_NO DEP_NAME
11 Banking
22 Insurance
33 Services
44 Marketing

the question is:

5. Retrieve number of Employee under each Department.