Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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.
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. Show your sql below.
Show me code step by step and or take screenshots of code and run test.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started