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

Transcribed Image Text:

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