#1 Write a SELECT statement to list the last names of instructors, where a last name contains no more than seven characters.

#2 Write a SELECT statement to list each students last name, followed by a comma and a space, followed by the students frst name, all in a single column in the result set.

#3 Write a SELECT statement that changes the phrase Today is Monday to Today is Tuesday

#4 What is the DUAL table? Does it belong to the STUDENT schema?

#5 A calculation with a null always yields another null; which function can be used to avoid such a case?