Question: For this work, you'll need to use the EMP table, which is available in Saleco database. Please see below columns and some sample data in

For this work, you'll need to use the EMP table,

For this work, you'll need to use the EMP table, which is available in Saleco database. Please see below columns and some sample data in this table: 1 SELECT * FROM emp; EMP_NUM EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP_DOB EMP_HIRE_DATE EMP_PHONE EMP_MGR 100 Kolmycz George 15-JUN-42 15-MAR-85 EMP_AREACODE 615 615 901 101 Lewis Rhonda 324-5456 324-4472 675-8993 100 Vandan Rhett 19-MAR-65 14-NOV-58 16-OCT-74 08-NOV-71 25-APR-86 20-DEC-90 28-AUG-94 20-OCT-94 100 100 Jones Anne 898-3456 104 Lange John 981 504-4430 105 (Query #1) Write an SQL statement to display full name of employees supervised by the manager whose ID is 105. Note that full name includes first name, a space, and last name. Also note the caption/heading of the query output. Sample query output is shown below for your guidance. Employees Supervided By Manager 105 Hermine Saranda Jeanine Smith John Lange Jorge Diante Melanie Smythe (Query #2) Write an SQL statement to display manager ID, and the number of employees (i.e., how many employees) each manager supervises. Partial query output is shown below for your guidance. You should show complete SQL statement, and complete output of the statement, and your email in the screenshot. Also note the column headings/captions. Sort the output so the manager who supervises most employees should be listed at the top. Manager Supervises this many employees 105 100

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!