Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Display the full names of employees ( including title and initial ) who do not manage other employees, ordered by last name in descending order

Display the full names of employees (including title and initial) who do not manage other employees, ordered by last name in descending order then first name in ascending order. Only include male employees (Mr.) whose last names begin with an S in your query. Dont forget to include the title, initial, first name, and last name and look at the data given to determine how to designate those employees who managEMP_NUM EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP_DOB EMP_HIRE_DATE EMP_AREACODE EMP_PHONE EMP_MGR
100 Mr. Kolmycz George D 15-JUN-194215-MAR-1985615324-5456-
101 Ms. Lewis Rhonda G 19-MAR-196525-APR-1986615324-4472100
102 Mr. Vandam Rhett -14-NOV-195820-DEC-1990901675-8993100
103 Ms. Jones Anne M 16-OCT-197428-AUG-1994615898-3456100
105 Mr. Williams Robert D 14-MAR-197508-NOV-1998615890-3220-
104 Mr. Lange John P 08-NOV-197120-OCT-1994901504-4430105
106 Mrs. Smith Jeanine K 12-FEB-196805-JAN-1989615324-7883105
107 Mr. Diantee Jorge D 21-AUG-197402-JUL-1994615890-4567105
108 Mr. Wymer Paul R 14-FEB-196618-NOV-1992615897-4358-
109 Mr. Smith George -18-JUN-196114-APR-1989901504-3339108
110 Mrs. Genkazi Leighla W 19-MAY-197001-DEC-1990901569-0093108
111 Mr. Washington Rupert E 03-JAN-196621-JUN-1993615890-4925105
112 Mr. Johnson Edward E 14-MAY-196101-DEC-1983615898-4387100
113 Ms. Smythe Melanie P 15-SEP-197011-MAY-1999615324-9006105
114 Ms. Brandon Marie G 02-NOV-195615-NOV-1979901882-0845108
115 Mrs. Saranda Hermine R 25-JUL-197223-APR-1993615324-5505105
116 Mr. Smith Michael A 08-NOV-196510-DEC-1988615890-2984108e others (i.e., EMP_MGR field is null).

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

Databases Illuminated

Authors: Catherine M Ricardo, Susan D Urban

3rd Edition

1284056945, 9781284056945

More Books

Students also viewed these Databases questions

Question

2. Follow through with fair consequences.

Answered: 1 week ago

Question

What are the ethical scrutiny requirements of your centre?

Answered: 1 week ago