Answered step by step
Verified Expert Solution
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 managEMPNUM EMPTITLE EMPLNAME EMPFNAME EMPINITIAL EMPDOB EMPHIREDATE EMPAREACODE EMPPHONE EMPMGR
Mr Kolmycz George D JUNMAR
Ms Lewis Rhonda G MARAPR
Mr Vandam Rhett NOVDEC
Ms Jones Anne M OCTAUG
Mr Williams Robert D MARNOV
Mr Lange John P NOVOCT
Mrs Smith Jeanine K FEBJAN
Mr Diantee Jorge D AUGJUL
Mr Wymer Paul R FEBNOV
Mr Smith George JUNAPR
Mrs Genkazi Leighla W MAYDEC
Mr Washington Rupert E JANJUN
Mr Johnson Edward E MAYDEC
Ms Smythe Melanie P SEPMAY
Ms Brandon Marie G NOVNOV
Mrs Saranda Hermine R JULAPR
Mr Smith Michael A NOVDECe others ie EMPMGR field is null
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started