Practice Interview Questions
| Question | Status |
|---|---|
Identify doctors with the last name 'Johnson' in the employee list. The output should include both their first and last names.
employee_list table:
| Column Name | Description |
|---|---|
| first_name | First name |
| last_name | Last name |
| profession | Profesion name |
| employee_id | Identifier of employee |
| birthday | Birthday date |
| birth_month | Birth month |
Identify doctors with the last name 'Johnson' in the employee list. The output should include both their first and last names.
employee_list table:
| Column Name | Description |
|---|---|
| first_name | First name |
| last_name | Last name |
| profession | Profesion name |
| employee_id | Identifier of employee |
| birthday | Birthday date |
| birth_month | Birth month |
Example output:
| first_name | last_name |
|---|---|
| Sarah | Johnson |
Example output:
| first_name | last_name |
|---|---|
| Sarah | Johnson |