Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
Write a SQL query to calculate the total salaries for each job title and the % it represents as of overall salaries in the company
For that you will be using the employee table:
| Column Name | Description |
|---|---|
| name | Employee's name |
| job_title | Employee's job title |
| salary | Employee's salary |
| job_title |
|---|
Write a SQL query to calculate the total salaries for each job title and the % it represents as of overall salaries in the company
For that you will be using the employee table:
| Column Name | Description |
|---|---|
| name | Employee's name |
| job_title | Employee's job title |
| salary | Employee's salary |
| job_title |
|---|
| percentage_of_total |
|---|
| Data Scientist | 196000 | 0.361... |
| Data Analyst | 300000 | 0.319... |
| Product Manager | 629000 | 0.212... |
| percentage_of_total |
|---|
| Data Scientist | 196000 | 0.361... |
| Data Analyst | 300000 | 0.319... |
| Product Manager | 629000 | 0.212... |