Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Hello, this is for Oracle SQL, please upload a screenshot of the working code. Table: Employees Last Name Dept Code Employee First Name t Hire

Hello, this is for Oracle SQL, please upload a screenshot of the working code.

image text in transcribed

Table: Employees Last Name Dept Code Employee First Name t Hire Date Credit Limit Phone Manager_id 201 202 203 204 205 206 207 208 209 210 Susan Jim Martha Ellen Hen Caro Dan Fred Paula Nancy Brown Kern Woods Owens Perkins Rose Smith Campbel1 Jacobs Hoffman Exe Sal Sh Sa Sal Act 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 nul1 $25.00 $30.00 $15.00 $25.00 3484 (null) 8722 201 7591 6830 5286 nul1 (nul1 2259203 1752 203 3357 201 2974 201 202 202 Shp Sal 203 #1. List the following columns of the Employees table in this order: first name, last name, hire date, phone_ext and department code Change the name of the hire date column to Date_of Joining within the result table. List the employees from the Sales and Marketing department on ly. Sort the rows of the result table by the last name column in descending order

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Databases questions