1. 2. 3. 4. 5. 6. For every sales rep, list the sales rep's last name...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. 2. 3. 4. 5. 6. For every sales rep, list the sales rep's last name and the sales rep's first name in lower case letters. For every customer, list the customer's last name and the customer's first name in upper case letters. 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. For every sales rep, list their street, and determine the length of the characters of the sales rep's Street. For every part description that begins with the letter "b", 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. For every part description that begins with the letter "g", list the part description, and then pad each part description with a "-"on the right side so that all these part descriptions are 15 characters in length. 7. 8. 9. 10. 11. 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. For every sales rep, list the sales rep's last name and then the sales rep's first name, then concatenate the text Sales rep number: followed by the sales rep number. For every customer, list the customer number, the customer balance, and then round the customer balance up to the next whole dollar amount. For every customer, list the customer number, the customer balance, and then truncate the customer balance to its whole dollar amount. For every order, list the order number and the order date, use the To Char to convert the order date from all numbers to a month name, a day, and a year format. SLSR SLSR SLSR SLSR SALES LAST FIRST STREET REP NUMBE R (PK) 03 06 12 CUST CUST CUSTOMER LAST NUMBER (PK) 124 239 256 311 315 405 412 522 567 587 622 Jones 123 Main Mary Smith William 102 Raymond Diaz Miguel 419 Harper BZ66 CA14 CB03 CX11 CZ81 CUST CUST FIRST Adams Sally (Yours) (Yours) Samuels Ann Charles Don Daniels Tom Williams Al Adams Sally Nelson Mary Dinah Tran Galvin Mara Martins Dan PART Iron Dartboard Basketball Corn Popper Gas Grill SALES REP SLSR_ SLSR SLSR SLSR CITY STATE ZIP TOTAL Washer Griddle Bike Blender Treadmill CUSTOMER CUST STREET CITY PART PART NUMBER PART_DESCRIPTION (PK) AX12 AZ52 BA74 BH22 BT04 481 Oak 239 Drive Grant MI Ada MI Lansing MI 215 Pete 48 College 914 Cherry 519 Watson 16 Elm 108 Pine 808 Ridge 512 Pine 419 Chip 104 20 40 95 11 Grant Ira PART 52 78 44 112 68 MI CU CUST CUST CUST ST ZIP BALAN CREDIT STA COD CE TE _LIMIT Lansing MI 49224 818.75 Edison MI 08818 1000.00 MI Kent MI Grant MI Lansing MI Ada Harper Ada Grant SLSR COMM CODE COMMISSION ISSION_ RATE 49219 49441 49224 E 49219 49034 AP HW SG HW SG 48391 49219 PART UNITS ON ITEM HAND CLASS HW SG SG HW AP MI 49441 PART PART 49224 1817.50 98.75 MI 48421 402.40 MI 49441 114.60 MI 49219 1045.75 2150.00 4912.50 2150.00 3 2 1 3 2 3 21.50 825.75 WAREHOUSE NUMBER 3 1 3 2 770.75 402.75 1000 3000 1500 1000 750 1500 2000 1500 750 1000 1000 CUST SALES REP NUM BER .05 .07 .05 PART UNIT_PRICE 24.95 12.95 29.95 24.95 149.99 399.99 39.99 299.99 22.95 349.95 03 12 06 12 06 12 03 12 06 06 03 12491 12491 12494 12495 12498 12498 12500 ORDR 12504 12507 ORDER_NUMBER (PK) 12489 12491 12494 12495 12498 12500 12504 12507 BT04 BZ66 CB03 CX11 AZ52 BA74 BT04 ORDERS ORLN ORLN ORLN ORLN ORDER NUMBER (PK) PART NUMBER (PK) NUMBER ORDERED QUOTED PRICE 12489 AX12 21.95 149.99 399.99 279.99 22.95 12.95 24.95 149.99 CZ81 CB03 ORDR ORDER_DATE CUSTOMER_NUMBER 09/02/2018 09/02/2018 09/04/2018 09/04/2018 09/05/2018 09/05/2018 09/05/2018 09/22/2018 ORDER LINE 11 1 1 ORDR 4 2 2 4 1 2 1 124 311 315 256 522 124 522 239 325.99 299.99 1. 2. 3. 4. 5. 6. For every sales rep, list the sales rep's last name and the sales rep's first name in lower case letters. For every customer, list the customer's last name and the customer's first name in upper case letters. 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. For every sales rep, list their street, and determine the length of the characters of the sales rep's Street. For every part description that begins with the letter "b", 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. For every part description that begins with the letter "g", list the part description, and then pad each part description with a "-"on the right side so that all these part descriptions are 15 characters in length. 7. 8. 9. 10. 11. 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. For every sales rep, list the sales rep's last name and then the sales rep's first name, then concatenate the text Sales rep number: followed by the sales rep number. For every customer, list the customer number, the customer balance, and then round the customer balance up to the next whole dollar amount. For every customer, list the customer number, the customer balance, and then truncate the customer balance to its whole dollar amount. For every order, list the order number and the order date, use the To Char to convert the order date from all numbers to a month name, a day, and a year format. SLSR SLSR SLSR SLSR SALES LAST FIRST STREET REP NUMBE R (PK) 03 06 12 CUST CUST CUSTOMER LAST NUMBER (PK) 124 239 256 311 315 405 412 522 567 587 622 Jones 123 Main Mary Smith William 102 Raymond Diaz Miguel 419 Harper BZ66 CA14 CB03 CX11 CZ81 CUST CUST FIRST Adams Sally (Yours) (Yours) Samuels Ann Charles Don Daniels Tom Williams Al Adams Sally Nelson Mary Dinah Tran Galvin Mara Martins Dan PART Iron Dartboard Basketball Corn Popper Gas Grill SALES REP SLSR_ SLSR SLSR SLSR CITY STATE ZIP TOTAL Washer Griddle Bike Blender Treadmill CUSTOMER CUST STREET CITY PART PART NUMBER PART_DESCRIPTION (PK) AX12 AZ52 BA74 BH22 BT04 481 Oak 239 Drive Grant MI Ada MI Lansing MI 215 Pete 48 College 914 Cherry 519 Watson 16 Elm 108 Pine 808 Ridge 512 Pine 419 Chip 104 20 40 95 11 Grant Ira PART 52 78 44 112 68 MI CU CUST CUST CUST ST ZIP BALAN CREDIT STA COD CE TE _LIMIT Lansing MI 49224 818.75 Edison MI 08818 1000.00 MI Kent MI Grant MI Lansing MI Ada Harper Ada Grant SLSR COMM CODE COMMISSION ISSION_ RATE 49219 49441 49224 E 49219 49034 AP HW SG HW SG 48391 49219 PART UNITS ON ITEM HAND CLASS HW SG SG HW AP MI 49441 PART PART 49224 1817.50 98.75 MI 48421 402.40 MI 49441 114.60 MI 49219 1045.75 2150.00 4912.50 2150.00 3 2 1 3 2 3 21.50 825.75 WAREHOUSE NUMBER 3 1 3 2 770.75 402.75 1000 3000 1500 1000 750 1500 2000 1500 750 1000 1000 CUST SALES REP NUM BER .05 .07 .05 PART UNIT_PRICE 24.95 12.95 29.95 24.95 149.99 399.99 39.99 299.99 22.95 349.95 03 12 06 12 06 12 03 12 06 06 03 12491 12491 12494 12495 12498 12498 12500 ORDR 12504 12507 ORDER_NUMBER (PK) 12489 12491 12494 12495 12498 12500 12504 12507 BT04 BZ66 CB03 CX11 AZ52 BA74 BT04 ORDERS ORLN ORLN ORLN ORLN ORDER NUMBER (PK) PART NUMBER (PK) NUMBER ORDERED QUOTED PRICE 12489 AX12 21.95 149.99 399.99 279.99 22.95 12.95 24.95 149.99 CZ81 CB03 ORDR ORDER_DATE CUSTOMER_NUMBER 09/02/2018 09/02/2018 09/04/2018 09/04/2018 09/05/2018 09/05/2018 09/05/2018 09/22/2018 ORDER LINE 11 1 1 ORDR 4 2 2 4 1 2 1 124 311 315 256 522 124 522 239 325.99 299.99
Expert Answer:
Answer rating: 100% (QA)
To perform the requested operations lets start by organizing the given data into tables Based on the provided information we can create four tables Sales Rep Customer Part and Order Sales Rep Table SL... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Add two more columns called Download Time per MB (Fast Broadband) and Download Time per MB (Regular Broadband). Compute these values by dividing the appropriate download time by the file size in MB,...
-
A square wood column with side dimensions b (see figure) is constructed of a structural grade of Douglas fir for which Fc = 1,700 psi and E = 1,400,000 psi. An axial force P = 40 k acts on the...
-
For the determinant (13.112), add column 1 to column 3 and add column 2 to column 4. Show that the result is equal to In this determinant, subtract column 3 from column 1 and subtract column 4 from...
-
Chiz enterprise reports its gross sales/receipts during the quarter as follows: Sale of computers Gross receipts - computer repairs Sales returns and allowances Sales discounts for early payments...
-
Can the annual new orders for manufacturing in the United States be predicted by the raw steel production in the United States? Shown below are the annual new orders for 10 years according to the...
-
Once you have separated the three salts in Study Question 111 into three test tubes, you now need to confirm their presence. (a) For Pb 2+ ion, one way to do this is to treat a precipitate of PbCl 2...
-
If the 60-mm diameter shaft is subjected to an axial force of 5 kN, determine the average shear stress developed in the shear plane where the collar A and shaft are connected. 5 kN 60 mm 100 mm 2.5...
-
The Ferguson Paper Company produces rolls of paper for use in adding machines, desk calculators, and cash registers. The rolls, which are 200 feet long, are produced in widths of 11/2, 21/2, and 31/2...
-
After reviewing the Specialty Guidelines for Forensic Psychology (2013), please select one of the 11 domains (i.e. responsibilities, competence, etc.) that you could see leading to ethical problems...
-
The three forces are applied to the bracket. Determine the range of values for the magnitude of force P so that the resultant of the three forces does not exceed 2400 N. 3000 N 90%- Prob. 2-38 800 N...
-
Determine the internal reactions at Point E in the beam. Note that there is a hinge at Point C, but not at Point E. Point E is located halfway between points A and B. The support at A is able to...
-
Initially there is no magnetic flux through a conducting loop. A magnetic field near the loop is then suddenly turned on, and \(5.0 \mathrm{~s}\) later the magnetic flux through the loop is \(1.0...
-
What do you hope to gain from this course on development economics?
-
The following are the average daily reported share volumes traded on the NYSE, in thousands, for the years listed: (a) Calculate the mean and median share volume for these observations. (b) Calculate...
-
Since Brees statements, national anthem protests have continued within American sport. How have other star athletes navigated the challenging debate surrounding this action? What might they have...
-
Some scholars argue that sport is an inherently aggressive environment, and trash talking is a natural part of the competitive landscape. Where do you stand on this issue? Does your stance differ...
-
In a construction 3D printing project, we use a gantry printer with a printing speed of 120mm/s. The nozzle traveling distance (including the openings) per layer is 72 meters, and the height of the...
-
Compile data on consumption and expenditures for the following categories in 30 different countries: (1) food and beverages, (2) clothing and footwear, (3) housing and home operations, (4) household...
-
Fill in the blanks. a. A 2-curve is ________ skewed. b. A 2-curve looks increasingly like a ________ curve as the number of degrees of freedom becomes larger.
-
Iron Deficiency? Iron is essential to most life forms and to normal human physiology. It is an integral part of many proteins and enzymes that maintain good health. Recommendations for iron are...
-
During one year, Malaysia was the site of an encephalitis outbreak caused by the Nipah virus, a paramyxovirus that appears to spread from pigs to workers on pig farms. As reported by K. Goh et al. in...
-
Suppose you increase the gauge pressure in the tires of your car by \(10 \%\). (a) How does the area of the tires in contact with a level road change? (b) If the gauge pressure in the tires is \(2.0...
-
In a service station's hydraulic lift, the diameter of the large piston is \(200 \mathrm{~mm}\) and the diameter of the small piston is \(30 \mathrm{~mm}\). Force is exerted on the small piston by an...
-
Initially, both legs of a mercury manometer are open to the atmosphere, and the mercury height in the left leg is \(40.0 \mathrm{~mm}\). You inflate a balloon until it has a surface area of \(0.300...
Study smarter with the SolutionInn App