Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
You are given a table named employees containing employee details. The table has the following structure:
| Column Name | Description |
|---|---|
| first_name | The first name of the employee. |
| last_name | The last name of the employee. |
Write a SQL query to generate LinkedIn URLs for each employee. The format for the URL should be www.linkedin.com/first_name-last_name, with the first_name and last_name in lowercase. If your first name is Dwayne and last name is Johnson your linkedin url should have this format: www.linkedin.com/dwayne-johnson
| final_url |
|---|
You are given a table named employees containing employee details. The table has the following structure:
| Column Name | Description |
|---|---|
| first_name | The first name of the employee. |
| last_name | The last name of the employee. |
Write a SQL query to generate LinkedIn URLs for each employee. The format for the URL should be www.linkedin.com/first_name-last_name, with the first_name and last_name in lowercase. If your first name is Dwayne and last name is Johnson your linkedin url should have this format: www.linkedin.com/dwayne-johnson
| final_url |
|---|
| www.linkedin.com/jane-smith |
| www.linkedin.com/emily-jones |
| www.linkedin.com/jane-smith |
| www.linkedin.com/emily-jones |