Question: Write a query to display the employee number, last name, e-mail address, title, and department name of each employee whose job title ends in the

Write a query to display the employee number, last name, e-mail address, title, and department name of each employee whose job title ends in the word €œASSOCIATE.€ Sort the output by department name and employeetitle.

EMP NUM EMP LNAME ! EMP EMAIL EMP TITLE I DEPT NAME 84526 LASSITER F. LASSITB@LGCOMPANY.COM ASSOCIATE 83517 ALBRIGHT SO 84386 RIVERA 83378 DUNHAMF 83583 ROLLINS 83661 FINN ACCOUNTING ACCOUNTING ACCOUNTING ACCOUNTING ACCOUNTING ACCOUNTING CUSTOMER SERVICE CUSTOMER SERVICE CUSTOMER SERVICE CUSTOMER SERVICE CUSTOMER SERVICE CUSTOMER SERVICE ALBRI96@LGCOMPANY COM ASSOCIATE D RIVERA76@LGCOMPANY COM ASSOCIATE F.DUNHAME@LGCOMPANY COM ASSOCIATE M.ROLLIN99@LGCOMPANY COM ASSOCIATE D.FINN7LGCOMPANY.COM ASSOCIATE 4383 WASHINGTON LWASHINSBOLGCOMPANY COM ASSOCIATE 84206 HEALY 83451 ELLIS 84442 GREGORY A GREGOR95@LGCOMPANY COM ASSOCIATE 84459 GILLIAM 84300 SEAY N. HEALY82@LGCOMPANY.COM ASSOCIATE R.ELLIS81@LGCOMPANY.COM ASSOCIATE E.GILLIA10@LGCOMPANY COM ASSOCIATE A SEAY75@LGCOMPANY COM ASSOCIATE

Step by Step Solution

★★★★★

3.36 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

SELECT EEMPNUM EMPLNAME EMPEMAIL E... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

358-CS-DB (695).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Write a query to display the employee number, first name, last name, and largest salary amount for each employee in department 200. Sort the output by largest salary in descendingorder. EMP NUM EMP...

Write a query to display the brand ID, brand name, and average price of products of each brand. Sort the output by brand name. (Results are shown with the average price rounded to two decimalplaces.)...

Write a query to display the customer code, first name, last name, and sum of all invoice totals for customers with cumulative invoice totals greater than $1,500. Sort the output by the sum of...

Write a query to display the employee number, last name, email address, title, and department name of each employee whose job title ends in the word ASSOCIATE . Sort the output by department name,...

Write a query to display the employee number, last name, email address, title, and department name of each employee whose job title ends in the word ASSOCIATE. Sort the output by department name,...

Fl Write a query to display the employee number, last name, email address, title, and department name of each employee whose job title ends in the word " ASSOCIATE ." Sort the output by department...

Write a query to display the employee number, last name, first name, department name and department address for employees number 103, 160, 195 and 297. Sort the output by employee number and last...

SQL CODE: https://gist.githubusercontent.com/GistMasterPro/3893fe6d62ae301e85265a7f0ceafad4/raw/40fe8193dd74c39a56724d8eda2d445e41bc58c7/SQL.sql 30. Write a query to display the first name, last...

SQL CODE: https://gist.githubusercontent.com/GistMasterPro/3893fe6d62ae301e85265a7f0ceafad4/raw/40fe8193dd74c39a56724d8eda2d445e41bc58c7/SQL.sql OR...

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

When planning an audit, the auditors should assess the levels of risk and materiality for the engagement. Explain how the auditors judgments about these two factors affect the auditors planned audit...

Perform a x2 test on the following data: a. Regulation is the best way to ensure safe products. b. Ownership ofresidence No 20 14 Male 25 16

odds ( 2 5 points ) Write a function odds that returns the odd numbers contained in a 2 - dimensional list of numbers. Details: accepts a single argument, a 2 - dimensional list of positive integers...

Firms regularly use insurance as a means of managing their risk exposure. What are some of the types of risks that are typically transferred to insurance companies through the use of insurance...

Write a query to display the book number, title, and year of all books published after 2015 and on the Programming subject, sorted by book number (Figure P7.68). Figure P7.68 Newer Books on...

Write a query to display the checkout number, book number, and checkout date of all books checked out before April 5, 2021 sorted by checkout number (Figure P7.67). Figure P7.67 Checkouts before...

Write a query to display the book number, title, and replacement cost for all books in the Database subject sorted by book number (Figure P7.66). Figure P7.66 Database Books BOOK NUM BOOK_TITLE 5237...

Question 9 One year ago, the Jenkins Family Fun Center deposited $6,780 in an investment account for the purpose of buying new equipment four years from today. Today, they are adding another $5,559...

Which of the following statements is CORRECT? If an investor buys enough stocks, he or she can, through diversification, eliminate all of the diversifiable risk inherent in owning stocks. Therefore,...

A drugstore manager needs to purchase adequate supplies of various brands of toothpaste to meet the ongoing demands of its customers. In particular, the company is interested in estimating the...