Question: 4. (25 points) Write an SQL statement to display the very middle character of their first names for all employees whose first names have

4. (25 points) Write an SQL statement to display the very middle character of their first names for all employees whose first names have odd number characters (e.g., 3, 5, 7, etc.). The titles of the two displayed columns are "First Name" and "Middle Character of First Name". No special sorting needed. First Name Middle Character of First Name 1 Neena 2 Lex e 3 Alexander a 4 Bruce 5 Diana a 6 Kevin V 7 Randall d 8 Peter t 9 Eleni e 10 Ellen 1 11 Kimberely e 12 Michael h 13 Pat a 14 Shelley 1 15 William 1
Step by Step Solution
There are 3 Steps involved in it
To display the very middle character of the first names for employees whose first names have ... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (2 attachments)
663dedab927d4_960974.pdf
180 KBs PDF File
663dedab927d4_960974.docx
120 KBs Word File
