A raise for the London offices
Medium · Company database · UPDATE, Subqueries
Everyone who works in a department located in London gets a 5 percent raise: their new salary is the old salary times 1.05.
Update the employees table. Employees in other locations, and anyone without a department, keep their salaries.
After your SQL, this query shows
SELECT id, name, salary FROM employees ORDER BY id;
| id | name | salary |
|---|---|---|
| 1 | Meera Krishnan | 250000 |
| 2 | Daniel Okoye | 250000 |
| 3 | Sophie Laurent | 157500 |
| 4 | Rahul Bansal | 166000 |
| 5 | Hannah Schmidt | 110000 |
| 6 | Kenji Watanabe | 180000 |
| 7 | Thandiwe Nkosi | 126000 |
| 8 | Fatima Rahman | 180000 |
| 9 | Vikram Nair | 140000 |
| 10 | Laura Chen | 140000 |
| 11 | Arjun Patel | 95000 |
| 12 | Maria Gonzalez | 98000 |
| 13 | Ethan Brooks | 92000 |
| 14 | Zara Ahmed | 142000 |
| 15 | Oliver Hughes | 162750 |
| 16 | Priyanka Iyer | 89250 |
| 17 | Lucas Ferreira | 75600 |
| 18 | Nadia Petrova | 126000 |
| 19 | Samuel Adeyemi | 89250 |
| 20 | Grace Liu | 88000 |
| 21 | Mohammed Hassan | 76000 |
| 22 | Ines Moreau | 68000 |
| 23 | Joseph Mwangi | 90000 |
| 24 | Ana Reyes | 52000 |
| 25 | Carlos Mendoza | 52000 |
| 26 | Eva Novak | 135000 |
| 27 | Ravi Shankar | 105000 |
The company tables
assignments: 30 rows, first 5 shown
| id | employee_id | project_id | hours |
|---|---|---|---|
| 1 | 8 | 1 | 320 |
| 2 | 9 | 1 | 410 |
| 3 | 11 | 1 | 380 |
| 4 | 12 | 2 | 290 |
| 5 | 10 | 2 | 150 |
departments: 8 rows, first 5 shown
| id | name | location |
|---|---|---|
| 1 | Engineering | Bengaluru |
| 2 | Sales | London |
| 3 | Marketing | London |
| 4 | Finance | Singapore |
| 5 | Human Resources | Bengaluru |
employees: 27 rows, first 5 shown
| id | name | department_id | manager_id | job_title | salary | hire_date |
|---|---|---|---|---|---|---|
| 1 | Meera Krishnan | NULL | NULL | Chief Executive Officer | 250000 | 2015-03-01 |
| 2 | Daniel Okoye | 1 | 1 | Chief Technology Officer | 250000 | 2015-03-01 |
| 3 | Sophie Laurent | 2 | 1 | Head of Sales | 150000 | 2017-01-09 |
| 4 | Rahul Bansal | 4 | 1 | Finance Director | 166000 | 2016-11-21 |
| 5 | Hannah Schmidt | 5 | 1 | Human Resources Manager | 110000 | 2018-04-02 |
projects: 10 rows, first 5 shown
| id | name | department_id | budget | start_date | end_date |
|---|---|---|---|---|---|
| 1 | Payments Platform | 1 | 450000 | 2025-01-06 | 2025-09-30 |
| 2 | Mobile App Redesign | 1 | 300000 | 2025-03-03 | NULL |
| 3 | Data Warehouse | 1 | 380000 | 2025-06-02 | 2026-03-31 |
| 4 | Spring Campaign | 3 | 90000 | 2025-02-10 | 2025-05-30 |
| 5 | Partner Portal | 2 | 150000 | 2025-04-14 | 2025-12-19 |
-- Write your SQL here