Question7.8.9.10

CUTOMERS Oracle SQL Developer : Table Ex.CUSTOMERS@ex File Edit View Navigate Run Team Tools Window Help Connections Start Page D CUSTOMERS - BY Columns Data Constraints Grants Statistics Inggers Flashback Dependencies Detals Partitions Indexes ISOL #COLOR_SAMPL X Sort.. Filter: COURSES RM CUSTOMER ID CUSTOMER LAST NAME CUSTOMER_FIRST_NAME CUSTOMER_ADDRESS CUSTOMER_CITY CUSTOMER STATE CUSTOMER_ZIP + CUSTOMERS 1 # DATE_SAMPLE 1 Anders Maria 345 Winchel... Anderson IN 46014 + DEPARTMENTS 4 2 Trujillo Ana 1298 E Smat... Benton AR 72018 ) 3 Moreno Antonio 6925 N Park... Puyallup WA 98373 Reports 4 Hardy Thomas 83 d'Urberv... Casterbridge GA 5 Cindy 22717 E 73r... Dubuque All Reports IA 52004 Data Dictionary Re 6MOOS 1778 N Bovi... Peoria IL 61638 te Data Modeler Rep 7 7 Citeaux Fred 1234 Main St Normal IL 61761 # DOLAP Reports 8 Amy 1877 Ete Ct Frogtown LA 70563 # B TimesTen Reports 9 9 Lebihan 717 E Michi... Chicago IL 60611 Il rafins a 31209 -Actions... CUSTOMER PHONE (765) 555-7878 (501) 555-7733 (253) 555-8332 (478) 555-1139 (319) 555-1139 (309) 555-8755 (309) 555-1914 (337) 555-9441 (312) 555-9441 b Smith Hanna Capone Laurence (3 pts) 1. Retrieve the employee ids, first and last names who work for department number 2 wanger 2. Retrieve first and last name of the employee whose id 5; display result in sorted order by last name 3. Retrieve first & last names of the employees and department names who work for an Payroll and Operations' departments (3 pts (spt 4. Retrieve first & last names of the employees and project numbers they are working on for manager whose id is 5 (5 5. Retrieve first & last names of the employees, department names they are working for and project numbers they are working on 6. Retrieve fist & last names of the customers, city and state names who DO NOT live in San Francisco and "Chicago in sorted order by last name 7. Retrieve fist & last names and phone number of all the customers whose area code is '309 8. Display number of all available departments 9. Display number of the employees working for Payroll' department 10. Retrieve the highest and lowest salary amounts for all male employees actate