Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
You have a table named employees with 2 columns, first_name and last_name. Write a SQL query to display each employee's full name in a single column. If the first name is John and last name is Doe, you should display: John Doe
employees table:
| Column Name | Description |
|---|---|
| first_name | The first name of the employee |
| last_name | The last name of the employee |
| full_name |
|---|
| John Doe |
| Jane Smith |
You have a table named employees with 2 columns, first_name and last_name. Write a SQL query to display each employee's full name in a single column. If the first name is John and last name is Doe, you should display: John Doe
employees table:
| Column Name | Description |
|---|---|
| first_name | The first name of the employee |
| last_name | The last name of the employee |
| full_name |
|---|
| John Doe |
| Jane Smith |
| Emily Jones |
| Emily Jones |