Given the data set WORK.EMPDATA:
Which one of the following where statements would display observations with job titles containing the word ‘Manager’?
A. where substr(Job_Title,(length(Job_Title)-6))=’Manager’;
B. where upcase(scan(Job_Title,-1,’ ‘))=’MANAGER’;
C. where Job_Title=’% Manager ‘;
D. where Job_Title like ‘%Manager%’;