Lemployees Table List Different Combinations Deptcode Creditlimit Count Number Employees C Q43825493
From the l_employees table, list all the different combinationsof dept_code and credit_limit. Count the number of employees whoare in each of these categories. Sort the rows by dept_code andthen by credit_limit. Exclude the ‘SHP’ department in your results.Show only the dept_code, with a credit limit of over 12.50. Showyour sql below.
Show me code step by step and or take screenshots of code andrun test.
Expert Answer
Answer to From the l_employees table, list all the different combinations of dept_code and credit_limit. Count the number of emplo…
OR