| .. |
|
1. Write a query in SQL to display the full name (first and last name), and salary for those employees who earn below 6000.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 number and salary for those employees who earn more than 8000.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
3. Write a query in SQL to display the first and last name, and department number for all employees whose last name is McEwen.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
4. Write a query in SQL to display all the information for all employees without any department number.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
5. Write a query in SQL to display all the information about the department Marketing.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
6. Write a query in SQL to display the full name (first and last), hire date, salary, and department number for those employees.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
7. Write a query in SQL to display all the information of employees whose salary is in the range of 8000 and 12000 and commission is not null.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
8. Write a query in SQL to display the full name (first and last name), and salary for all employees who does not earn any commission.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
9. Write a query in SQL to display the full name (first and last), the phone number and email separated.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
10. Write a query in SQL to display the first and last name, and salary for those employees whose first name is ending with the letter m.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
11. Write a query in SQL to display the full name (first and last) name, and salary, for all employees whose salary is out of the range 7000 and 15000.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
13. Write a query in SQL to display the the full name (first and last name), and department number for those employees who works either in department 70 or 90.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
14. Write a query in SQL to display the full name (first and last name), salary, and manager number for those employees.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
15. Write a query in SQL to display all the information from Employees table for those employees who was hired before June 21st, 1987.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
16. Write a query in SQL to display the first and last name, email, salary and manager ID, for those employees whose managers are hold the ID 120, 103 or 145.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
18. Write a query in SQL to display the full name (first name and last name), hire date, commission percentage.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
19. Write a query in SQL to display the first and last name, and department number for those employees who holds a letter.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
20. Write a query in SQL to display the employee ID, first name, job id, and department number for those employees who is working except the departments 50,30 and 80.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
21. Write a query in SQL to display the employee Id, first name, job id, and department number for those employees whose department number equals 30, 40 or 90.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
22. Write a query in SQL to display the ID for those employees who did two or more jobs in the past.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
23. Write a query in SQL to display job ID, number of employees, sum of salary, and difference between highest salary and lowest salary for a job.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
24. Write a query in SQL to display job ID for those jobs that were done by two or more for more than 300 days.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
25. Write a query in SQL to display the country ID and number of cities in that country we have.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
26. Write a query in SQL to display the manager ID and number of employees managed by the manager.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
27. Write a query in SQL to display the details of jobs in descending sequence on job title.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
28. Write a query in SQL to display the first and last name and date of joining of the employees.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
29. Write a query in SQL to display the average salary of employees for each department who gets a commission percentage.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
30. Write a query in SQL to display those departments where any manager is managing 4 or more employees.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
31. Write a query in SQL to display those departments where more than ten employees work.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
32. Write a query in SQL to display the employee ID and the date on which he ended his previous job.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
34. Write a query in SQL to display the job ID for those jobs which average salary is above 8000.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
35. Write a query in SQL to display job Title, the difference between minimum and maximum salaries for those jobs which max salary within the range 12000 to 18000.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
36. Write a query in SQL to display all those employees whose first name or last name starts with the letter D.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
37. Write a query in SQL to display the details of jobs which minimum salary is greater than 9000.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
|
38. Write a query in SQL to display those employees who joined after 7th September, 1987.sql
|
Adding SQL query language
|
2019-11-18 14:05:53 +01:00 |
