need help on this SQL problem. Thank you!

Write ONE SQL statement which uses the SUBSTR function (as many times as you need to) to extract the following three words: ‘I’, ‘am’, ‘here’ from the string

‘Where am I?’ and put the three words together using a combination of the CONCAT function and the ||. 

 

E.g. The starting string used in the SQL statement is:  ‘Where am I?’

 

       The output of the SQL statement after we run it will be:

 

TRANS

----------

I am here