Exercise ( Use SQL Functions )

1. Display the following text in lowercase ‘DISPLAY EXAMPLE IN LOWERCASE’
2. Display the following text in uppercase ‘you are great’.
3. Write a select statement to add 123 and 786.
4. What is the length of ‘CURRENT’ string.
5. Display the current username.
6. Display ‘DOCTOR’ from ‘JOHN IS A DOCTOR’ string.
7. Display Day of 'July-10-1998'
8. Display number of days till today from your date of birth.
9. Display the date after 18 months from today.
10. Display employee information if employee id is an even number