ASSIGNMENT 3 SAMPLE OUTPUT 1. +--------+--------+--------------+----------+----------------------------------+ | fname | lname | city | sname | phone | +--------+--------+--------------+----------+----------------------------------+ | Marvin | Hanlon | Jacksonville | Florida | ffef46d4f96fb9ebf099b446993fc696 | | Fred | Jewell | Phoenix | Arizona | 23472c931404cbe8bd608c79876db177 | | Frank | Lessor | Phoenix | Arizona | a52a9dd9cc61d2c85ee550fe22cd602a | | Chris | Putnum | Bartlesville | Oklahoma | 46f8ba7f7bca8c7b2c72668eeae2b73c | +--------+--------+--------------+----------+----------------------------------+ 4 rows in set (0.00 sec) 2. +--------------+----------+-----------+---------------+-------+------------+ | customer_num | fname | lname | city | state | totKarsten | +--------------+----------+-----------+---------------+-------+------------+ | 114 | Frank | Albertson | Redwood City | CA | $0.00 | | 118 | Dick | Baxter | Oakland | CA | $0.00 | | 113 | Lana | Beatty | Menlo Park | CA | $0.00 | | 103 | Philip | Currie | Palo Alto | CA | $0.00 | | 115 | Alfred | Grant | Menlo Park | CA | $0.00 | | 123 | Marvin | Hanlon | Jacksonville | FL | $438.00 | | 125 | James | Henry | Brighton | MA | $0.00 | | 104 | Anthony | Higgins | Redwood City | CA | $0.00 | | 110 | Roy | Jaeger | Redwood City | CA | $0.00 | | 120 | Fred | Jewell | Phoenix | AZ | $230.00 | | 111 | Frances | Keyes | Sunnyvale | CA | $0.00 | <...full output not displayed here...> 28 rows in set (0.00 sec) 3. +----------+----------+------------+ | fname | lname | totalSpent | +----------+----------+------------+ | Alfred | Grant | 96.30 | | Marvin | Hanlon | 446.50 | | Anthony | Higgins | 1489.80 | | Roy | Jaeger | 1410.10 | | Fred | Jewell | 602.00 | | Frances | Keyes | 460.00 | | Margaret | Lawson | 462.20 | | Eileen | Neelie | 245.00 | | Cathy | O'Brian | 1522.97 | | Jean | Parmelee | 578.20 | | Ludwig | Pauli | 1215.30 | | Chris | Putnum | 1626.00 | | Kim | Satifer | 842.00 | | Bob | Shorter | 665.80 | | Arnold | Sipes | 2775.40 | | Jason | Wallack | 1151.00 | | George | Watson | 2887.50 | +----------+----------+------------+ 17 rows in set (0.01 sec) 4. +-----------+-----------+-----------------+------------+------+--------------+ | stock_num | manu_code | description | unit_price | unit | unit_descr | +-----------+-----------+-----------------+------------+------+--------------+ | 3 | SHM | baseball bat | 280.00 | case | 12/case | | 101 | PRC | bicycle tires | 88.00 | box | 4/box | | 102 | PRC | bicycle brakes | 480.00 | case | 4 sets/case | | 102 | SHM | bicycle brakes | 220.00 | case | 4 sets/case | | 105 | PRC | bicycle wheels | 53.00 | pair | pair | | 106 | PRC | bicycle stem | 23.00 | each | each | | 107 | PRC | bicycle saddle | 70.00 | pair | pair | | 108 | SHM | crankset | 45.00 | each | each | | 109 | SHM | pedal binding | 200.00 | case | 4 pairs/case | | 110 | ANZ | helmet | 244.00 | case | 4/case | | 110 | HRO | helmet | 260.00 | case | 4/case | | 112 | SHM | 12-spd, assmbld | 549.00 | each | each | | 113 | SHM | 18-spd, assmbld | 685.90 | each | each | | 201 | KAR | golf shoes | 90.00 | each | each | | 202 | NKL | metal woods | 174.00 | case | 2 sets/case | | 203 | NKL | irons/wedge | 670.00 | case | 2 sets/case | | 205 | HRO | 3 golf balls | 312.00 | case | 24/case | | 205 | NKL | 3 golf balls | 312.00 | case | 24/case | | 301 | ANZ | running shoes | 95.00 | each | each | | 301 | HRO | running shoes | 42.50 | each | each | | 301 | NKL | running shoes | 97.00 | each | each | | 301 | PRC | running shoes | 75.00 | each | each | | 302 | HRO | ice pack | 4.50 | each | each | | 303 | KAR | socks | 36.00 | box | 24 pairs/box | | 305 | HRO | first-aid kit | 48.00 | case | 4/case | | 306 | PRC | tandem adapter | 160.00 | each | each | | 308 | PRC | twin jogger | 280.00 | each | each | | 309 | SHM | ear drops | 40.00 | case | 20/case | | 310 | ANZ | kick board | 84.00 | case | 12/case | | 310 | SHM | kick board | 80.00 | case | 10/case | | 311 | SHM | water gloves | 48.00 | box | 4 pairs/box | | 312 | HRO | racer goggles | 72.00 | box | 12/box | | 312 | SHM | racer goggles | 96.00 | box | 12/box | | 313 | ANZ | swim cap | 60.00 | box | 12/box | | 313 | SHM | swim cap | 72.00 | box | 12/box | +-----------+-----------+-----------------+------------+------+--------------+ 35 rows in set (0.00 sec) 5. +-----------+--------------+-------------+ | order_num | customer_num | ship_weight | +-----------+--------------+-------------+ | 1002 | 101 | 50.60 | +-----------+--------------+-------------+ 1 row in set (0.00 sec) 6. 13 rows 7. (on the requested “company” database) 0 rows if run on the modified “badcompany” +----------+----------+-----------+ | dname | pname | plocation | +----------+----------+-----------+ | Research | Crabbing | Coos Bay | +----------+----------+-----------+ 8. +-----------------+----------+ | pname | totHours | +-----------------+----------+ | Computerization | 55.00 | | Newbenefits | 55.00 | +-----------------+----------+ 2 rows in set (0.00 sec) 9. +----------+---------+-----------------+ | fname | lname | pname | +----------+---------+-----------------+ | Joyce | English | ProductX | | Ahmad | Jabbar | Computerization | | Ahmad | Jabbar | Newbenefits | | John | Smith | ProductX | | Jennifer | Wallace | Newbenefits | | Franklin | Wong | Computerization | | Alicia | Zelaya | Computerization | | Alicia | Zelaya | Newbenefits | +----------+---------+-----------------+ 8 rows in set (0.00 sec) 10. +------------------------+----------+ | title | amtspent | +------------------------+----------+ | ICE CROSSING | $100.76 | | IDAHO LOVE | $80.83 | | IDENTITY LOVER | $59.87 | | IDOLS SNATCHERS | $114.70 | | IGBY MAKER | $99.81 | | ILLUSION AMELIE | $39.85 | | IMAGE PRINCESS | $76.86 | | IMPACT ALADDIN | $20.91 | | IMPOSSIBLE PREJUDICE | $74.86 | | INCH JET | $95.82 | | INDEPENDENCE HOTEL | $38.81 | | INDIAN LOVE | $50.84 | | INFORMER DOUBLE | $27.95 | | INNOCENT USUAL | $191.74 | | INSECTS STONE | $36.81 | | INSIDER ARIZONA | $73.80 | | INSTINCT AIRPORT | $72.82 | | INTENTIONS EMPIRE | $78.83 | | INTERVIEW LIAISONS | $128.80 | | INTOLERABLE INTENTIONS | $49.91 | | INTRIGUE WORST | $37.80 | | INVASION CYCLONE | $103.73 | | IRON MOON | $55.89 | | ISHTAR ROCKETEER | $51.93 | | ISLAND EXORCIST | $85.74 | | ITALIAN AFRICAN | $38.94 | +------------------------+----------+ 26 rows in set (0.00 sec)