Practice Interview Questions
| Question | Status |
|---|---|
Determine the count of employees within each profession sharing the same birth month. The output should include the profession, birth month, and the number of employees from that department who were born in that month.
employee_list table:
| Column Name | Description |
|---|---|
| first_name | First name |
| last_name | Last name |
| profession | Profession name |
| employee_id | Identifier of employee |
| birthday | Birthday date |
| birth_month |
| Birth month number |
Example output:
| profession | Month_1 | Month_2 | Month_3 | Month_4 | Month_5 | Month_6 | Month_7 | Month_8 | Month_9 | Month_10 | Month_11 | Month_12 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Accountant | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 |
Determine the count of employees within each profession sharing the same birth month. The output should include the profession, birth month, and the number of employees from that department who were born in that month.
employee_list table:
| Column Name | Description |
|---|---|
| first_name | First name |
| last_name | Last name |
| profession | Profession name |
| employee_id | Identifier of employee |
| birthday | Birthday date |
| birth_month | Birth month number |
Example output:
| profession | Month_1 | Month_2 | Month_3 | Month_4 | Month_5 | Month_6 | Month_7 | Month_8 | Month_9 | Month_10 | Month_11 | Month_12 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Accountant | 0 | 0 | 1 | 0 | 0 |
| 1 |
| 1 |
| 1 |
| 1 |
| 0 |
| 0 |
| 0 |