SQL
SQL
SQL
Write a query in SQL to display the full name (first and last name), and salary
for those employees who earn below 6000.?
SELECT first_name ||' '||last_name AS Full_Name, salary FROM employees WHERE salary
< 6000;
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
3. Write a query in SQL to display the first and last name, and department number
for all employees whose last name is �McEwen�
4. Write a query in SQL to display all the information for all employees without
any department number.
5. Write a query in SQL to display the full name (first and last), hire date,
salary, and department number for those employees whose first name does not
containing the letter M
and make the result set in ascending order by department number?
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
or department number is except the number 40, 120 and 70 and they have been hired
before June 5th, 1987.
select * from employees where salary between 8000 and 12000 and COMMISSION_PCT is
not null or department_id not in(40, 120, 70) and hire_date< '1987-06-05';
8. Write a query in SQL to display the full name (first and last), the phone number
and email separated by hyphen, and salary, for those employees
whose salary is within the range of 9000 and 17000. The column headings assign with
Full_Name, Contact_Details and Remuneration respectively.
9 . 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
10.. Write a query in SQL to display the full name (first and last name), salary,
and manager number for those employees who is working under a manager.
1. Write a query in SQL to display the first name, last name, department number,
and department name for each employee
2.Write a query in SQL to display the first and last name, department, city, and
state province for each employee.
3. Write a query in SQL to display the first name, last name, salary, and job grade
for all employees.
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.
6. Write a query in SQL to display all departments including those where does not
have any employee
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
8. Write a query in SQL to display the first name of all employees including the
first name of their manager.
9. Write a query in SQL to display the department name, city, and state province
for each department.
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.
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.
12. Write a query in SQL to display the first name, last name, and department
number for those employees who works in the same department as the employee who
holds the last name as Taylor.