completely stumped on how to get number 11 all on one line and completely confused about 12 thanks for your help I'm using sqlplus

11 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 1987. Give appropriate column headings TOTAL 1980 1981 1982 1987 14 10 2 12. Create a matrix query to display the job, the salary for that job based upon department number and the total salary for that job for all departments, giving each column an appropriate heading Job Dept 10 1300 5000 Dept 20 Dept 30 Total 1900 950 5600 CLERK SALESMAN PRESIDENT MANAGER ANALYST 4150 5600 5000 8275 6000 2450 2975 6000 2850