swissmakers_gmbh/programming-examples
12
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
master
programming-examples/sql/JoinHRDatabase
History
Michael Reber 8c9a19ec97 Adding SQL query language
2019-11-18 14:05:53 +01:00
..
1. Write a query in SQL to display the first name, last name, department number, and department name for each employee.sql
Adding SQL query language
2019-11-18 14:05:53 +01:00
2. Write a query in SQL to display the first and last name, department, city, and state province for each employee.sql
Adding SQL query language
2019-11-18 14:05:53 +01:00
3. Write a query in SQL to display the first name, last name, salary, and job grade for all employees.sql
Adding SQL query language
2019-11-18 14:05:53 +01:00
4. Write a query in SQL to display the first name, last name, department number and department name, for all employees for departments 80 or 40.sql
Adding SQL query language
2019-11-18 14:05:53 +01:00
5. Write a query in SQL to display those employees who contain a letter z to their first name and also display their last name, department, city, and state province.sql
Adding SQL query language
2019-11-18 14:05:53 +01:00
6. Write a query in SQL to display all departments including those where does not have any employee.sql
Adding SQL query language
2019-11-18 14:05:53 +01:00
7. Write a query in SQL to display the first and last name and salary for those employees who earn less than the employee earn whose number is 182.sql
Adding SQL query language
2019-11-18 14:05:53 +01:00
8. Write a query in SQL to display the first name of all employees including the first name of their manager.sql
Adding SQL query language
2019-11-18 14:05:53 +01:00
9. Write a query in SQL to display the department name, city, and state province for each department.sql
Adding SQL query language
2019-11-18 14:05:53 +01:00
10. Write a query in SQL to display the first name, last name, department number and name, for all employees who have or have not any department.sql
Adding SQL query language
2019-11-18 14:05:53 +01:00
11. Write a query in SQL to display the first name of all employees and the first name of their manager including those who does not working under any manager.sql
Adding SQL query language
2019-11-18 14:05:53 +01:00
13. Write a query in SQL to display the job title, department name, full name (first and last name ) of employee, and starting date for all the jobs.sql
Adding SQL query language
2019-11-18 14:05:53 +01:00
14. Write a query in SQL to display job title, full name (first and last name ) of employee, and the difference between maximum salary for the job and salary of the employee.sql
Adding SQL query language
2019-11-18 14:05:53 +01:00
15. Write a query in SQL to display the name of the department, average salary and number of employees working in that department who got commission.sql
Adding SQL query language
2019-11-18 14:05:53 +01:00
17. Write a query in SQL to display the name of the country, city, and the departments which are running there.sql
Adding SQL query language
2019-11-18 14:05:53 +01:00
18. Write a query in SQL to display department name and the full name (first and last name) of the manager.sql
Adding SQL query language
2019-11-18 14:05:53 +01:00
19. Write a query in SQL to display job title and average salary of employees.sql
Adding SQL query language
2019-11-18 14:05:53 +01:00
20. Write a query in SQL to display the details of jobs which was done by any of the employees who is presently earning a salary on and above 12000.sql
Adding SQL query language
2019-11-18 14:05:53 +01:00
21. Write a query in SQL to display the country name, city, and number of those departments where at leaste 2 employees are working.sql
Adding SQL query language
2019-11-18 14:05:53 +01:00
22. Write a query in SQL to display the department name, full name (first and last name) of manager, and their city.sql
Adding SQL query language
2019-11-18 14:05:53 +01:00
23. Write a query in SQL to display the employee ID, job name, number of days worked in for all those jobs in department 80.sql
Adding SQL query language
2019-11-18 14:05:53 +01:00
24. Write a query in SQL to display the full name (first and last name), and salary of those employees who working in any department located in London.sql
Adding SQL query language
2019-11-18 14:05:53 +01:00
25. Write a query in SQL to display full name(first and last name), job title, starting and ending date of last jobs for those employees with worked without a commission percentage.sql
Adding SQL query language
2019-11-18 14:05:53 +01:00
26. Write a query in SQL to display the department name and number of employees in each of the department.sql
Adding SQL query language
2019-11-18 14:05:53 +01:00