Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello, this question is for Oracle SQL. Table: Employees Employee First Name Id Dept Code Credit Limit Phone Manager-id Ext Last_Name Hire_Date 201 202 203

Hello, this question is for Oracle SQL.image text in transcribed

Table: Employees Employee First Name Id Dept Code Credit Limit Phone Manager-id Ext Last_Name Hire_Date 201 202 203 204 205 206 207 208 209 210 Susan 1m Martha Ellen Hen Caro Dan Fred Paula Nancy 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 201 201 202 203 201 #6. From the Employees table, get the department and credit limits for the employees "Jim Kern. List the department and phone extension for all the employees who don't have a manager. Sort the rows by the employee id

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeffrey A. Hoffer Fred R. McFadden

9th Edition

B01JXPZ7AK, 9780805360479

More Books

Students also viewed these Databases questions

Question

=+nk so that p( B(k)) Answered: 1 week ago

Answered: 1 week ago

Question

Connect with your audience

Answered: 1 week ago