Question: WRITE THE QUERIES FOR THE FOLLOWING QUESITONS (USING QSL ORACLE). 11.Write a query to display the employees number, name, salary, department name of all the

WRITE THE QUERIES FOR THE FOLLOWING QUESITONS (USING QSL ORACLE). 11.Write a query to display the employees number, name, salary, department name of all the MANAGERS and CLERKS working in New York, Dallas with an

WRITE THE QUERIES FOR THE FOLLOWING QUESITONS (USING QSL ORACLE).

11.Write a query to display the employees number, name, salary, department name of all the MANAGERS and CLERKS working in New York, Dallas with an experiences more than 40 years without receiving the comm. Sort them as ascending of location.

20.Write a query to display the employees name, job, department name, location for those who are working as managers.

21.Write a query to display the employees name, salary, commission. For those employees whose net pay is greater than or equal to any other employee salary of the company. 22.Write a query to display the name of department where highest number of employees are working.

23.Write a query to find out how many Managers are their in the company.

24.Write a query to display the employees name, Job, Annual Salary, department no, department name and grade who earn more than 30000 a year or who are not CLERKS.

25.Write a query to display the employees details for whose grade are greater than the grade of MILLER.

SALGRA \begin{tabular}{|r|r|r|} \hline f GRADE & LOSAL & H HISAL \\ \hline 1 & 700 & 1200 \\ \hline 2 & 1201 & 1400 \\ \hline 3 & 1401 & 2000 \\ \hline 4 & 2001 & 3000 \\ \hline 5 & 3001 & 9999 \\ \hline \end{tabular} EMP Table \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline EMPNO & ENAME & JOB & MGR & HIREDATE & SAL & COMM & DEPTNO \\ \hline 7369 & SMITH & CLERK & 7902 & 17 -DEC-80 & 1400 & & 20 \\ \hline 7499 & ALLEN & SALESMAN & 7698 & 20 -FEB-81 & 1800 & 300 & 30 \\ \hline 7521 & WARD & SALESMAN & 7698 & 22 -FEB-81 & 1450 & 500 & 30 \\ \hline 7566 & JONES & MANAGER & 7839 & 02 -APR-81 & 3175 & & 20 \\ \hline 7654 & MARTIN & SALESMAN & 7698 & 28SEP81 & 1450 & 1400 & 30 \\ \hline 7698 & BLAKE & MANAGER & 7839 & 01MAY81 & 3050 & & 30 \\ \hline 7782 & CLARK & MANAGER & 7566 & 09 JUN-81 & 2650 & & 10 \\ \hline 7788 & SCOTT & ANALYST & & 19 APR-87 & 3200 & & 20 \\ \hline 7839 & KING & PRESIDENT & 7788 & 17 -NOV-81 & 5200 & & 10 \\ \hline 7876 & ADAMS & CLERK & 7698 & 23MAY87 & 1300 & & 20 \\ \hline 7900 & JAMES & CLERK & 7566 & 03DEC81 & 1150 & 300 & 30 \\ \hline 7902 & FORD & ANALYST & 7566 & 03DEC81 & 3200 & & 20 \\ \hline 7934 & MILLER & CLERK & 7782 & 23JAN82 & 1500 & & 10 \\ \hline \end{tabular} DEPT Table

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!

you with Textield given below (a) Consider the following table: EMPLOYEE (empid, ename, salary, joiningdate, designation, deptid), DEPT(deptid, dname) PROJECT(pid, pname, p_details, deptid) Write SQL...

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...

In this lab, we will continue to explore SQL queries using HR schema. You can complete the lab using either SQL Development or SQL*Plus. For this lab exercise, you will be using HR.EMPLOYEES,...

I am using Oracle SQL Developer and only have assignments work when I use identifiers such as "emp" or "sal". I need to complete the following assignment, but all the guides I am finding use...

database managemet system please use data for first question i say use first question data of all the questions Question 5 (20 points) Which employee has the maximum number of dependents. List SSN,...

This is script. We need to use Table EMP and Table DEPT. -- echo Building demo tables. Please wait. DROP TABLE EMP CASCADE CONSTRAINTS; DROP TABLE DEPT; DROP TABLE SALGRADE; DROP TABLE Prod CASCADE...

#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...

The problems on the next page require writing SQL scripts for Oracle. You should submit a script for each of these problems in separate text files. Please remember that PDFs and MS Word documents are...

2. For the Company Projects DB, (see Appendix), write SQL queries to answer perform each of the following actions. a) For each department whose average employee salary is more than $30,000, retrieve...

Using SQL Developer: Lesson 5 1 Display the highest, lowest, sum, and average salary of all employees. Label the columns Maximum, Minimum, Sum, and Average, respectively. Round your results to the...

Peggy and Gary had been married for five years, and had been trying to have a child. They had undergone artificial insemination and in vitro fertilization, but each pregnancy had resulted in a...

A job order cost sheet for Rolen Company is shown below. Instructions(a) On the basis of the foregoing data answer the following questions.(1) What was the balance in Work in Process Inventory on...

What is the speed of a P 2 P wireless bridge? A Up to 4 4 Mbps B Up to 3 4 Mbps Up to 2 4 Mbps D Up to 5 4 Mbps

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

5. What potential problems do you foresee bringing Banyan Tree to the Americas, Europe, and the Middle East? How could Banyan Tree address those issues?

LO 1 2. Evaluate the visit to National Metals Corporation. What happened? 3. What are the lessons of this experience?

2. What role does culture and leadership play in the success of Kiwi Experience?