Subset the query and sort the output. The WHERE clause uses the SOUNDS-LIKE operator to subset the table by those employees whose last name sounds like Johnson . The ORDER BY clause orders the output by the second column.

      where lname=*"Johnson"
      order by 2;