4. (25 points) Write an SQL statement to display the very middle character of their first...

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

To display the very middle character of the first names for employees whose first names have ... View the full answer