Thank you very much.

How can I count the rows when I make new table. Here is my code:

SELECT EMPLOYEE_ID, LAST_NAME, SALARY, JOB_ID, COMMISSION_PCT, DEPARTMENT_ID, COUNT(TO_CHAR(HIRE_DATE, 'DAY')) AS NUM_EMPLOYEES

FROM EMPLOYEES

WHERE TO_CHAR(HIRE_DATE, 'Day') = 'Monday'

GROUP...

SELECT

DISTINCT E.JOB_ID

,D.DEPARTMENT_NAME

,COUNT(E.LAST_NAME) OVER

(

...

I made it. Thank you. If I have any other questions I will post them. Thanks!

Here is the picture: https://www.dropbox.com/s/v9l4sp6o2lml101/2.PNG?dl=0

Thank you! But I do not want to for example IT_PROG to be displayed 5 times. Please take a look at the attached picture. I tried to use DISTINCT, but...

The tables are linked by these lines:

FROM EMPLOYEES E JOIN DEPARTMENTS D

ON (E.DEPARTMENT_ID = D.DEPARTMENT_ID)

The names of the tables are called: EMPLOYEES and DEPARTMENTS