CUSTOMER PK CUS_CODE CUST_FNAME CUST_LNAME CUS STREET_No CUS STREEET_NAME CUS CITY CUS ZIP CUS_BALANCE places INVOICE ITEM INVOICE PK ITEM_ID PK INV NUM FK INV_NUM FK CUS CODE FK PRODUCT ID INV DATE...

1. Write a query to display the first name, last name, phone number, title, and department number of employees who work in department 123 and have the title “Assistant.”

1. Write a query to display the employee number, last name, first name, salary “from” date, salary end date, and salary amount for employees 99675, 53845, and 44035. Sort the output by employee number and salary “from” date.

Extracted text: CUSTOMER PK CUS_CODE CUST_FNAME CUST_LNAME CUS STREET_No CUS STREEET_NAME CUS CITY CUS ZIP CUS_BALANCE places INVOICE ITEM INVOICE PK ITEM_ID PK INV NUM FK INV_NUM FK CUS CODE FK PRODUCT ID INV DATE has PROD_PRICE INV_TOTAL PRODUCT_NAME FK EMP NUM contains completes EMPLOYEE PRODU CT PK EMP_NUM PK PRODUCT_ID EMP_FNAME PRODUCT_DESCRIPTION EMP LNAME PROD_TYPE EMP EMAIL PROD_BASE EMP_PHONE PROD_CATEGORY EMP H IREDATE FK BRAND_ID EMP TITLE EMP_COMMIS ION belongsto SAL_AMOUNT BRAND FK DEPT_NUM PK BRAND ID employs BRAND NAME DEPARTMENT BRAND TYPE PK DEPT NUM DEPT_NAME provided by DEPT ADDRESS DEPT PHONE VENDOR STOCK PK STOCK ID VENDOR FK VEND ID PK VEND ID FK PRODUCT_ ID VEND NAME PROD_QTY_ON HAND VEND STREET NO %23 has VEND STREET_NAME VEND CTY VEND STATE VEND ZIP