Aggregate

Database 1:

i) employees Table

employee_id	name	age	department	salary	manager_id
101	Alice	30	HR	60000.00	Null
102	Bob	28	IT	70000.00	101
103	Charlie	35	Finance	90000.00	101
104	David	40	IT	85000.00	102
105	Emma	25	Marketing	50000.00
106	Frank	32	HR	65000.00
107	Grace	29	Finance	95000.00
108	Hannah	38	IT	78000.00

ii) departments Table

department_id	department	location
1	HR	New York
2	IT	San Francisco
3	Finance	Chicago
4	Marketing	Los Angeles

iii) salaries table

salary_id	employee_id	salary_amount	salary_date	bonus
1	101	60000	2024-01-01	5000
2	102	70000	2024-01-01	3000
3	103	90000	2024-01-01	7000
4	104	85000	2024-01-01	6000
5	105	50000	2024-01-01	2000
6	106	65000	2024-01-01	4000
7	107	95000	2024-01-01	8000
8	108	78000	2024-01-01	5500