CREATE VIEW phone_list (name, phone)
    AS SELECT lastname || ', ' || firstname,
              '(' || area_code || ')-'
              || SUBSTR(phone_number,1,3) || '-'
              || SUBSTR(phone_number,4)
         FROM person
/
