| 172 |
| 10287 | 2004-08-30 | 2004-09-06 | 2004-09-01 | Shipped | NULL
| 298 |
| 10288 | 2004-09-01 | 2004-09-11 | 2004-09-05 | Shipped | NULL
| 166 |
| 10289 | 2004-09-03 | 2004-09-13 | 2004-09-04 | Shipped | We need to keep in close contact with their Marketing VP. He is the decision maker for all their purchases.
| 167 |
| 10290 | 2004-09-07 | 2004-09-15 | 2004-09-13 | Shipped | NULL
| 198 |
| 10291 | 2004-09-08 | 2004-09-17 | 2004-09-14 | Shipped | NULL
| 448 |
| 10292 | 2004-09-08 | 2004-09-18 | 2004-09-11 | Shipped | They want to reevaluate their terms agreement with Finance.
| 131 |
| 10293 | 2004-09-09 | 2004-09-18 | 2004-09-14 | Shipped | NULL
| 249 |
| 10294 | 2004-09-10 | 2004-09-17 | 2004-09-14 | Shipped | NULL
| 204 |
| 10295 | 2004-09-10 | 2004-09-17 | 2004-09-14 | Shipped | They want to reevaluate their terms agreement with Finance.
| 362 |
| 10296 | 2004-09-15 | 2004-09-22 | 2004-09-16 | Shipped | NULL
| 415 |
| 10297 | 2004-09-16 | 2004-09-22 | 2004-09-21 | Shipped | We must be cautions with this customer. Their VP of Sales resigned. Company may be heading down.
| 189 |
| 10298 | 2004-09-27 | 2004-10-05 | 2004-10-01 | Shipped | NULL
| 103 |
| 10299 | 2004-09-30 | 2004-10-10 | 2004-10-01 | Shipped | NULL
| 186 |
| 10300 | 2003-10-04 | 2003-10-13 | 2003-10-09 | Shipped | NULL
| 128 |
| 10301 | 2003-10-05 | 2003-10-15 | 2003-10-08 | Shipped | NULL
| 299 |
| 10302 | 2003-10-06 | 2003-10-16 | 2003-10-07 | Shipped | NULL
| 201 |
| 10303 | 2004-10-06 | 2004-10-14 | 2004-10-09 | Shipped | Customer inquired about remote controlled models and gold models.
| 484 |
| 10304 | 2004-10-11 | 2004-10-20 | 2004-10-17 | Shipped | NULL
| 256 |
| 10305 | 2004-10-13 | 2004-10-22 | 2004-10-15 | Shipped | Check on availability.
| 286 |
| 10306 | 2004-10-14 | 2004-10-21 | 2004-10-17 | Shipped | NULL
| 187 |
| 10307 | 2004-10-14 | 2004-10-23 | 2004-10-20 | Shipped | NULL
| 339 |
| 10308 | 2004-10-15 | 2004-10-24 | 2004-10-20 | Shipped | Customer requested that FedEx Ground is used for this shipping
| 319 |
| 10309 | 2004-10-15 | 2004-10-24 | 2004-10-18 | Shipped | NULL
| 121 |
| 10310 | 2004-10-16 | 2004-10-24 | 2004-10-18 | Shipped | NULL
| 259 |
| 10311 | 2004-10-16 | 2004-10-23 | 2004-10-20 | Shipped | Difficult to negotiate with customer. We need more marketing materials
| 141 |
| 10312 | 2004-10-21 | 2004-10-27 | 2004-10-23 | Shipped | NULL
| 124 |
| 10313 | 2004-10-22 | 2004-10-28 | 2004-10-25 | Shipped | Customer requested that FedEx Ground is used for this shipping
| 202 |
| 10314 | 2004-10-22 | 2004-11-01 | 2004-10-23 | Shipped | NULL
| 227 |
| 10315 | 2004-10-29 | 2004-11-08 | 2004-10-30 | Shipped | NULL
| 119 |
| 10316 | 2004-11-01 | 2004-11-09 | 2004-11-07 | Shipped | Customer requested that ad materials (such as posters, pamphlets) be included in the shippment
| 240 |
| 10317 | 2004-11-02 | 2004-11-12 | 2004-11-08 | Shipped | NULL
| 161 |
| 10318 | 2004-11-02 | 2004-11-09 | 2004-11-07 | Shipped | NULL
| 157 |
| 10319 | 2004-11-03 | 2004-11-11 | 2004-11-06 | Shipped | Customer requested that DHL is used for this shipping
| 456 |
| 10320 | 2004-11-03 | 2004-11-13 | 2004-11-07 | Shipped | NULL
| 144 |
| 10321 | 2004-11-04 | 2004-11-12 | 2004-11-07 | Shipped | NULL
| 462 |
| 10322 | 2004-11-04 | 2004-11-12 | 2004-11-10 | Shipped | Customer has worked with some of our vendors in the past and is aware of their MSRP
| 363 |
| 10323 | 2004-11-05 | 2004-11-12 | 2004-11-09 | Shipped | NULL
| 128 |
| 10324 | 2004-11-05 | 2004-11-11 | 2004-11-08 | Shipped | NULL
| 181 |
| 10325 | 2004-11-05 | 2004-11-13 | 2004-11-08 | Shipped | NULL
| 121 |
| 10326 | 2004-11-09 | 2004-11-16 | 2004-11-10 | Shipped | NULL
| 144 |
| 10327 | 2004-11-10 | 2004-11-19 | 2004-11-13 | Resolved | Order was disputed and resolved on 12/1/04. The Sales Manager was involved. Customer claims the scales of the models do
n't match what was discussed. | 145 |
| 10328 | 2004-11-12 | 2004-11-21 | 2004-11-18 | Shipped | Customer very concerned about the exact color of the models. There is high risk that he may dispute the order because t
here is a slight color mismatch | 278 |
| 10329 | 2004-11-15 | 2004-11-24 | 2004-11-16 | Shipped | NULL
| 131 |
| 10330 | 2004-11-16 | 2004-11-25 | 2004-11-21 | Shipped | NULL
| 385 |
| 10331 | 2004-11-17 | 2004-11-23 | 2004-11-23 | Shipped | Customer requested special shippment. The instructions were passed along to the warehouse
| 486 |
| 10332 | 2004-11-17 | 2004-11-25 | 2004-11-18 | Shipped | NULL
| 187 |
| 10333 | 2004-11-18 | 2004-11-27 | 2004-11-20 | Shipped | NULL
| 129 |
| 10334 | 2004-11-19 | 2004-11-28 | NULL | On Hold | The outstaniding balance for this customer exceeds their credit limit. Order will be shipped when a payment is received
. | 144 |
| 10335 | 2004-11-19 | 2004-11-29 | 2004-11-23 | Shipped | NULL
| 124 |
| 10336 | 2004-11-20 | 2004-11-26 | 2004-11-24 | Shipped | Customer requested that DHL is used for this shipping
| 172 |
| 10337 | 2004-11-21 | 2004-11-30 | 2004-11-26 | Shipped | NULL
| 424 |
| 10338 | 2004-11-22 | 2004-12-02 | 2004-11-27 | Shipped | NULL
| 381 |
| 10339 | 2004-11-23 | 2004-11-30 | 2004-11-30 | Shipped | NULL
| 398 |
| 10340 | 2004-11-24 | 2004-12-01 | 2004-11-25 | Shipped | Customer is interested in buying more Ferrari models
| 216 |
| 10341 | 2004-11-24 | 2004-12-01 | 2004-11-29 | Shipped | NULL
| 382 |
| 10342 | 2004-11-24 | 2004-12-01 | 2004-11-29 | Shipped | NULL
| 114 |
| 10343 | 2004-11-24 | 2004-12-01 | 2004-11-26 | Shipped | NULL
| 353 |
| 10344 | 2004-11-25 | 2004-12-02 | 2004-11-29 | Shipped | NULL
| 350 |
| 10345 | 2004-11-25 | 2004-12-01 | 2004-11-26 | Shipped | NULL
| 103 |
| 10346 | 2004-11-29 | 2004-12-05 | 2004-11-30 | Shipped | NULL
| 112 |
| 10347 | 2004-11-29 | 2004-12-07 | 2004-11-30 | Shipped | Can we deliver the new Ford Mustang models by end-of-quarter?
| 114 |
| 10348 | 2004-11-01 | 2004-11-08 | 2004-11-05 | Shipped | NULL
| 458 |
| 10349 | 2004-12-01 | 2004-12-07 | 2004-12-03 | Shipped | NULL
| 151 |
| 10350 | 2004-12-02 | 2004-12-08 | 2004-12-05 | Shipped | NULL
| 141 |
| 10351 | 2004-12-03 | 2004-12-11 | 2004-12-07 | Shipped | NULL
| 324 |
| 10352 | 2004-12-03 | 2004-12-12 | 2004-12-09 | Shipped | NULL
| 198 |
| 10353 | 2004-12-04 | 2004-12-11 | 2004-12-05 | Shipped | NULL
| 447 |
| 10354 | 2004-12-04 | 2004-12-10 | 2004-12-05 | Shipped | NULL
| 323 |
| 10355 | 2004-12-07 | 2004-12-14 | 2004-12-13 | Shipped | NULL
| 141 |
| 10356 | 2004-12-09 | 2004-12-15 | 2004-12-12 | Shipped | NULL
| 250 |
| 10357 | 2004-12-10 | 2004-12-16 | 2004-12-14 | Shipped | NULL
| 124 |
| 10358 | 2004-12-10 | 2004-12-16 | 2004-12-16 | Shipped | Customer requested that DHL is used for this shipping
| 141 |
| 10359 | 2004-12-15 | 2004-12-23 | 2004-12-18 | Shipped | NULL
| 353 |
| 10360 | 2004-12-16 | 2004-12-22 | 2004-12-18 | Shipped | NULL
| 496 |
| 10361 | 2004-12-17 | 2004-12-24 | 2004-12-20 | Shipped | NULL
| 282 |
| 10362 | 2005-01-05 | 2005-01-16 | 2005-01-10 | Shipped | NULL
| 161 |
| 10363 | 2005-01-06 | 2005-01-12 | 2005-01-10 | Shipped | NULL
| 334 |
| 10364 | 2005-01-06 | 2005-01-17 | 2005-01-09 | Shipped | NULL
| 350 |
| 10365 | 2005-01-07 | 2005-01-18 | 2005-01-11 | Shipped | NULL
| 320 |
| 10366 | 2005-01-10 | 2005-01-19 | 2005-01-12 | Shipped | NULL
| 381 |
| 10367 | 2005-01-12 | 2005-01-21 | 2005-01-16 | Resolved | This order was disputed and resolved on 2/1/2005. Customer claimed that container with shipment was damaged. FedEx's in
vestigation proved this wrong. | 205 |
| 10368 | 2005-01-19 | 2005-01-27 | 2005-01-24 | Shipped | Can we renegotiate this one?
| 124 |
| 10369 | 2005-01-20 | 2005-01-28 | 2005-01-24 | Shipped | NULL
| 379 |
| 10370 | 2005-01-20 | 2005-02-01 | 2005-01-25 | Shipped | NULL
| 276 |
| 10371 | 2005-01-23 | 2005-02-03 | 2005-01-25 | Shipped | NULL
| 124 |
| 10372 | 2005-01-26 | 2005-02-05 | 2005-01-28 | Shipped | NULL
| 398 |
| 10373 | 2005-01-31 | 2005-02-08 | 2005-02-06 | Shipped | NULL
| 311 |
| 10374 | 2005-02-02 | 2005-02-09 | 2005-02-03 | Shipped | NULL
| 333 |
| 10375 | 2005-02-03 | 2005-02-10 | 2005-02-06 | Shipped | NULL
| 119 |
| 10376 | 2005-02-08 | 2005-02-18 | 2005-02-13 | Shipped | NULL
| 219 |
| 10377 | 2005-02-09 | 2005-02-21 | 2005-02-12 | Shipped | Cautious optimism. We have happy customers here, if we can keep them well stocked. I need all the information I can ge
t on the planned shippments of Porches | 186 |
| 10378 | 2005-02-10 | 2005-02-18 | 2005-02-11 | Shipped | NULL
| 141 |
| 10379 | 2005-02-10 | 2005-02-18 | 2005-02-11 | Shipped | NULL
| 141 |
| 10380 | 2005-02-16 | 2005-02-24 | 2005-02-18 | Shipped | NULL
| 141 |
| 10381 | 2005-02-17 | 2005-02-25 | 2005-02-18 | Shipped | NULL
| 321 |
| 10382 | 2005-02-17 | 2005-02-23 | 2005-02-18 | Shipped | Custom shipping instructions sent to warehouse
| 124 |
| 10383 | 2005-02-22 | 2005-03-02 | 2005-02-25 | Shipped | NULL
| 141 |
| 10384 | 2005-02-23 | 2005-03-06 | 2005-02-27 | Shipped | NULL
| 321 |
| 10385 | 2005-02-28 | 2005-03-09 | 2005-03-01 | Shipped | NULL
| 124 |
| 10386 | 2005-03-01 | 2005-03-09 | 2005-03-06 | Resolved | Disputed then Resolved on 3/15/2005. Customer doesn't like the craftsmaship of the models.
| 141 |
| 10387 | 2005-03-02 | 2005-03-09 | 2005-03-06 | Shipped | We need to keep in close contact with their Marketing VP. He is the decision maker for all their purchases.
| 148 |
| 10388 | 2005-03-03 | 2005-03-11 | 2005-03-09 | Shipped | NULL
| 462 |
| 10389 | 2005-03-03 | 2005-03-09 | 2005-03-08 | Shipped | NULL
| 448 |
| 10390 | 2005-03-04 | 2005-03-11 | 2005-03-07 | Shipped | They want to reevaluate their terms agreement with Finance.
| 124 |
| 10391 | 2005-03-09 | 2005-03-20 | 2005-03-15 | Shipped | NULL
| 276 |
| 10392 | 2005-03-10 | 2005-03-18 | 2005-03-12 | Shipped | NULL
| 452 |
| 10393 | 2005-03-11 | 2005-03-22 | 2005-03-14 | Shipped | They want to reevaluate their terms agreement with Finance.
| 323 |
| 10394 | 2005-03-15 | 2005-03-25 | 2005-03-19 | Shipped | NULL
| 141 |
| 10395 | 2005-03-17 | 2005-03-24 | 2005-03-23 | Shipped | We must be cautions with this customer. Their VP of Sales resigned. Company may be heading down.
| 250 |
| 10396 | 2005-03-23 | 2005-04-02 | 2005-03-28 | Shipped | NULL
| 124 |
| 10397 | 2005-03-28 | 2005-04-09 | 2005-04-01 | Shipped | NULL
| 242 |
| 10398 | 2005-03-30 | 2005-04-09 | 2005-03-31 | Shipped | NULL
| 353 |
| 10399 | 2005-04-01 | 2005-04-12 | 2005-04-03 | Shipped | NULL
| 496 |
| 10400 | 2005-04-01 | 2005-04-11 | 2005-04-04 | Shipped | Customer requested that DHL is used for this shipping
| 450 |
| 10401 | 2005-04-03 | 2005-04-14 | NULL | On Hold | Customer credit limit exceeded. Will ship when a payment is received.
| 328 |
| 10402 | 2005-04-07 | 2005-04-14 | 2005-04-12 | Shipped | NULL
| 406 |
| 10403 | 2005-04-08 | 2005-04-18 | 2005-04-11 | Shipped | NULL
| 201 |
| 10404 | 2005-04-08 | 2005-04-14 | 2005-04-11 | Shipped | NULL
| 323 |
| 10405 | 2005-04-14 | 2005-04-24 | 2005-04-20 | Shipped | NULL
| 209 |
| 10406 | 2005-04-15 | 2005-04-25 | 2005-04-21 | Disputed | Customer claims container with shipment was damaged during shipping and some items were missing. I am talking to FedEx
about this. | 145 |
| 10407 | 2005-04-22 | 2005-05-04 | NULL | On Hold | Customer credit limit exceeded. Will ship when a payment is received.
| 450 |
| 10408 | 2005-04-22 | 2005-04-29 | 2005-04-27 | Shipped | NULL
| 398 |
| 10409 | 2005-04-23 | 2005-05-05 | 2005-04-24 | Shipped | NULL
| 166 |
| 10410 | 2005-04-29 | 2005-05-10 | 2005-04-30 | Shipped | NULL
| 357 |
| 10411 | 2005-05-01 | 2005-05-08 | 2005-05-06 | Shipped | NULL
| 233 |
| 10412 | 2005-05-03 | 2005-05-13 | 2005-05-05 | Shipped | NULL
| 141 |
| 10413 | 2005-05-05 | 2005-05-14 | 2005-05-09 | Shipped | Customer requested that DHL is used for this shipping
| 175 |
| 10414 | 2005-05-06 | 2005-05-13 | NULL | On Hold | Customer credit limit exceeded. Will ship when a payment is received.
| 362 |
| 10415 | 2005-05-09 | 2005-05-20 | 2005-05-12 | Disputed | Customer claims the scales of the models don't match what was discussed. I keep all the paperwork though to prove other
wise | 471 |
| 10416 | 2005-05-10 | 2005-05-16 | 2005-05-14 | Shipped | NULL
| 386 |
| 10417 | 2005-05-13 | 2005-05-19 | 2005-05-19 | Disputed | Customer doesn't like the colors and precision of the models.
| 141 |
| 10418 | 2005-05-16 | 2005-05-24 | 2005-05-20 | Shipped | NULL
| 412 |
| 10419 | 2005-05-17 | 2005-05-28 | 2005-05-19 | Shipped | NULL
| 382 |
| 10420 | 2005-05-29 | 2005-06-07 | NULL | In Process | NULL
| 282 |
| 10421 | 2005-05-29 | 2005-06-06 | NULL | In Process | Custom shipping instructions were sent to warehouse
| 124 |
| 10422 | 2005-05-30 | 2005-06-11 | NULL | In Process | NULL
| 157 |
| 10423 | 2005-05-30 | 2005-06-05 | NULL | In Process | NULL
| 314 |
| 10424 | 2005-05-31 | 2005-06-08 | NULL | In Process | NULL
| 141 |
| 10425 | 2005-05-31 | 2005-06-07 | NULL | In Process | NULL
| 119 |
+-------------+------------+--------------+-------------+------------+------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------+----------------+
326 rows in set (0.002 sec)
MariaDB [classicmodels]> select count(*) from orders;
+----------+
| count(*) |
+----------+
| 326 |
+----------+
1 row in set (0.000 sec)
MariaDB [classicmodels]> select * from orders limit 1;
+-------------+------------+--------------+-------------+---------+----------+----------------+
| orderNumber | orderDate | requiredDate | shippedDate | status | comments | customerNumber |
+-------------+------------+--------------+-------------+---------+----------+----------------+
| 10100 | 2003-01-06 | 2003-01-13 | 2003-01-10 | Shipped | NULL | 363 |
+-------------+------------+--------------+-------------+---------+----------+----------------+
1 row in set (0.001 sec)
MariaDB [classicmodels]> select count(distinct coustmernumber) from orders;
ERROR 1054 (42S22): Unknown column 'coustmernumber' in 'field list'
MariaDB [classicmodels]> select count(distinct coustomernumber) from orders;
ERROR 1054 (42S22): Unknown column 'coustomernumber' in 'field list'
MariaDB [classicmodels]> select count(distinct customernumber) from orders;
+--------------------------------+
| count(distinct customernumber) |
+--------------------------------+
| 98 |
+--------------------------------+
1 row in set (0.001 sec)
MariaDB [classicmodels]>
No comments:
Post a Comment
Note: only a member of this blog may post a comment.