Production Products Table (SQL)

1Trek 820 - 2016962016379,992Ritchey Timberwolf Frameset - 2016562016749,993Surly Wednesday Frameset - 2016862016999,994Trek Fuel EX 8 29 - 20169620162899,995Heller Shagamaw Frame - 20163620161320,996Surly Ice Cream Truck Frameset - 2016862016469,997Trek Slash 8 27.5 - 20169620163999,998Trek Remedy 29 Carbon Frameset - 20169620161799,999Trek Conduit+ - 20169520162999,9910Surly Straggler - 20168420161549,0011Surly Straggler 650b - 20168420161680,9912Electra Townie Original 21D - 2016132016549,9913Electra Cruiser...

Bike Stores SQL Database

Summary: in this tutorial, you will learn how to create a new database in SQL Server and execute the script to load the sample database. First, you need to download the following zip file if you have not done so: DOWLOAND Second, uncompress the zip file, you will see three SQL script files:  BikeStores Sample Database...

Sales Orders Table (SQL)

order_idcustomer_idorder_statusorder_date requiered_dateshipped_datestore_idstaff_id125942016-01-012016-01-032016-01-03122121242016-01-012016-01-042016-01-0326352342016-01-022016-01-052016-01-0327417542016-01-032016-01-042016-01-05135132442016-01-032016-01-062016-01-062669442016-01-042016-01-072016-01-0526732442016-01-042016-01-072016-01-05268120442016-01-042016-01-052016-01-052796042016-01-052016-01-082016-01-08121044242016-01-052016-01-062016-01-062611132642016-01-052016-01-082016-01-0727129142016-01-062016-01-082016-01-09121387342016-01-082016-01-112016-01-11261425842016-01-092016-01-112016-01-12131545042016-01-092016-01-102016-01-12271655242016-01-122016-01-152016-01-151317117542016-01-122016-01-142016-01-14131854142016-01-142016-01-172016-01-15131969642016-01-142016-01-172016-01-16122092342016-01-142016-01-162016-01-171221125042016-01-152016-01-162016-01-182622103542016-01-162016-01-182016-01-171223114942016-01-162016-01-192016-01-19122463642016-01-182016-01-202016-01-19272565742016-01-182016-01-212016-01-212626128042016-01-182016-01-212016-01-1927275742016-01-192016-01-212016-01-20272825242016-01-192016-01-202016-01-21262943742016-01-202016-01-222016-01-212630134842016-01-202016-01-212016-01-212631123842016-01-202016-01-222016-01-223832125942016-01-212016-01-242016-01-22133323642016-01-212016-01-222016-01-2226348042016-01-222016-01-252016-01-23263581342016-01-222016-01-252016-01-242736132142016-01-232016-01-242016-01-24263716442016-01-252016-01-282016-01-26263858342016-01-252016-01-272016-01-262739129642016-01-252016-01-262016-01-26274034842016-01-272016-01-282016-01-29134197942016-01-272016-01-302016-01-292642109542016-01-272016-01-282016-01-302743143442016-01-272016-01-282016-01-30274486142016-01-282016-01-312016-01-302745122042016-01-282016-01-312016-01-31274674642016-01-292016-01-312016-01-312747123442016-01-292016-01-302016-01-312748101242016-01-302016-02-012016-02-02274960842016-01-312016-02-012016-02-02265087242016-01-312016-02-032016-02-023851104742016-02-012016-02-022016-02-03275276742016-02-032016-02-042016-02-05125396542016-02-032016-02-042016-02-05265453542016-02-042016-02-072016-02-072755117342016-02-042016-02-072016-02-062656124142016-02-042016-02-062016-02-072657130542016-02-042016-02-062016-02-06275850442016-02-052016-02-072016-02-07265956342016-02-052016-02-072016-02-06276015142016-02-062016-02-082016-02-07136127742016-02-062016-02-092016-02-09276220842016-02-072016-02-102016-02-101263107542016-02-072016-02-092016-02-092764118542016-02-072016-02-082016-02-09266599642016-02-082016-02-092016-02-112666125342016-02-092016-02-122016-02-12276752642016-02-092016-02-112016-02-10386838142016-02-102016-02-112016-02-132669141342016-02-102016-02-122016-02-1127705032016-02-112016-02-11NULL397179742016-02-112016-02-142016-02-122772138642016-02-122016-02-152016-02-13127361242016-02-122016-02-152016-02-14277426442016-02-132016-02-152016-02-15277558742016-02-142016-02-152016-02-172676932016-02-162016-02-16NULL267738542016-02-162016-02-192016-02-191278118242016-02-162016-02-182016-02-19277952942016-02-172016-02-202016-02-20138039742016-02-172016-02-202016-02-19268152142016-02-172016-02-192016-02-182682122342016-02-182016-02-212016-02-20268339342016-02-192016-02-202016-02-20138431742016-02-202016-02-222016-02-212785117442016-02-202016-02-232016-02-21278627642016-02-212016-02-222016-02-23278751642016-02-212016-02-222016-02-232688106942016-02-212016-02-222016-02-23268966842016-02-212016-02-242016-02-24389041442016-02-232016-02-252016-02-24279164842016-02-252016-02-272016-02-281292130942016-02-252016-02-282016-02-282793132842016-02-262016-02-282016-02-27139492942016-02-272016-02-282016-02-29129521842016-02-272016-02-292016-02-282796109442016-02-272016-02-292016-02-28279720442016-02-282016-02-292016-03-012798119442016-02-282016-02-292016-02-292699116542016-02-292016-03-012016-03-0339100123742016-03-012016-03-042016-03-032710127142016-03-012016-03-042016-03-043810233642016-03-022016-03-052016-03-032710399142016-03-032016-03-062016-03-0512104742016-03-032016-03-052016-03-052710530642016-03-032016-03-052016-03-042710642242016-03-042016-03-052016-03-053910763342016-03-062016-03-092016-03-09121081242016-03-062016-03-092016-03-0726109125542016-03-062016-03-092016-03-092611067742016-03-062016-03-082016-03-093911163042016-03-072016-03-102016-03-102611246942016-03-082016-03-112016-03-1026113107842016-03-082016-03-112016-03-1126114143142016-03-082016-03-102016-03-1127115136942016-03-092016-03-112016-03-112711647142016-03-102016-03-112016-03-112711774042016-03-102016-03-132016-03-112611857742016-03-122016-03-142016-03-131211992542016-03-122016-03-142016-03-142712032742016-03-142016-03-152016-03-172712175542016-03-142016-03-152016-03-162612278642016-03-142016-03-162016-03-152612376642016-03-152016-03-182016-03-172612440342016-03-162016-03-182016-03-171312568542016-03-162016-03-192016-03-1726126136542016-03-162016-03-182016-03-182712748442016-03-172016-03-182016-03-19381288642016-03-182016-03-202016-03-21261298442016-03-192016-03-212016-03-2127130104942016-03-192016-03-222016-03-202613131642016-03-192016-03-222016-03-20381324642016-03-202016-03-222016-03-231313340942016-03-202016-03-222016-03-212713467942016-03-202016-03-212016-03-2127135135442016-03-212016-03-232016-03-2327136119242016-03-212016-03-242016-03-233813737042016-03-232016-03-262016-03-252713843842016-03-232016-03-242016-03-252713971042016-03-232016-03-242016-03-2627140126442016-03-232016-03-262016-03-262714155742016-03-252016-03-272016-03-262714217042016-03-262016-03-272016-03-271314369342016-03-262016-03-282016-03-2827144112442016-03-262016-03-292016-03-292714536642016-03-272016-03-292016-03-302614628842016-03-282016-03-302016-03-30131475542016-03-282016-03-312016-03-312714871442016-03-282016-03-302016-03-302614976342016-03-282016-03-302016-03-292615033242016-03-292016-03-312016-04-011215192642016-03-292016-04-012016-03-31121527642016-03-292016-03-302016-03-302615349842016-03-302016-04-022016-04-0126154128642016-03-312016-04-012016-04-011215537142016-04-022016-04-032016-04-042615635742016-04-032016-04-062016-04-05131574342016-04-032016-04-062016-04-063815811732016-04-042016-04-04NULL391593242016-04-042016-04-062016-04-061216020542016-04-042016-04-062016-04-062716125142016-04-042016-04-072016-04-05271623142016-04-062016-04-082016-04-0713163132542016-04-062016-04-072016-04-072716461042016-04-072016-04-082016-04-092716557442016-04-082016-04-102016-04-101316633842016-04-082016-04-112016-04-1126167103442016-04-082016-04-092016-04-1127168114742016-04-092016-04-122016-04-11131699942016-04-102016-04-112016-04-1127170120042016-04-102016-04-112016-04-132717123742016-04-112016-04-142016-04-1413172107942016-04-112016-04-122016-04-142717311742016-04-112016-04-142016-04-1338174136142016-04-122016-04-132016-04-152717595142016-04-132016-04-142016-04-142617664342016-04-152016-04-162016-04-172717712142016-04-162016-04-192016-04-191217875642016-04-162016-04-172016-04-182617961642016-04-172016-04-192016-04-192618091842016-04-172016-04-202016-04-192718145942016-04-182016-04-202016-04-201318285442016-04-182016-04-192016-04-20261832242016-04-192016-04-202016-04-202718413442016-04-192016-04-212016-04-22271852432016-04-202016-04-20NULL12186112742016-04-212016-04-222016-04-242618718342016-04-222016-04-232016-04-242618839042016-04-222016-04-232016-04-2526189128842016-04-232016-04-242016-04-26121909842016-04-232016-04-252016-04-252619191942016-04-272016-04-282016-04-281219272842016-04-272016-04-282016-04-2927193136642016-04-282016-04-302016-04-301319455842016-04-282016-04-302016-05-012719572742016-04-282016-05-012016-05-0127196124742016-04-282016-04-302016-05-012619712742016-04-302016-05-032016-05-032719864042016-05-012016-05-042016-05-032619976042016-05-012016-05-042016-05-0427200107442016-05-012016-05-032016-05-0326

Sales Customers Table (SQL)

1DebraBurksNULLdebra.burks@yahoo.com9273 Thorne Ave. Orchard ParkNY141272KashaToddNULLkasha.todd@yahoo.com910 Vine Street CampbellCA950083TamekaFisherNULLtameka.fisher@aol.com769C Honey Creek St. Redondo BeachCA902784DarylSpenceNULLdaryl.spence@aol.com988 Pearl Lane UniondaleNY115535CharoletteRice(916) 381-6003charolette.rice@msn.com107 River Dr. SacramentoCA958206LyndseyBeanNULLlyndsey.bean@hotmail.com769 West Road FairportNY144507LatashaHays(716) 986-3359latasha.hays@hotmail.com7014 Manor Station Rd. BuffaloNY142158JacqulineDuncanNULLjacquline.duncan@yahoo.com15 Brown St. Jackson HeightsNY113729GenovevaBaldwinNULLgenoveva.baldwin@msn.com8550 Spruce Drive Port WashingtonNY1105010PameliaNewmanNULLpamelia.newman@gmail.com476 Chestnut Ave. MonroeNY1095011DeshawnMendozaNULLdeshawn.mendoza@yahoo.com8790 Cobblestone Street MonseyNY1095212RobbySykes(516) 583-7761robby.sykes@hotmail.com486 Rock Maple Street HempsteadNY1155013LashawnOrtizNULLlashawn.ortiz@msn.com27 Washington Rd. LongviewTX7560414GarryEspinozaNULLgarry.espinoza@hotmail.com7858 Rockaway Court ForneyTX7512615LinnieBranchNULLlinnie.branch@gmail.com314 South Columbia...