Question: 1 . With your SQL code, you want to display / output the employee first names, last names, department ids, and salaries of all employees

1. With your SQL code, you want to display/output the employee first names, last names, department ids, and salaries of all employees that have a department id of 30,40,50,60,70, OR 80. Make sure your output is sorted by department_id in ascending order. HINT: Use the IN SQL keyword.

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 Programming Questions!

Q:

i tried to put the script but it is too long so i could not able to put the script . i can send you when you request me I think. 1. List the ID's of the volunteers that have not worked. 2. List all...

Q:

Table Name: DEPT D.id DName 111 Sales Building First Second 112 Accounts 113 First Service HR 114 Second Table Name: EMP Eld Ename Do Depno 113 E101 Ahmed E102 Gaith 111 E103 Hafsa Salary 300.000 625...

Q:

SQL CODE: 30. Write a query to display the first name, last name, phone number, title, and department number of employees who work in department 300 or have the title "CLERK I." Sort the output by...

Q:

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

Q:

6 . Write the SQL statement to create a report with employee employee ids, last names, job id , phone numbers, and salary for all employees who make at least $ 8 , 0 0 0 AND their job id is IT _...

Q:

Can anyone helps me with this SQL. 1- Write a SQL query to display list of unique first and last names of students, admins and instructors. 2-Write a SQL query to display list of employee IDs along...

Q:

ALL IN C++ Question: 1. Download the input file, employees.dat, from my public directory. While you are in your own cs... 1. Download the input file, employees.dat, from my public directory. While...

Q:

10. write a SQL query to find those employees who work either in department 70 or 90. Return full name (first and last name), department id. 11. write a SQL query to find those employees who work...

Q:

Please Answer the following 1. Consider the AIRLINE relational database schema and some sample data given in APPENDIX A. The schema describes a database for airline flight information. Each flight is...

Q:

1. Consider the AIRLINE relational database schema and some sample data given in APPENDIX A. The schema describes a database for airline flight information. Each flight is identified by a...

Q:

This chapter on capital markets focuses on long-term financing and the various stock markets. Each stock market has its own listing requirements and this exercise will look at the New York Stock...

Q:

Consider a teal, causal sequence x[n] with discrete-time Fourier transform X(e j? ) = X R (e j? ) + jX I (e j? ). The imaginary part of the discrete-time Fourier transform is? X I (e j? ) = 3...

Q:

ANSWER Easton Company deposits all cash receipts on the day they are received and makes all cash payments by check. At the close of business on June 30, its Cach account shows a debit belence of...

Q:

An activity in a network diagram has an optimistic time estimate of five days, a most likely time estimate of seven days, and a pessimistic time estimate of 15 days. Its expected time is _____________