Join
Solutions and examples for MySQL.
Showing 1–19 of 19 problems
- 01Show the region_name and corresponding country_name
- 02Show the department_name and corresponding country_name
- 03Show the employee_name and his country_name
- 04Show the employee_name and his job_title
- 05Show the employee_name and his manager_name
- 06Show the department_name and the manager_name of this department
- 07Show the employee_id, his salary, his manager_id, his manager_name, his manager_salary
- 08Show the employee_id, his join_date, his manager_id, his manager_name, his manager_salary
- 09Show the manger_name and his manager_name(manager of manager)
- 10Show the employees name and other employees name who receives higher salary than him
- 11Show the employees name and other employees name who is hired after him
- 12For each region, show the region_name and total no of employees in that region
- 13For each job, show the job_title and total no of employees
- 14For each country, show the total no of departments in that country
- 15For each department, show the department_name and corresponding total no of ex-employees(job_history table) from that department
- 16For each manager, show the manager_name and total no of employees under his supervision
- 17For each manager, show the manager_name and total no of employees under his supervision who receives higher salary than him
- 18Show the employee name and no of employees who receives lower salary than him
- 19Show the employee name and no of employees who is hired before him