There is a question I don't kown how to solve, could you help me?
Q: Create a query that will display the total number of employees and of that total the number who were hired in 1980,1981,1982 and 1983.Give appropriate column headings.
The result like below:
TOTAL 198019811982 1983
-----------
--------------- -------- ---------
14
1 10
2
1
The table is emp which is default in the system.