Question: sql 1. Write a query to display the employee's number, name, job, Hiredate, and experiences (Working Years) of all MANGERS. 2. Write a query to

sql

1. Write a query to display the employee's number, name, job, Hiredate, and experiences (Working Years) of all MANGERS. 2. Write a query to display all the details of the employees whose commission is more than their salary. 3. Write a query to display the employees in the ascending order of designations of those joined after the first half of 1981. 4. Write a query to display the employees who are joined in the month of Feb 1981 5. Write a query to display the employees who Annual sal ranging from 22000 and 45000. 6. Write a query to display the employees who have Five character names starting with ' S ' and ending with ' H '. 7. Write a query to display the employees who joined in June. 8. Write a query to display the employees who does not work in department number 30 . 9. Write a query to display all employees except 'PRESIDENT' \& 'MANAGER" in ascending order by Salaries

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

please answer quick using hr.employees from oracle live sql 1. Write a query to display the name ( first name and last name ) for those employees who gets more salary than the employee whose ID is...

***********PLEASE USE THIS TABLES************ DROP TABLE EMP; DROP TABLE DEPT; DROP TABLE SALGRADE; create table dept( deptno number(2,0), dname varchar2(14), loc varchar2(13), constraint pk_dept...

--******************************************* -- SECTION 1: Single-Table SQL Queries -- --******************************************* -- 1. Write a query to display customers last names, first names,...

Here are some of the questions for SqlPlus need to be answered based on this diagram. After you have created the SQL query for each question, add that SQL under the question in the file: /*** 1 ***/...

-- SECTION 1: Single-Table SQL Queries --******************************************* -- 1. Write a query to display customers last names, first names, and email addresses. -- Sort your results by...

#1. Write a query to display employee number, employee name, hiredate, manager's name for those employees, whose manager's name starts with K or M or S. Label the columns Employee Number, Employee...

ConAir (CA) commercial airlines company requires you experience in database design and have approached you to assist in the design of their new airline database system. They urgently need to have...

Looking for 5.1-5.10 5. Create Queries that to do the following: (10 marki). Your queries will be marked based on whether the queries are formulated correct or not, net based on the records that are...

1- Write a query to display the names (first_name, last_name) from employees table using alias name First Name", "Last Name" 2- Write a query to display the names (first_name concatenate last_name)...

An auto manufacturer leases cars to small businesses for use in visiting clients and other business travel. The contracted lease does not specify a mileage limit and instead includes a depreciation...

Name four popular ratios for measuring profitability, and indicate how to compute each of the four.

Which of the following statements concerning federal income tax and annuities is ( are ) CORRECT? I . The contributed amount invested in the annuity accumulates on a tax - deferred basis. II ....

Complete the following: (Do not round intermediate calculations. Round your final answers to the nearest cent.) Actual partial payment Date of partbalAmount of payment to be Amount of invoice Balance...

Explain allyship training? How can allyship training contribute to companies efforts toward diversity, equity, and inclusion?

Do employee resource groups such as those for women, Hispanics, veterans, and other groups help or hinder efforts to improve diversity and inclusion in the workplace? Explain your answer.

What can companies do to ensure employees have digital literacy and close other skills gaps?