The following programs demonstrate the use of the REDUCED TO
    clause and the SORTED clause with a single relation. These
    programs sort the records in the EMPLOYEES relation on the basis
    of STATE. The REDUCED TO clause limits the record stream so that
    each record in the stream has a different value for the field
    STATE. The programs then display the list of states represented
    in the EMPLOYEES relation.