Question: 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
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 last name and then by first name (Figure P7.30).

Figure P7.30 Clerks and Employees in Department 300 EMP_FNAME EMP_LNAME EMP_PHONE ACEVEDO 862-6787 AVERY 550-2270 BAKER 632-8197 CARPENTER 735-4820 616-9615 449-6336 525-2101 LAVINA LAUREN ROSALBA FERN LEEANN TANIKA SAMMY LANA CLINTON CRANE DIGGS DOWDY STEPHAINE DUNLAP FISHER GOOD HORN HAL LINDSAY LEEANN 471-8795 618-8203 676-3662 337-9570 828-4361 EMP_TITLE ASSOCIATE SENIOR ASSOCIATE ASSOCIATE PURCHASING SPECIALIST CLERKI PURCHASING SPECIALIST SENIOR ASSOCIATE SENIOR ASSOCIATE BUYER RAW MATERIALS SENIOR ASSOCIATE CLERK I SENIOR ASSOCIATE DEPT_NUM 300 300 300 300 600 300 300 300 300 300 600 300
Step by Step Solution
3.43 Rating (159 Votes )
There are 3 Steps involved in it
To display the first name last name phone number title and department number of employees ... View full answer
Get step-by-step solutions from verified subject matter experts
