MySQL / Join
-
Show the region_name and corresponding country_name
-
Show the department_name and corresponding country_name
-
Show the employee_name and his country_name
-
Show the employee_name and his job_title
-
Show the employee_name and his manager_name
-
Show the department_name and the manager_name of this department
-
Show the employee_id, his salary, his manager_id, his manager_name, his manager_salary
-
Show the employee_id, his join_date, his manager_id, his manager_name, his manager_salary
-
Show the manger_name and his manager_name(manager of manager)
-
Show the employees name and other employees name who receives higher salary than him
-
Show the employees name and other employees name who is hired after him
-
For each region, show the region_name and total no of employees in that region
-
For each job, show the job_title and total no of employees
-
For each country, show the total no of departments in that country
-
For each department, show the department_name and corresponding total no of ex-employees(job_history table) from that department
-
For each manager, show the manager_name and total no of employees under his supervision
-
For each manager, show the manager_name and total no of employees under his supervision who receives higher salary than him
-
Show the employee name and no of employees who receives lower salary than him
-
Show the employee name and no of employees who is hired before him