Practice Interview Questions
| Question | Status |
|---|---|
You're given a dataset from Google called google_salaries containing information about various individuals, including their education levels and salaries.
Your goal is to calculate the average salary for each level of education. Round your results to 1 decimal points.
google_salaries table:
| Column Name | Description |
|---|---|
| first_name | The first name of the individual |
| last_name | The last name of the individual. |
| department | The employee's assigned department |
| education | The education level of the individual |
| salary | The salary of the individual |
You're given a dataset from Google called google_salaries containing information about various individuals, including their education levels and salaries.
Your goal is to calculate the average salary for each level of education. Round your results to 1 decimal points.
google_salaries table:
| Column Name | Description |
|---|---|
| first_name | The first name of the individual |
| last_name | The last name of the individual. |
| department | The employee's assigned department |
| education | The education level of the individual |
| salary | The salary of the individual |
| education | avg_salary |
|---|---|
| Bootcamp | 31231.2 |
| Bachelor | 30121.1 |
| Master | 29000.2 |
| education | avg_salary |
|---|---|
| Bootcamp | 31231.2 |
| Bachelor | 30121.1 |
| Master | 29000.2 |