Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Hello, this question is for Oracle SQL. Table: Employees Employee First Name Id

ID: 3874087 • Letter: H

Question

Hello, this question is for Oracle SQL.

Table: Employees Employee First Name Id Last Name Dept Hire Date Code Credit Limit Phone Manager_.id Ext 201 202 203 204 205 206 207 208 209 210 Susan im Martha Ellen Hen Caro Dan Fred Paula Nancy Brown Kern Woods Owens Perkins Rose Smith 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 ull $25.00 $30.00 $15.00 $25.00 3484 (null) 8722 7591 201 6830 202 5286 202 nul1 (null1 2259 203 1752 203 3357 201 2974 203 201 Campbe11 Jacobs Hoffman Shp Mkt sal Task#6 : Find out in which month the employee -Carol Rose joined

Explanation / Answer

6)

select hire_date

from employees

where first_name="carol" AND Last_name="rose";