Sticky-note

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;