$2.$ For every customer, list the customer number, the customer entire zip code, and add $$two more$$columns where the next column is the first $2$ numbers of the zip code, and the last column is the$$last $3$ numbers of the zip code.$$

$3.$ For every sales rep, list their street, their city and determine the length of the characters of the$$sales rep$$s City. The data should be sorted by City.$$

$4.$ For every part description that begins with the letter $$a$,$ list the part description, and then pad$$each part description with a $+$on the left side so that all these part descriptions are $15$characters in length.$$

$5.$ For every part number, list the part number and then right trim of the numbers from the part$$number that are on the right side of the part number.$$