/* nesting one function within another function */

/* Output the first 20 characters of the combined lastname/firstname */

SELECT student_id, SUBSTR( CONCAT(lname, fname),  1, 20)
FROM   student;


/* Output the last 10 characters of description */

SELECT course_id, SUBSTR( description, LENGTH(description) -10)
FROM   course;