Exp19_Access_Ch05_Cap_Varmel_Studio_Toys
lacey.xyY
Blake_Exp19_Access_Ch05_Cap_Varmel_Studio_Toys.accdb| CustomerID | CustomerName | Address1 | Address2 | mSysRowId |
|---|---|---|---|---|
| C0001 | Conley, Cathrine | 137 Jockey Hollow St. | Suitland, MD 20746 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0002 | Blakely, Ladawn | 346 La Sierra St. | Greer, SC 29650 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0003 | Bynum, Joya | 42 S. Pierce Street | Appleton, WI 54911 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0004 | Neel, Hana | 8840 Rock Creek Dr. | Pearl, MS 39208 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0005 | Sanford, Nilda | 8115 Amherst Lane | Hillsborough, NJ 08844 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0006 | Chesser, Isidro | 8414 Strawberry St. | Vernon Hills, IL 60061 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0007 | Fish, Aja | 414 Dunbar Ave. | New Rochelle, NY 10801 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0008 | Holcombe, Shemeka | 8737 East Elmwood Ave. | Garden City, NY 11530 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0009 | Willard, Denny | 9296 E. Walnut Lane | Saginaw, MI 48601 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0010 | Gallo, Vaughn | 86 S. Lyme Court | Lemont, IL 60439 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0011 | Collado, Hyon | 9724 Bowman St. | Sioux City, IA 51106 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0012 | Cheatham, Joaquin | 988 King Dr. | Miamisburg, OH 45342 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0013 | Horan, Velia | 544 Valley St. | Norman, OK 73072 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0014 | Meza, Leon | 846 Marvon Dr. | Poughkeepsie, NY 12601 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0015 | Whaley, Josefine | 53 West Pulaski Ave. | Chillicothe, OH 45601 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0016 | Kilgore, Nancie | 24 Wild Horse Dr. | Tucson, AZ 85718 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0017 | Staten, Erasmo | 9691 Park St. | Lexington, NC 27292 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0018 | Dorsey, Prince | 5 Nicolls St. | Langhorne, PA 19047 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0019 | Kenney, Charlyn | 93 Peg Shop Rd. | Emporia, KS 66801 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0020 | Wick, Verlie | 7516 South Road | Riverview, FL 33569 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0021 | Scruggs, Rona | 61 Applegate Avenue | Marlton, NJ 08053 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0022 | Kinder, Lavone | 8477 W. Wood Street | Zanesville, OH 43701 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0023 | Isom, Eleni | 169 Ann Road | Bear, DE 19701 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0024 | Montanez, Nichelle | 9831 Primrose Drive | Bay Shore, NY 11706 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0025 | Best, Filiberto | 60 John Street | Maspeth, NY 11378 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0026 | Echols, Quyen | 7168 Yukon Ave. | Park Ridge, IL 60068 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0027 | Allan, Gidget | 808 S. New Saddle St. | Billerica, MA 01821 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0028 | Crisp, Sol | 8690 Leeton Ridge St. | Hummelstown, PA 17036 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0029 | Jeffries, John | 9447 Ivy Dr. | Ankeny, IA 50023 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0030 | Gorman, Yael | 9372 Inverness Ave. | Henrico, VA 23228 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0031 | Bivens, Lona | 81 Newport Lane | Chelmsford, MA 01824 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0032 | Frame, Yolande | 42 Vernon Street | Fort Lauderdale, FL 33308 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0033 | Huerta, Candie | 958 Sierra Ave. | Pensacola, FL 32503 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0034 | Clancy, Twanda | 552 Trenton Rd. | Portland, ME 04103 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0035 | Dunbar, Rosenda | 543 SW. St Louis Ave. | Hartselle, AL 35640 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0036 | Smothers, Tabetha | 8281 Hillside Ave. | Bradenton, FL 34203 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0037 | Chapin, Tayna | 793 Glendale Avenue | Catonsville, MD 21228 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0038 | Juarez, Alysa | 9906 Addison St. | Sun Prairie, WI 53590 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0039 | Krieger, Gia | 58 East Meadow Dr. | Melbourne, FL 32904 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0040 | Mcmillen, Millard | 692 White Lane | Mahwah, NJ 07430 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0041 | Kirby, Marth | 299 E. Cherry Hill Lane | Poughkeepsie, NY 12601 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0042 | Low, Yi | 7608 Dunbar Dr. | Petersburg, VA 23803 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0043 | Haller, Lecia | 7376 Pulaski Rd. | Hazleton, PA 18201 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0044 | Villalobos, Ellsworth | 7209 Henry Smith Street | Waldorf, MD 20601 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0045 | Fitzsimmons, Alta | 314 El Dorado Street | Scotch Plains, NJ 07076 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0046 | Loper, Cleopatra | 225 King Drive | Rosedale, NY 11422 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0047 | Rowan, Shonta | 60 Roosevelt St. | Cranberry Twp, PA 16066 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0048 | Gee, Orpha | 7512 Stonybrook Rd. | Olive Branch, MS 38654 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0049 | Leslie, Stefanie | 714 Country Drive | Fort Lauderdale, FL 33308 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| C0050 | Cardona, Jasper | 7558 Oxford St. | Ridgecrest, CA 93555 | u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw== |
| EmployeeID | EmployeeName | Phone | DateOfLastReview | |
|---|---|---|---|---|
| E0001 | Correia, Sammie | 751-977-6807 | [email protected] | |
| E0002 | Lentz, Tamisha | 958-469-1408 | [email protected] | 2018-11-25 |
| E0003 | Rendon, Reiko | 751-842-7254 | [email protected] | 2018-07-17 |
| E0004 | Robb, Charla | 751-658-5815 | [email protected] | |
| E0005 | Atwell, Shu | 424-952-2502 | [email protected] | |
| E0006 | Miner, Nathanael | 700-479-8999 | [email protected] | 2019-02-10 |
| E0007 | Paquette, Christia | 976-891-6875 | [email protected] | 2019-04-14 |
| E0008 | Hathaway, Consuela | 751-762-4200 | [email protected] | 2019-07-25 |
| E0009 | Latham, Kaylene | 958-618-8599 | [email protected] | 2019-09-11 |
| E0010 | Aquino, Irish | 950-559-1704 | [email protected] | 2019-03-08 |
| E0011 | Batson, Hayley | 857-247-8670 | [email protected] | 2018-06-12 |
| E0012 | Escamilla, Winter | 751-470-1181 | [email protected] | 2018-07-04 |
| E0013 | Coulter, Ashli | 600-227-2901 | [email protected] | 2019-02-16 |
| E0014 | Delaney, Alexis | 969-540-7928 | [email protected] | |
| E0015 | Gallegos, Gwyneth | 870-406-7690 | [email protected] | 2018-10-10 |
| E0016 | Betancourt, Tori | 600-617-8495 | [email protected] | 2019-09-01 |
| E0017 | South, Ray | 711-547-4794 | [email protected] | |
| E0018 | Burdette, Elza | 600-210-4842 | [email protected] | 2018-01-16 |
| E0019 | Farr, Elwood | 959-294-7770 | [email protected] | 2018-01-17 |
| E0020 | Braswell, Celesta | 424-742-7627 | [email protected] | 2019-02-28 |
| E0021 | Hyland, Keturah | 822-717-2870 | [email protected] | 2018-12-10 |
| E0022 | Browning, Lewis | 950-757-9090 | [email protected] | 2019-09-04 |
| E0023 | Dollar, Jeri | 969-287-9787 | [email protected] | 2019-06-23 |
| E0024 | Scully, Kimberli | 877-780-5772 | [email protected] | 2018-09-22 |
| E0025 | Compton, Pamala | 727-781-2456 | [email protected] | 2019-01-06 |
| E0026 | Knott, Assunta | 822-912-8158 | [email protected] | |
| E0027 | Painter, Jayne | 976-770-9602 | [email protected] | |
| E0028 | Arnett, Audrie | 424-541-9967 | [email protected] | 2018-10-05 |
| E0029 | Bader, Donny | 950-279-2272 | [email protected] | 2018-08-19 |
| E0030 | Mahon, Kaylee | 870-641-7846 | [email protected] | 2018-07-24 |
| E0031 | Cotter, Anjanette | 751-622-7076 | [email protected] | 2018-08-08 |
| E0032 | Devore, Winford | 700-896-4017 | [email protected] | 2019-05-21 |
| E0033 | Witt, Kati | 276-725-7077 | [email protected] | 2018-10-21 |
| E0034 | Finch, Suk | 224-620-7087 | [email protected] | 2018-04-18 |
| E0035 | Grigsby, Lanny | 958-578-8090 | [email protected] | 2019-01-26 |
| E0036 | Register, Caroll | 950-896-5527 | [email protected] | 2018-09-06 |
| E0037 | Fontenot, Ester | 969-670-2667 | [email protected] | |
| E0038 | Schmid, Antonio | 822-785-1199 | [email protected] | |
| E0039 | Prado, Margit | 959-876-7748 | [email protected] | 2019-06-28 |
| E0040 | Gunderson, Tamala | 555-279-5807 | [email protected] | |
| E0041 | Speer, Hilde | 727-765-7677 | [email protected] | 2018-05-24 |
| E0042 | Cline, Twana | 276-677-2875 | [email protected] | 2018-12-26 |
| E0043 | Garnett, Antonetta | 969-774-1119 | [email protected] | 2019-09-15 |
| E0044 | Rivers, Oswaldo | 969-599-8879 | [email protected] | 2019-11-27 |
| E0045 | Mosier, Jalisa | 976-850-1827 | [email protected] | 2019-04-13 |
| E0046 | Monk, Margo | 751-871-8471 | [email protected] | 2018-11-28 |
| E0047 | Sellers, Sacha | 600-802-2694 | [email protected] | 2018-11-25 |
| E0048 | Dickerson, Arvilla | 969-582-8124 | [email protected] | 2018-05-28 |
| E0049 | Jeffery, Daniela | 751-546-8761 | [email protected] | 2019-12-23 |
| E0050 | Ontiveros, Jacinta | 555-529-8778 | [email protected] | 2019-11-02 |
| SKU | ItemName | ItemTypeID | InventoryQty | Retail |
|---|---|---|---|---|
| 1314005876 | Alpha Dog | 1 | 36.0 | 14.99 |
| 1314015876 | Broad Macaw | 1 | 20.0 | 31.99 |
| 1314045876 | Chief Terrific Mole | 1 | 25.0 | 44.99 |
| 1314055876 | Chief Terrific Mole | 2 | 10.0 | 1.99 |
| 1314085876 | Chief Whispering Hammer | 1 | 42.0 | 49.99 |
| 1314095876 | Dark Spider | 1 | 55.0 | 18.99 |
| 1314125876 | Doctor Defiant Bat | 1 | 41.0 | 35.99 |
| 1314135876 | Doctor Dynasty | 1 | 10.0 | 16.99 |
| 1314165876 | Doctor Fancy Fox | 1 | 37.0 | 16.99 |
| 1314175876 | Doctor Golden Bat | 1 | 7.0 | 23.99 |
| 1314205876 | Doctor Golden Bat | 2 | 25.0 | 1.99 |
| 1314215876 | Doctor Misty Wonder | 1 | 32.0 | 39.99 |
| 1314245876 | Famous Mastermind | 1 | 36.0 | 42.99 |
| 1314255876 | Huge Leopard | 1 | 9.0 | 13.99 |
| 1314285876 | Huge Leopard | 2 | 14.0 | 2.99 |
| 1314295876 | Kind Scorpion | 1 | 41.0 | 43.99 |
| 1314325876 | Master Marvelous Magician | 1 | 3.0 | 39.99 |
| 1314335876 | Metanite | 1 | 18.0 | 40.99 |
| 1314365876 | Mister Quick Lion | 1 | 4.0 | 29.99 |
| 1314375876 | Mister Rapid Angel | 1 | 5.0 | 31.99 |
| 1314405876 | Mister Rapid Angel | 2 | 10.0 | 2.99 |
| 1314415876 | Nifty Dagger | 1 | 36.0 | 29.99 |
| 1314445876 | Nightwave | 1 | 20.0 | 35.99 |
| 1314455876 | Old Snipe | 1 | 2.0 | 39.99 |
| 1314485876 | Old Snipe | 2 | 24.0 | 5.99 |
| 1314495876 | Razor | 1 | 26.0 | 40.99 |
| 1314525876 | Saberleaf | 1 | 43.0 | 26.99 |
| 1314535876 | Scarlet Sentinel | 1 | 1.0 | 19.99 |
| 1314565876 | Solar Flare | 1 | 19.0 | 33.99 |
| 1314575876 | Solar Flare | 2 | 13.0 | 5.99 |
| 1314605876 | The Bronze Wasp | 1 | 45.0 | 40.99 |
| 1314615876 | The Colossal Rhino | 1 | 9.0 | 14.99 |
| 1314645876 | The Colossal Tiger | 1 | 3.0 | 37.99 |
| 1314655876 | The Electric Cricket | 1 | 24.0 | 40.99 |
| 1314685876 | The Elegant Seer | 1 | 55.0 | 47.99 |
| 1314695876 | The Ethereal Ant | 1 | 52.0 | 29.99 |
| 1314725876 | The Giant Commando | 1 | 20.0 | 16.99 |
| 1314735876 | The Golden Guard | 1 | 24.0 | 24.99 |
| 1314765876 | The Golden Guard | 2 | 15.0 | 4.99 |
| 1314775876 | The Long Gorilla | 1 | 14.0 | 21.99 |
| 1314805876 | The Long Gorilla | 2 | 4.0 | 5.99 |
| 1314815876 | The Macho Crane | 1 | 33.0 | 45.99 |
| 1314845876 | The Marvelous Ant | 1 | 10.0 | 18.99 |
| 1314855876 | The Marvelous Ant | 2 | 19.0 | 1.99 |
| 1314885876 | The Orange Warden | 1 | 0.0 | 25.99 |
| 1314895876 | The Rapid Sage | 1 | 47.0 | 18.99 |
| 1314925876 | The Silver Elephantman | 1 | 10.0 | 10.99 |
| 1314935876 | The Silver Elephantman | 2 | 3.0 | 2.99 |
| 1314965876 | The Steel Swallow | 1 | 5.0 | 34.99 |
| 1314975876 | The Yellow Jackal | 1 | 36.0 | 45.99 |
| ID | mSysRowId |
|---|---|
| 1 | Qquk6YEUrtFUP3kUBVIQ27aLxMo41fxpTrBk4wCmDkI=-~2Xb6Z4u1ok8u1etzHdU3rg== |
| OrderID | CustomerID | OrderDate | EmployeeID | mSysRowId |
|---|---|---|---|---|
| O0001 | C0019 | 2019-05-06 | E0010 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0002 | C0041 | 2019-05-09 | E0026 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0003 | C0026 | 2019-06-10 | E0049 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0004 | C0004 | 2019-06-10 | E0002 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0005 | C0009 | 2019-06-10 | E0011 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0006 | C0017 | 2019-07-11 | E0045 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0007 | C0005 | 2019-07-12 | E0004 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0008 | C0001 | 2019-07-12 | E0042 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0009 | C0022 | 2019-08-13 | E0041 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0010 | C0045 | 2019-08-13 | E0035 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0011 | C0002 | 2019-08-13 | E0008 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0012 | C0014 | 2019-08-14 | E0031 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0013 | C0018 | 2019-09-14 | E0047 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0014 | C0008 | 2019-09-14 | E0005 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0015 | C0012 | 2019-09-15 | E0044 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0016 | C0008 | 2019-09-16 | E0036 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0017 | C0008 | 2019-10-16 | E0002 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0018 | C0010 | 2019-10-16 | E0004 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0019 | C0028 | 2019-10-17 | E0045 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0020 | C0012 | 2019-10-17 | E0032 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0021 | C0038 | 2019-10-17 | E0047 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0022 | C0050 | 2019-10-17 | E0017 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0023 | C0041 | 2019-10-18 | E0010 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0024 | C0036 | 2019-10-18 | E0006 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0025 | C0013 | 2019-10-19 | E0012 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0026 | C0008 | 2019-10-19 | E0009 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0027 | C0039 | 2019-11-19 | E0024 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0028 | C0001 | 2019-11-20 | E0007 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0029 | C0035 | 2019-12-20 | E0020 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0030 | C0027 | 2019-12-21 | E0050 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0031 | C0035 | 2019-12-21 | E0049 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0032 | C0023 | 2019-12-22 | E0005 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| O0033 | C0018 | 2019-12-22 | E0001 | RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg== |
| OrderID | LineNum | Qty | Price | SKU | mSysRowId |
|---|---|---|---|---|---|
| O0001 | 1.0 | 15.0 | 224.85 | 1314615876 | |
| O0001 | 2.0 | 11.0 | 351.89 | 1314015876 | |
| O0002 | 1.0 | 2.0 | 81.98 | 1314655876 | |
| O0003 | 1.0 | 15.0 | 29.85 | 1314855876 | |
| O0004 | 1.0 | 14.0 | 629.86 | 1314045876 | |
| O0005 | 1.0 | 15.0 | 209.85 | 1314255876 | |
| O0006 | 1.0 | 9.0 | 323.91 | 1314445876 | |
| O0007 | 1.0 | 5.0 | 94.94999999999999 | 1314845876 | |
| O0008 | 1.0 | 9.0 | 287.90999999999997 | 1314015876 | |
| O0009 | 1.0 | 12.0 | 23.88 | 1314855876 | |
| O0009 | 2.0 | 10.0 | 479.90000000000003 | 1314685876 | |
| O0010 | 1.0 | 9.0 | 323.91 | 1314445876 | |
| O0010 | 2.0 | 4.0 | 179.96 | 1314045876 | |
| O0011 | 1.0 | 1.0 | 24.99 | 1314735876 | |
| O0012 | 1.0 | 4.0 | 87.96 | 1314775876 | |
| O0013 | 1.0 | 14.0 | 559.86 | 1314325876 | |
| O0013 | 2.0 | 9.0 | 323.91 | 1314445876 | |
| O0014 | 1.0 | 9.0 | 341.91 | 1314645876 | |
| O0015 | 1.0 | 15.0 | 29.85 | 1314855876 | |
| O0016 | 1.0 | 5.0 | 229.95000000000002 | 1314815876 | |
| O0016 | 2.0 | 15.0 | 44.85 | 1314285876 | |
| O0016 | 3.0 | 5.0 | 159.95 | 1314015876 | |
| O0016 | 4.0 | 13.0 | 519.87 | 1314455876 | |
| O0016 | 5.0 | 10.0 | 459.90000000000003 | 1314975876 | |
| O0017 | 1.0 | 13.0 | 493.87 | 1314645876 | |
| O0018 | 1.0 | 6.0 | 215.94 | 1314445876 | |
| O0018 | 2.0 | 1.0 | 31.99 | 1314015876 | |
| O0019 | 1.0 | 7.0 | 300.93 | 1314245876 | |
| O0020 | 1.0 | 3.0 | 107.97 | 1314445876 | |
| O0020 | 2.0 | 12.0 | 491.88 | 1314495876 | |
| O0021 | 1.0 | 5.0 | 159.95 | 1314375876 | |
| O0021 | 2.0 | 9.0 | 53.910000000000004 | 1314805876 | |
| O0022 | 1.0 | 14.0 | 27.86 | 1314205876 | |
| O0023 | 1.0 | 15.0 | 614.85 | 1314605876 | |
| O0023 | 2.0 | 13.0 | 623.87 | 1314685876 | |
| O0023 | 3.0 | 10.0 | 299.9 | 1314695876 | |
| O0023 | 4.0 | 6.0 | 101.94 | 1314135876 | |
| O0024 | 1.0 | 13.0 | 259.87 | 1314535876 | |
| O0025 | 1.0 | 10.0 | 239.89999999999998 | 1314175876 | |
| O0026 | 1.0 | 13.0 | 25.87 | 1314855876 | |
| O0027 | 1.0 | 11.0 | 395.89000000000004 | 1314445876 | |
| O0027 | 2.0 | 12.0 | 359.88 | 1314695876 | |
| O0027 | 3.0 | 11.0 | 65.89 | 1314575876 | |
| O0028 | 1.0 | 12.0 | 491.88 | 1314655876 | |
| O0029 | 1.0 | 8.0 | 367.92 | 1314815876 | |
| O0030 | 1.0 | 15.0 | 539.85 | 1314445876 | |
| O0031 | 1.0 | 5.0 | 119.94999999999999 | 1314175876 | |
| O0032 | 1.0 | 14.0 | 349.85999999999996 | 1314735876 | |
| O0033 | 1.0 | 1.0 | 39.99 | 1314325876 |
SELECT Inventory.SKU, Inventory.ItemName, Inventory.InventoryQty, Inventory.Retail
FROM Inventory;
SELECT [Order Data].OrderDate, Sum([Order Item].[Price]) AS OrderLineCost
FROM [Order Data] INNER JOIN [Order Item] ON [Order Data].OrderID = [Order Item].OrderID
GROUP BY [Order Data].OrderDate;
SELECT Employees.EmployeeName, Employees.DateOfLastReview
FROM Employees
ORDER BY Employees.EmployeeName;
SELECT Inventory.SKU, Inventory.ItemName, Inventory.InventoryQty, Inventory.Retail
FROM Inventory;
