Question: I 2. Using EMPLOYEES table, write a query that will display Department_ID, and lowest salary with the label of Low Salary for each department_ID, whose

I 2. Using EMPLOYEES table, write a query that will display

I 2. Using EMPLOYEES table, write a query that will display Department_ID, and lowest salary with the label of "Low Salary" for each department_ID, whose First_Name contain letter "e" and the lowest salary is below 10000. Arrange it by Department_ID from highest to lowest

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!

1. Create a query using the Departments and Job_History tables to display manager_id and the startdate in the form of "TWENTY-FOURTH of Mar, 1998, TUE with the column name BornDate and by extracting...

Please find the solution: Section A: Query Design [50 Marks] 1. Create a query using the Job_History and Departments tables to display the start_date in the form of September, Nineteen Eighty-Nine,...

Required: Use the Employees table (copy and paste the code in SQL command line) Write the PL/SQL based on the requirement in each number. Note: Sample output is just a guide, it does not necessarily...

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

Choose the letter of the correct answer based on the table EMPLOYEES as shown below. Table 1.0 EMPLOYEES 1. What query should be used in order todisplay a report that trim the letter A from lastname...

4. Using subquery, display first_name and the salary without decimal places and give the column name as mysalary" from f_staffs table, whose id is same as the ID of the staff whose staff_type is...

Consider the above given schema and write down following SQL queries. 1. Display the highest, lowest, sum and average salary of all employees. Label the columns Maximum, Minimum, Sum and Average...

CREATE TABLE EMPLOYEES( EMPLOYEE_ID NUMBER(3) PRIMARY KEY, FIRSTNAME VARCHAR(10), LASTNAME VARCHAR(10)NOT NULL, JOB_ID VARCHAR(10), SALARY NUMBER(8,2), MANAGER_ID NUMBER(6), DEPARTMENT_ID NUMBER(4));...

Midwest Executive Professionals IMPROVE A DATABASE BY CREATING AND MODIFYING TABLES, QUERIES, FORMS, AND REPORTS - GETTING STARTED . Open the file IL_AC19_CS1-4a_FirstLastName Waacob, available for...

USE HR Schema to perform the following tasks: 1. Display all the details of employees who ended job at 19 Dec-07. (2 marks) 2. Select all fields from "LOCATIONS" where country ID is "UK" AND city...

Carte Blanche, Inc. is expected to pay its common shareholders an annual $3.40 dividend one year from today. The company pledges to increase its dividend by 2% per year indefinitely thereafter. If...

Fill in the missing amounts in each of the eight case situations below. Each case is independent of the others a. Assume that only one product is being sold in each of the four following case...

5 Imagine you are Ben Gunn. Write a monologue as if you were talking to Jim. Tell him about how you spent your first day and night alone. Include details about: . how you felt what you did for food...

Scenario: A Multi-national Corporation called The Globe has created a subsidiary called Thirst in an under-developed country called non-potable waters. This hosting country suffers from a severe...

h. How has your family status changed through the generations? Compare your family experience with those of your classmates. Did most immigrants come for the same reasons? What are the differences in...

b. Where did they come from?

g. What were their occupations before they came, and what jobs did they take on their arrival?