Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hello, this question is for Oracle SQL Table: Employees Employee First Name Dept Code Credit Limit Phone Manager-id Ext Last_Name Hire_Date 201 202 203 204
Hello, this question is for Oracle SQL
Table: Employees Employee First Name Dept Code Credit Limit Phone Manager-id Ext Last_Name Hire_Date 201 202 203 204 205 206 207 208 209 210 Brown Kern Woods Owens Perkins Rose Smith Campbel1 Jacobs Hoffman Exe Sal Sh Sa Sal Act Shp Shp Mkt Sal 01-Jun-1998 16-Aug-1999 02-Feb-2004 01-Jul-2003 01-Mar-2000 null 01-Dec-2004 01-Apr-2003 17-Mar-1999 16-Feb-2004 $30.00 $25.00 $25.00 $15.00 $25.00 null $25.00 $30.00 S15.00 S25.00 3484 (null) 8722 7591 6830 5286 202 null (ul) 2259 1752 203 3357 2974 203 Susan 1m Martha 201 201 202 en Hen Caro Dan Fred Paula Nancy 203 201 #4 . Using the Employees table, list the following columns: dept_code, credit limit, last name, first_name Place the columns in that order. Sort the rows by dept_code in ascending order credit limit in descending order last_name in ascending order And get only those employees who are having credit limits between 20 and 40Step 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