The following programs demonstrate the use of the FIRST FROM clause. The programs find the first record in the JOBS relation with the value "Company President" in the field JOB_TITLE. Using this record's value for JOB_CODE, these programs create a record stream containing the records in the CURRENT_JOB relation that have this same job code. The programs print the value that the first record from this record stream holds in the LAST_NAME field.Additional Information: explode extract