Question: 4. Write the SQL statement to produce a list that contains the employees first and last name, their department name, and the locations of the

4. Write the SQL statement to produce a list that contains the employees first and last name, their department name, and the locations of the department for employees in department 1 or 4..

5. Select a list of employees first names and salary whose salary is greater than 30,000 and work in the research department. The WHERE clause should match on the literal Research; do not match on Department number.

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 General Management Questions!

6. Write an SQL Statement to produce a list that contains employees first name, the project numbers the employee has worked on, and the number of hours the employee has worked on each project. Sort...

-- echo Building demo tables. Please wait. DROP TABLE EMP CASCADE CONSTRAINTS; DROP TABLE DEPT; DROP TABLE SALGRADE; DROP TABLE Prod CASCADE CONSTRAINTS; DROP TABLE Vend; CREATE TABLE DEPT ( DEPTNO...

PROVECT Figure 3. 3344555 M19420228 Spoe Given the above database, and the primary/foreign keys used for it as discussed in the course slides, specify how you would write the following queries using...

Write SQL queries to answer the following questions: Write a query to list the employees first, and last name as well as their hire date and commission _ pct . If the commission _ pct is empty report...

Chapter 4 1. Write a query that will select all columns from the projectAssignment table without using the (*) in your query. You may wish to use the DESCRIBE command to examine the structure of the...

The purpose of this question is to allow learner to apply the knowledge of creating relational schema and ER/EER diagram, based on a given scenario. a. b. A family tree represents the structure of a...

Please answer completely and correctly. 1. Consider the following schema of an EMPLOYEE database and answer the questions that follow: DEPARTMENTS (DEPARTMENT ID, DEPARTMENT-NAME, MANAGER-ID,...

Use the library EER diagram and the library database in UM learn to answer questions 1-4 Create the Library database Using the Script provided in UMlearn, create, and populate all tables to answer...

a)write a query in SQL to create employees table using table-1 b) write a query in SQL to find highest salary employees c)write a query in SQL to find highest salary for female employees d) write a...

Based on company database (a) Explain what would be retrieved by the following query SELECT DISTINCT PNUMBER FROM PROJECT WHERE PNUMBER IN (SELECT PNUMBER FROM PROJECT, DEPARTMENT, EMPLOYEE WHERE...

Sandra is saving 500,000 per year in a savings account that is paying an annual compound interest of 5% she intends to continue this for three years after which she will move to jmmbs long-term fund...

The director of a small business development center located in a mid-sized city is reviewing data about its clients. In particular, she is interested in examining if the distribution of business...

When using the subjective approach to project analysis, a firm: 3 4 Multiple Choice must have an all - equity capital structure. uses the WACC of Firm x as the basis for the discount rate for a...

Tony died earlier this year and the forensic accountant found the following assets and liabilities. You have been asked to determine the value of the taxable estate. Town house acquired with...