All pastes #102372 Raw Edit

Stuff

public text v1 · immutable
#102372 ·published 2006-07-27 16:03 UTC
rendered paste body
 1) Display the employee’s initial of first name, last name, id, department id and salary rounded to the nearest thousand for each employee in departments 10 or 110 who have been employed more than 5 years and for each employee whose last name contains more than 5 letters or contains more than 1 e sorted by the length of their first and last name combined, with the longest name displayed first, using the format J. Smith, employee 123 of dept 10 earns $99,000.