Unit 3 Assignment 1 Directions Perform the following tasks below by using the co

Question

Unit 3 Assignment 1
Directions
Perform the following tasks below by using the correct SQL statements. Create the statements in Oracle by using the following steps (SQL > SQL commands > Enter Command). Once your command is error-free, copy and paste your statements into this assignment document. Upload this Word document for grading.

9. From the l_employees table, list all the different combinations of dept_code and credit_limit. Count the number of employees who are in each of these categories. Sort the rows by dept_code and then by credit_limit. Exclude the ‘SHP’ department in your results. Show only the dept_code, with a credit limit of over 12.50.

Explanation / Answer

Dear... 9. SELECT DISTINCT dept_code, COUNT( credit_limit ) FROM l_employees WHERE dept_code IN (x, y, z,..) AND credit_limit >= 12.50 ORDER BY dept_code, credit_limit exclude SHP.

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.