1. Use INSTR to find
the position of character ‘a’ in the doctor’s name.
2. CONCAT the
patients’ first and last name and display their DOB in the following format
‘DD, Month YYYY’. Sort the patients’ name alphabetically.
PATNAME
NEWDOB
Allen Mcginnis
3, May 1959
Anthony Rogers
7, December 2041
Becky Roach
8, September 1975
...
Pending
Other
/
Other
29 Mar 2021
