The Vegas Tours Souvenir Shop is where Las Vegas bus tours start and end, seven
ID: 3726802 • Letter: T
Question
The Vegas Tours Souvenir Shop is where Las Vegas bus tours start and end, seven days a week. The shop sells a variety of Vegas souvenirs to customers who take the tour and to those who simply want to purchase souvenirs. Management has been using an Access database to keep track of customers, products, and transactions. You have been given some sample sales data from February 2015. Management has asked you to create some queries to begin the process of analyzing the data that has been collected. 1. A series of SQL statements were made from the tables in the Access database. The SQL script contains CREATE TABLE statements as well as INSERT statements to populate the tables. Download the SQL script, VegasToursScript.Sql, from Blackboard, open and run the query in the Azure database. 2. Create a query based on the tblProduct table that will display the ProductID, ProductDescription, QuantityInStock, Cost, Size, and Color, in that order, for any product with shirt in the ProductDescription field. 3. Sort the results in Descending order by Cost (ORDER BY field DESC). Save the query as qryShirtInventory. 4. Create a query based on the tblProduct table that will display the ProductID, ProductDescription, Category, QuantityInStock, Cost, Size, Color, and a new calculated field named Retail Price, in that order. In the Retail Price field, use the Round function (ROUND(calculation,# of decimal places)) to display the price that the store needs to sell its products. The retail price is two times the cost. Save the query as qryRetailPrice 5. Create a query based on the tblCustomer table that will display the FirstName, LastName, Address, City, State, and ZipCode, in that order. Include customers whose last names begin with letters M through Z. 6. Sort the results in Ascending order by LastName. Save your query as qryMZCustomers. 7. Create a query based on the tblCustomer and tblPurchase tables that will concatenate the member’s first and last names (separated by a space) followed by the date they made a purchase. (CONCAT(field1,field2,etc) Name the concatenated field Purchase Details. Use a comma to separate the full name and date, in that order. Save your query as qryPurchaseDetails. 8. Create a query based on the tblPurchase and tblPurchaseLine tables that will display the PurchaseID, PurchaseDate, PurchaseLine, ProductID, and Quantity in that order to view all transactions. Sort the records by PurchaseDate. Save your query as qryPurchaseDate 9. Submit the 5 queries (qryShirtInventory, qryRetailPrice, qryMZCustomers, qryPurchaseDetails, qryPurchaseDate), through the Assignment link.
ROP TABLE tblPurchaseLine;
DROP TABLE tblPurchase;
DROP TABLE tblCustomer;
DROP TABLE tblProduct;
/****** Object: Table [dbo].[tblCustomer] Script Date: 3/6/2018 3:09:18 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tblCustomer](
[CustomerID] [int] IDENTITY(1,1) NOT NULL,
[FirstName] [nvarchar](20) NULL,
[LastName] [nvarchar](25) NULL,
[Address] [nvarchar](40) NULL,
[City] [nvarchar](25) NULL,
[State] [nvarchar](2) NULL,
[ZipCode] [nvarchar](5) NULL,
[Tour] [bit] NULL,
[mSysRowId] [nvarchar](255) NULL,
CONSTRAINT tblCustomer_PK PRIMARY KEY (CustomerID)
)
GO
/****** Object: Table [dbo].[tblProduct] Script Date: 3/6/2018 3:09:18 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tblProduct](
[ProductID] [int] IDENTITY(1,1) NOT NULL,
[ProductDescription] [nvarchar](40) NULL,
[Category] [nvarchar](15) NULL,
[QuantityInStock] [smallint] NULL,
[Cost] [money] NULL,
[Size] [nvarchar](10) NULL,
[Color] [nvarchar](15) NULL,
[mSysRowId] [nvarchar](255) NULL,
CONSTRAINT tblProduct_PK PRIMARY KEY (ProductID)
)
GO
/****** Object: Table [dbo].[tblPurchase] Script Date: 3/6/2018 3:09:18 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tblPurchase](
[PurchaseID] [int] IDENTITY(1,1) NOT NULL,
[PurchaseDate] [datetime] NULL,
[CustomerID] [int] NULL,
[mSysRowId] [nvarchar](255) NULL,
CONSTRAINT tblPurchase_PK PRIMARY KEY (PurchaseID),
CONSTRAINT PurchaseCustomer_FK1 FOREIGN KEY (CustomerID) REFERENCES tblCustomer(CustomerID)
)
GO
/****** Object: Table [dbo].[tblPurchaseLine] Script Date: 3/6/2018 3:09:18 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tblPurchaseLine](
[PurchaseID] [int] NULL,
[PurchaseLine] [int] IDENTITY(1,1) NOT NULL,
[ProductID] [int] NULL,
[Quantity] [int] NULL,
[mSysRowId] [nvarchar](255) NULL,
CONSTRAINT tblPurchaseLine_PK PRIMARY KEY (PurchaseLine),
CONSTRAINT PurchaseLinePurchase_FK1 FOREIGN KEY (PurchaseID) REFERENCES tblPurchase(PurchaseID),
CONSTRAINT PurchaseLineProduct_FK1 FOREIGN KEY (ProductID) REFERENCES tblProduct(ProductID)
)
GO
SET IDENTITY_INSERT [dbo].[tblCustomer] ON
INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (1, N'Trace', N'Debrow', N'3530 S Main St', N'Potomac', N'MD', N'20854', 1, N'AvXzCMNTBz8pYQML84Wx+rd4B8g2KzvkbCZiNK55UZo=-~sK6LR+LkChVqOqqrrq5+Zw==')
INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (2, N'Cynthia', N'Bryant', N'304 Obispo Canyon', N'Arroyo Grande', N'CA', N'93420', 1, N'UWI5YcXdfhCi35+eUqrQOaPtVnhMY+dwAWAMY3sKVZ8=-~jbu/8awyzX2aB6vamz/Qew==')
INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (3, N'John', N'Peters', N'56 Lake Drive', N'Blue Lake', N'CA', N'95525', 1, N'ad7C7+aLxPtmBH0r2Ty8C8ByHhUk9N3bXMGMpgT2j5Y=-~cicNRIjjJYeWdsQ6yax9qg==')
INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (4, N'Jessica', N'Nguyen', N'4003 Ridge Road', N'Dallas', N'TX', N'75217', 1, N'4jCbBw6uYrRU1g81Zm8gcaGp4GdBJJVqkleBglN8wgU=-~z1G95gPQhyOj+6bKORne8w==')
INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (5, N'Greg', N'Richardson', N'1030 Presidio Road', N'Albuquerque', N'NM', N'87114', 0, N'mUrq6H4sxwM1c9mAjPkV9VohPCBWGxSIMxA3vy8clCY=-~WC7hkSO1JR2NyAZ6bej5sw==')
INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (6, N'Jenny', N'Branson', N'3223 El Grande Ln', N'La Mesa', N'CA', N'92010', 1, N'V6b22lbZYnR27hGvwwrmxPPXttelko3HMbmOlHczCks=-~NyhPcNSKpdMRNiHNtasPGg==')
INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (7, N'Sara', N'Trumbull', N'544 E. Westerly St', N'Ann Arbor', N'MI', N'48104', 0, N'n8jPm3V9RQi9v3WcDUboeKpfkeFnqvuO225Bik8jJGg=-~IwY6FrLXQuv/+oEDMjHWJQ==')
INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (8, N'James', N'Ford', N'6127 Fender Dr', N'Cranbury', N'NJ', N'07815', 1, N'xVw0DtFLKUHZf5qlSgdt/lJyr0onZ4XtScY3kH1SlDY=-~QhvMuJ1NbtZA1Ko+LVqixA==')
INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (9, N'Elaine', N'Griffin', N'134 Desert Ln', N'San Luis', N'AZ', N'85350', 1, N'xY+PioVtW9MVlINvDy3FY/C1Dno1o+AIdBz+NCbxyc0=-~we8MfDn59+mJBEx1OeRJYA==')
INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (10, N'Harry', N'Preston', N'455 Fredonia Ave', N'Herkimer', N'NY', N'15253', 0, N'BMRU3HUqkeHzqFaSBFWg4/pPssFh07f33iMpha88XbE=-~aNx5BCkZek2OT2kszqAvPw==')
INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (11, N'Erin', N'Thomas', N'9214 Cardinal Ln', N'Fairfax', N'VA', N'23020', 1, N'//y7/sqBANL/bsnhEo4QtP5XMzRSVtwcLphMIUk++wM=-~rfcBE1uX7PjMwhSP8SOQnQ==')
INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (12, N'Jack', N'Dixon', NULL, NULL, NULL, NULL, 0, N'tbrsKuE7Mcw2AWJOGxxMqED2IPVYIwY2DgB8iU+l7kM=-~eno3vUAMlP14Qd4osLulKQ==')
INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (13, N'Cheryl', N'Montaigne', N'713 Diablo St', N'Sandiston', N'OH', N'44301', 1, N'6/p+4GsJ6IjUc5tcto+SOkMRi4TNLB6JyKG+IGROyq0=-~qelU8bnaF2VhPvIzbtDl4Q==')
INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (14, N'Mark', N'Mason', N'104 Treasure Ln', N'Brookline', N'MA', N'02445', 0, N'ci/3yvj8FvxJOCKgPzFAzs2MLRCpkICR6KzfMh4BiRs=-~c9in9NXXT53WCRCZ9LZQFA==')
INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (15, N'Chris', N'Serway', N'2575 Purdy St', N'Fanwood', N'NJ', N'07023', 1, N'6h+Q2ULutLsfjwoV+bx0CCOBAT+qJN8DPq91/zFD/qA=-~Z8Y7ofpCf2sn5JPXknBhuA==')
INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (16, N'Coby', N'Alvarado', N'544-8187 Praesent Rd.', N'Menomonee Falls', N'IA', N'72490', 1, N'/a0KQBIU1nrhgEcG8bRxZHb3Mn3LyvE2bg15V8r97e8=-~5rNULvAKRFP0L9BUmE4dBQ==')
INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (17, N'Anthony', N'Brooks', N'P.O. Box 999, 424 Pharetra. Street', N'Hammond', N'NY', N'49211', 1, N'2Hyi8l3KS1hBuj3VwIErFAPmhHuwTbK7dXtGADxaqAA=-~OqlV94KS3KB2lmZYIcg+kw==')
INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (18, N'Erich', N'Green', NULL, NULL, NULL, NULL, 1, N'U4JudXycBOuf9o4SvHiY4UtbTTrOUAelLeh8d+/ZTiM=-~SmnUXlvtpR3Daz5v5HiyvA==')
INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (19, N'Jennifer', N'Baker', NULL, NULL, NULL, NULL, 0, N'Iat+HEYIw+7trer65MLU6QmJxQRp6phnpg2ULaI4aYM=-~mfgWlO3ZeskYXb5G95aG7w==')
INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (20, N'Sylvia', N'Vasquez', N'8676 Libero Rd.', N'Palo Alto', N'WA', N'82071', 0, N'vdcuMLupg3sNyd4QKJOUanHZaHud4mYfZfpX4LZbyOA=-~IZxr9LcnDvo0dp2Lerq3mQ==')
INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (21, N'Kiara', N'Schroeder', N'6508 Dolor Street', N'Arlington', N'MI', N'78934', 0, N'vXqeUGaQE1cMH/4Urnut0R+l198P0xtP+32KoYhRZ/I=-~ODJDnsJD1+R7YDa5G7f0aQ==')
INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (22, N'Kenneth', N'Cole', N'Ap #224-7470 Aliquet Av.', N'Hartford', N'AK', N'94076', 1, N'hY2u2x2i4fzsHu+tO4UTRq5I8zTPgsOEIrQKFjJJMkg=-~erqXWKWmk7boy6kUoVyAdw==')
INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (23, N'Margaret', N'Marks', N'Ap #779-9435 Egestas Avenue', N'Warwick', N'IN', N'13968', 1, N'Tr1F2Q4jn7+VhEWuE61hsuHKyk8FIFUVVObQiJ9U8C8=-~N7M1J1JWMZkHJSj6dHTu/A==')
INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (24, N'Calvin', N'White', N'P.O. Box 549, 2220 Eget Av.', N'Claremore', N'OH', N'23889', 1, N'inGIEwmf+gXVkBw8s50NnTiZfF5T2UcldWxpU7FbsTw=-~VjObQhCuBy0UkTfn8HHXSA==')
INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (25, N'Hyacinth', N'Zamora', N'8255 Risus Avenue', N'Statesboro', N'AK', N'15474', 1, N'F5IpkNJbZS0x8uDWBL2kG5wZLQN0UH9h3AdZgQ+m1K0=-~FBC/1lts3I5s50eGp7yE+w==')
SET IDENTITY_INSERT [dbo].[tblCustomer] OFF
SET IDENTITY_INSERT [dbo].[tblProduct] ON
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (1, N'Key chain (dice)', N'Sundries', 40, 4.9200, NULL, NULL, N'Legp1E62133Ve0EVJCIj5LOr/N4jaU7kk/M+rF1vhW8=-~usCrBB3uFP8k0IIZBx2EHA==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (2, N'Key chain (Vegas sign)', N'Sundries', 35, 7.0300, NULL, NULL, N'yXtj1/IDWyFiwg4FXO39JRAkXb3foonPNg21oRO2eXc=-~T3KJHnfHQQhkXb1rR3CMgA==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (3, N'Mug (dice)', N'Sundries', 50, 3.2300, NULL, NULL, N'o6T9BoRKYh2Ppu/L2c6pmFETiqq/otfGy3e4mqjP3Gs=-~pTmKqwnsIL0M0IUVRmokeA==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (4, N'Mug (Vegas sign)', N'Sundries', 30, 6.6100, NULL, NULL, N'Tfe0Klbo55IMVUMW2cd63eulUVUxriHyu2rwNqW8acA=-~3sRvXkhyceC3Y6lCAyrUAA==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (5, N'Poker chips', N'Sundries', 20, 11.4700, NULL, NULL, N'u3U1I1KuE3cGg4YPFK2OFfs19MiB7EdO5Zgw0gVPcjw=-~ub3wGw8ME7RxfyfMaAP1hw==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (6, N'Poker set', N'Sundries', 40, 22.4400, NULL, NULL, N'kkXvZPW1djtD1TFAvyKivBiKIRYdPLtL5i9vfQl+UXU=-~dTH46BKEIo/On9VJBWkrTw==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (7, N'Snow globe', N'Sundries', 50, 14.7900, NULL, NULL, N'/VNZwxa82OxrID1QAciwCI2qnKi4fR/WPZzL7NwJ8LY=-~AdgVljdLi/pwWy++XC+N2w==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (8, N'LS Sweatshirt', N'Clothing', 20, 7.4200, N'S', N'Black', N'4y098SyoyJozlW1nXbzAE3H+4blfKC8jWODtJQ1SEbI=-~wEnq+MjghHak6//yQ8cJrA==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (9, N'LS Sweatshirt', N'Clothing', 17, 14.7900, N'S', N'Red', N'I8vtooZ/KOgF5v1OmWOnr7pBlb+XGx+4vT3J9iRGykA=-~kw8RAKH8/51cp6EYX94V+g==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (10, N'LS Sweatshirt', N'Clothing', 16, 11.4700, N'S', N'Silver', N'qA/wr4+Xd1MMOZC+Crs6CBzTYPv/vGknACV9DVn6I9w=-~MNzJ7iL221QcfuMqXZ0a8w==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (11, N'LS Sweatshirt', N'Clothing', 30, 4.9200, N'M', N'Black', N'4/tDRIEgIRGXDDivloNxq0WcPHvvG/lveef31DAVWQ4=-~ZgvzhrvEJOsNhqvd3tTirA==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (12, N'LS Sweatshirt', N'Clothing', 15, 12.0300, N'M', N'Red', N'Ee8ArM/TJ2fgl4uLz2QsPL1btdxaGj6bmt1Fs6MSgCA=-~itASxvOOSVzKjS71Ew0UEw==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (13, N'LS Sweatshirt', N'Clothing', 18, 4.9200, N'M', N'Silver', N'uLYAoDvF95OLdXkc9D6MNOoIDDm6szyn3Gfjz57aL40=-~C6wmn9M6UKF1kV1dUqdXuw==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (14, N'LS Sweatshirt', N'Clothing', 30, 14.7900, N'L', N'Black', N'2o3UQW4JpDt+OHdjj1Oabl0tTm+UB8xXTYK1RAftFx8=-~7T4gQ3R+z5dP82fi0/+VTA==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (15, N'LS Sweatshirt', N'Clothing', 15, 9.2300, N'L', N'Red', N'1PgiWVOM8UU01MhZEgzAk8oyYy21O3G93nkZZRbTIlQ=-~IGxonV/PzA8ceu6y81DRjQ==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (16, N'LS Sweatshirt', N'Clothing', 18, 14.7900, N'L', N'Silver', N'tNA07KVC75tpJ5DJKEHymNBO3DSgWWzrgCjHNPJzGRc=-~Uf6w+solgVtF18bIGvXNdw==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (17, N'LS Sweatshirt', N'Clothing', 32, 9.2300, N'XL', N'Black', N'SkTVu07XIHgCehi+tNw8j9l8/4pnGqS9fPKymvlq/N4=-~rOie466/V0zaRCBS3ay0yg==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (18, N'LS Sweatshirt', N'Clothing', 17, 11.4700, N'XL', N'Red', N'4Xd21PO4KMDKC3qnF6kkdezffRi4HkK6EMW4uma6pMQ=-~J31iTqClCctEPJHTXctSuw==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (19, N'LS Sweatshirt', N'Clothing', 18, 14.7900, N'XL', N'Silver', N'uSmr6jOFZgqSdAA/fGkbShiVw0usa18rcFrzt4hcBgA=-~p1pRhL0JGny3Mg0eOyT+Ew==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (20, N'T-shirt', N'Clothing', 50, 12.0300, N'S', N'Black', N'GVuhSu08pR72t2jwYqp4a8F51LMdxzIAEU2eUwbRQFQ=-~tRRiZjd3p0yLEWklw0sfAg==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (21, N'T-shirt', N'Clothing', 24, 7.4200, N'S', N'Red', N'nKr32LS4AYvLmTvo9yPrGj/vI/E4x3GtqZ7JhxjJbNA=-~roxoca0Ux+zjJtBXYYg8TQ==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (22, N'T-shirt', N'Clothing', 33, 14.7900, N'S', N'Silver', N'fPaZdAfbmx+QARiYvCGxnyuYNetqObZxKRG9quHp/eM=-~P5p7QgJORoe8O2gBt79tcg==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (23, N'T-shirt', N'Clothing', 60, 9.6100, N'M', N'Black', N'gpOHUd7acpJo9IQ5dYqas7Djuj4cob+1AKEAq8cnKk8=-~ij+LhBu2Vq8/gRRQzWjsvg==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (24, N'T-shirt', N'Clothing', 54, 11.4700, N'M', N'Red', N'PyfnglxZGv8ReTkc8hy5Ms2sgUtYPoYU03h0ZhjslzU=-~B6EDiSbMszhbshBSoSxcAA==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (25, N'T-shirt', N'Clothing', 57, 12.0300, N'M', N'Silver', N'+8F4ujNBNDK5H6s59csX4NxdrwEqPVsrodj5dklcQzY=-~PTQaN6TAVK6RSWTtMaKZHA==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (26, N'T-shirt', N'Clothing', 30, 4.9200, N'L', N'Black', N'AK2Zmx5bpmhVcFlaKEFsjfaFNzXEflQR5UvXARj0Q/o=-~jzfTaOcJtL4KjHKWru56LQ==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (27, N'T-shirt', N'Clothing', 40, 4.9200, N'L', N'Red', N'Ryp2px77Dnb2l78GI0HaiRh0NOqW3GmOMSoX4TAXaY0=-~094IA6AWorfD1a9u88t9Nw==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (28, N'T-shirt', N'Clothing', 20, 11.4700, N'L', N'Silver', N'7U8/OWz5RX9B4bPOamL94EsWD6c82SM3ICuyFEkeNx0=-~0hRDwh0EASwHlYBfp7CvBw==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (29, N'T-shirt', N'Clothing', 15, 11.4700, N'XL', N'Black', N'qQrecm5dXAioazpP2cDPOB0Wliiw8EOidkgZG2gTkXo=-~XSlgCLgXO522YC6JCRfzWg==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (30, N'T-shirt', N'Clothing', 30, 9.2300, N'XL', N'Red', N'Kbn3480KtSkH7vSVXPQ1alc0raQyRWsGbWUyHd3y2to=-~12wt69hfOVZp70h5yH/F0Q==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (31, N'T-shirt', N'Clothing', 10, 14.7900, N'XL', N'Silver', N'uJfBSaXIuCjCWhVWdNMh5DzEDWTOVif/I6H+lgKDZ+s=-~5XwSFjBnM6xkEEyNDdRSnA==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (32, N'Bib (dice)', N'Baby', 50, 2.6100, NULL, N'White', N'jsEGZUPzXD2h9CO9f5Lv29GFqJGxB/NH7cwl60/V0mI=-~ECtE1qo+87VvaUPYMLgz/w==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (33, N'Bib (Vegas sign)', N'Baby', 50, 2.7900, NULL, N'White', N'jL6X6sDqFfeB7iP48bFVPtwzH1q5rjO12261Q4n5PjQ=-~QwJewyiKFloL4CO8JJYuLQ==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (34, N'Pacifier', N'Baby', 50, 1.0300, NULL, N'Red', N'nmikUoDCRvo7/hXJeagn/XYj806eqcquUXvIuOAYpNs=-~OaCipDxwbbX3Wk9LrBEszw==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (35, N'Pacifier', N'Baby', 50, 1.0300, NULL, N'Black', N'rAL8/YiM7xy4GKapyB9Brn0JSWeIT/ljt+P1Dj97W/c=-~AHtVtBHFnBODgkepuhX7Xg==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (36, N'Mug (Vegas sign)', N'Baby', 100, 9.2300, NULL, NULL, N'92F4QjyVOkwaF4ZTXknQg285Grn4CTEp6lIAZj7gKKQ=-~dtiaZELCkqagYqEnMdYf8Q==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (37, N'Onesie (dice)', N'Baby', 94, 6.0300, NULL, NULL, N'hdRRNETHXBlAq9PcwrCGre+wkuCbF/fj7geDMH2LpzQ=-~qGUrKj7h1bNyqI/X1kDpxQ==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (38, N'Onesie (Vegas sign)', N'Baby', 80, 6.0300, NULL, NULL, N'knkxOV+PpF9VmT1bOztgJq5D1pR+qwQgok2nWXce9fI=-~FfR/OwALJIfBKplov6guqw==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (39, N'T-shirt (dice)', N'Baby', 40, 3.4200, NULL, NULL, N'1qeWZgLxWeUrEScIfuAw400oTG0CzPWewYvsB+PO5e8=-~EKokBf2wnJsFB/l/sRqU4g==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (40, N'T-shirt (Vegas sign)', N'Baby', 30, 3.4200, NULL, NULL, N'Pcud3we4KIqu2VrbiJZHeTeN2QbjGImtjQwHj1X1emc=-~5fiypT8sRGT+5PRpaCaPyg==')
INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (41, N'Plate, cup, & utensil set', N'Baby', 18, 9.2300, NULL, NULL, N'N/pPXi7xyXEQXbkQ7MDKFMIuuxMwjsOJYKOTuqQjM+4=-~z6o8zXwqe5BN2apjNLFH3g==')
SET IDENTITY_INSERT [dbo].[tblProduct] OFF
SET IDENTITY_INSERT [dbo].[tblPurchase] ON
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (1, CAST(N'2015-02-03 00:00:00.000' AS DateTime), 1, N'p/AvYFrA9uY+vmYAgPNG2qPozL0LLSDYndnaKNVUdf8=-~kJvjZTuTmmhW7yjePjfdzg==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (2, CAST(N'2015-02-04 00:00:00.000' AS DateTime), 2, N'g5vjswSkv7FIdFbIvIe6Dfn+9JPIzuz3pSNlHPJVi40=-~3OjeLkamJkLFk14ia8jmlA==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (3, CAST(N'2015-02-07 00:00:00.000' AS DateTime), 3, N'nWEA5Z9HfD/li6aH7ApzC1Vc/+NQy/LfxCqj866e374=-~URP7iA2YbIvcWhjE6I4aXA==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (4, CAST(N'2015-02-09 00:00:00.000' AS DateTime), 4, N'ofgHz8bJoqc8fPTPcbVixWJi7BOayRgcT5Ch5MVnMqA=-~hIRsprnq97dc35Ww781s7A==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (5, CAST(N'2015-02-10 00:00:00.000' AS DateTime), 5, N'ykhKJiXxzumA/95kqrHcfLwbnWjlQLuKMsvUedB7TJA=-~FXqX25fjfUDzjfX+xYc40Q==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (6, CAST(N'2015-02-11 00:00:00.000' AS DateTime), 6, N'PNZNoD0YfxaK4Ws0x7Kcm7twdKKgAJVwqRW3L1MIW4E=-~FnsKj8BezaXYKc+GRmxFIQ==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (7, CAST(N'2015-02-11 00:00:00.000' AS DateTime), 6, N'dGXPJKJSJKdGStKMMGEBGHtb+ka8yRcC+ibs3uh4IT0=-~AsKYTJdeKecvR1HihB/8Vg==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (8, CAST(N'2015-02-16 00:00:00.000' AS DateTime), 7, N'xLlR4QzRHvjObgUrJ9IB746rdvRx7M7Q1sxVzxb7z90=-~yU8wfoOtJrIoGY3WXaD6Gg==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (9, CAST(N'2015-02-16 00:00:00.000' AS DateTime), 8, N'p0m2dQs5NXSSs8Ecrf2x5DDzjIXEj5eTOspX6HhqCgs=-~26bIu8+Gd+4J7hRnZxU+Qw==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (10, CAST(N'2015-02-16 00:00:00.000' AS DateTime), 9, N'KPL2VtSfZ9+EggocYDNy7FlHFq9/AuP8fg9Sn+4mQ3c=-~XSpMxQI4lB/zgNcy05sS6A==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (11, CAST(N'2015-02-17 00:00:00.000' AS DateTime), 4, N'oVsz5YvIy1QNSGjCb1Tos/8pg73l4uVgSVpcRAPrlg4=-~+QywAr3iRiyfh/CRL9k73Q==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (12, CAST(N'2015-02-18 00:00:00.000' AS DateTime), 10, N'khrr1c1ejyv8tqM4Qb8aJzNgXg1R6US9T5yKOCTIbhI=-~kA5J3Ddv3Lhll2qJV2LBTg==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (13, CAST(N'2015-02-19 00:00:00.000' AS DateTime), 11, N'cjrrlGUiWEV8yQTKbrQxrxrHbS1Z5Y1nF77HefHRjko=-~zyNuMgQ67uCHGn8IUUSjXw==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (14, CAST(N'2015-02-19 00:00:00.000' AS DateTime), 12, N'xvKgJaJYGjv9QHTgwJXuOkoJcZJEXDL4MBDRw78azlU=-~z0+4FcxdOQRE5INRLqmFFw==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (15, CAST(N'2015-02-21 00:00:00.000' AS DateTime), 13, N'NlQ7WtQrzxqdiggQhQch5lCEFK1JSqtWwuE1EJhMqf4=-~tMUWArTqd7cuDtA4ayBHOA==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (16, CAST(N'2015-02-23 00:00:00.000' AS DateTime), 14, N'okVLJnk6B3LiNsE8b1FA1dtmHo4V98CIs68YpzHoemU=-~HX3qPu7hLNYpDLoi1VRG3A==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (17, CAST(N'2015-02-24 00:00:00.000' AS DateTime), 15, N't7Rq45Ld9/YHkz5eBG+s4xIMP7Uqs6Um+1Z3rnnsYHc=-~uw2LKwGvFyFh6UvevIgH6g==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (18, CAST(N'2015-02-25 00:00:00.000' AS DateTime), 9, N'No5fbsNYcEg/TQTmXoAv7lVzvIWq2sVYLwxRqkrpqTs=-~Ug0/9N/N4UDMVsoJ7b/aDA==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (20, CAST(N'2015-02-02 00:00:00.000' AS DateTime), 17, N'17WIz55gpEmw11uIj7V18YhD2iVc6oYwlHnytq6kpT0=-~RvGuvD3ib4hd/oDxuNm3WQ==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (29, CAST(N'2015-02-04 00:00:00.000' AS DateTime), 2, N'CK7U+Hcyy0fKzYjVFwFOiAxznC9AL6aoUdt6V+6By0E=-~ePlpDFfefCiovDb+0wqhwA==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (33, CAST(N'2015-02-04 00:00:00.000' AS DateTime), 4, N'1xPgAGKoxkP+PKm+Nq0MrfRsvvpgPtaO8Y80Ns9NB8M=-~Uw3peOWY5OQ0/fQMefFXVQ==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (41, CAST(N'2015-02-02 00:00:00.000' AS DateTime), 3, N'OKC4BP+Y0KiyCADuL8EIZQICfHjfYq6coRLkrqyeYiU=-~Wm77NtTbOufeYtguBjvNMQ==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (42, CAST(N'2015-02-13 00:00:00.000' AS DateTime), 18, N'G6ULfdgOBvTgd5O9E2ygs2WSgKJL2PLyAJj/G8QXLOI=-~EgISHXToHoQJ2GTImt3chw==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (43, CAST(N'2015-02-15 00:00:00.000' AS DateTime), 23, N'IV6Nuif0fNyk2M0+GsEYRVZrTRhDIFVcH4Ti8Piimbw=-~1VxnkMp3GBN+CShvdDfDNw==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (45, CAST(N'2015-02-15 00:00:00.000' AS DateTime), 24, N'jfJ4OTaeOEo5mW969Oyi9HYLg5/0t7/dsyl/280yGRU=-~fy027R+msD0YTViJGljM9Q==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (49, CAST(N'2015-02-26 00:00:00.000' AS DateTime), 15, N'SlL0Ytbk/srrDY3fxVIQkBmKdhltsg+XgQdUJY/h7Z0=-~XpY6pxzrQ3j1czXK2rUjIw==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (54, CAST(N'2015-02-13 00:00:00.000' AS DateTime), 18, N'VvzOG8/L5NBrk53vSG29pqJBzP2G0rUfMYfO9LecETQ=-~DSj9hOY84Gf2NIo/g7LuRw==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (55, CAST(N'2015-02-13 00:00:00.000' AS DateTime), 4, N'QU3HdnltOP/D16cZ6eM0nS5QFL1CGOTWJliLR4Casgk=-~1N+Hokn81vXsKe2JbqFsYA==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (57, CAST(N'2015-02-08 00:00:00.000' AS DateTime), 14, N'dtHLffAof8BAsFhUuAJ/5DKV1r1tVAPjrMyx5MG1FC8=-~LTOBDzwl/gd4W+fsRpuwgg==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (60, CAST(N'2015-02-13 00:00:00.000' AS DateTime), 16, N'h7ubCoEDCmqpx866EFgjr/vgADXLtMZpAUfrpTJdScQ=-~yBGoDhhZNZw4bKIIcJJsyA==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (65, CAST(N'2015-02-23 00:00:00.000' AS DateTime), 21, N'/eGiX5w7EqZr2NWl6ec5F/sRUtTx00iygCsnPdJ7WjY=-~vhn/WudhOmT1H3N8VT67Eg==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (66, CAST(N'2015-02-07 00:00:00.000' AS DateTime), 2, N'reyTrsnqHjC91MWHizRTkQFVcEyRLow2VA+BWRS13iw=-~MjeyVh48BoD2Q1/Hf9CvTw==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (68, CAST(N'2015-02-21 00:00:00.000' AS DateTime), 10, N'LuLmpulesy/x82zlSAIna9IN+fAkxSsexBh7X/TRj0E=-~JUoDZ38RFASHLvJBLFaFVg==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (74, CAST(N'2015-02-26 00:00:00.000' AS DateTime), 14, N'nJZKVG7PjPcsK0baRKGBZhJr/2fzCBqg0d0F7eV3qXY=-~oGXnc9pe9uZiuQTT8+baWA==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (76, CAST(N'2015-02-12 00:00:00.000' AS DateTime), 24, N'OmTMu5q4NnBm1xZY1hLC5cZ8axXjNTRAdNeWvPoHgsM=-~QP0bkPYbNrv2bMEoyV2Mog==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (78, CAST(N'2015-02-02 00:00:00.000' AS DateTime), 21, N'3mWa0j7BSR1ACkzdE7RDtvwvfVoDzRXAt0BZxkiWj0s=-~dDcbmHIvYpp1YbLSpI++zQ==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (80, CAST(N'2015-02-08 00:00:00.000' AS DateTime), 9, N'A5IUesLnj+XLu4WH+RuIMrhgoYYvaVXO1wPkC9x0r1I=-~P/FQ/fgRRsJWe1n9vKfI9w==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (81, CAST(N'2015-02-10 00:00:00.000' AS DateTime), 12, N'4kqG+73vC7eYXjpuMJ/9SlODI39fdsHirICOuBDmO9k=-~akrVJ1hv442zHCaGEzelbg==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (88, CAST(N'2015-02-07 00:00:00.000' AS DateTime), 9, N'hZSY/PJPBvF6ySnYcNa5M6aDQDxjTPuAoyFJIb0xRw0=-~Jxk1OVw/eZ3DEw1iopdDZQ==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (89, CAST(N'2015-02-01 00:00:00.000' AS DateTime), 18, N'bS92fqWZRVztH7nuzp53hL+mS3CbBMB1uRzAJBwKpuI=-~fQGopUQrVpmrvjoDhmTPNA==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (91, CAST(N'2015-02-07 00:00:00.000' AS DateTime), 25, N'hLtJFNBVB5/IpY+N3nNlJkPQtWFJwKjUxfkepx/MO+g=-~rU5p1uw7SlmhDOzHgNKM9w==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (92, CAST(N'2015-02-18 00:00:00.000' AS DateTime), 6, N'Vka9vspQYu5865AvlqRoCGNVhO5TVhw1/F6jiO8kRxI=-~wk+DHwo0diL8cV2kazGWqA==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (101, CAST(N'2015-02-22 00:00:00.000' AS DateTime), 8, N'UMqGCBpKowq06EhWVTEzYUvqklHtSnQ3J7ED+CiFuGs=-~ykoF8Tn5Da06CtERBcKCkQ==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (104, CAST(N'2015-02-20 00:00:00.000' AS DateTime), 8, N'KXQ321FZdxf9y/0c658rhhUQmCFhECrniqjc8NpXGjY=-~sghH924oL3NLszDVqDJnJQ==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (106, CAST(N'2015-02-09 00:00:00.000' AS DateTime), 17, N'7HEVmx9+lLj4QeNs+LO6g6+yo1O0ifm8ADqMclCNCds=-~xi/bKovxe7KKf5/LeSoj+Q==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (110, CAST(N'2015-02-14 00:00:00.000' AS DateTime), 23, N'rlNOb9U6pqqyxB1xprdXzgsEDKk8U5fzskPkrXs7wtI=-~c9HLQJzxfMeEeBorR4yZ8A==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (119, CAST(N'2015-02-15 00:00:00.000' AS DateTime), 4, N'1cRq0ZGlVyeDu4Mco32DOA6Wi88xCALWBtYHZqxgRXA=-~XhCCOcSCb2AqwRft47I7lw==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (120, CAST(N'2015-02-09 00:00:00.000' AS DateTime), 17, N'rVwm7I4vCQovsqtVdUSC5sJJ2FUIpXdkrFY/hgkKGwY=-~z11oIqia22j/QHWunIks4Q==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (123, CAST(N'2015-02-24 00:00:00.000' AS DateTime), 23, N'UHVzpnE8pFMEBqk9y5d9OpjnrJJtGuKcP+LIRd5HpCU=-~kHwgYsiiCtB/dYu0ZHMhDw==')
INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (124, CAST(N'2015-02-05 00:00:00.000' AS DateTime), 19, N'KmlXefP8O2EioEvPS8qz9BYCARb3wbesH7gKkSx7sVI=-~jYsZEjH94uL/U2p8HCHUIQ==')
SET IDENTITY_INSERT [dbo].[tblPurchase] OFF
SET IDENTITY_INSERT [dbo].[tblPurchaseLine] ON
Explanation / Answer
The five queries are listed below-
2 & 3) This query will give the product detail of the product thats contains 'shirt' in their description. LIKE is used in WHERE clause to match the string.
Query- qryShirtInventory
SELECT ProductID, ProductDescription, Category, QuantityInStock, Cost, Size, Color
FROM dbo.tblProduct
WHERE ProductDescription LIKE '%shirt%'
ORDER BY Cost DESC;
4) ROUND() function is used to calculate the retail price of the product.
Query- qryRetailPrice
SELECT ProductID, ProductDescription, Category, QuantityInStock, Cost, Size
Color, ROUND(Cost*2, 2) AS Retail_Price
FROM dbo.tblProduct;
5&6) For this query also LIKE is used in WHERE clause to get the customer detail whose last name starts with 'M'.
Query- qryMZCustomers
SELECT CustomerID, FirstName, LastName, Address, City, State, ZipCode
FROM dbo.tblCustomer
WHERE LastName LIKE 'M%'
ORDER BY LastName ;
7) CONCAT function is used to concat customer first name, last name and purchase date of the product.
Query- qryPurchaseDetails
SELECT CONCAT(c.FirstName, ' ', c.LastName,',' , p.PurchaseDate) AS Purchase_Detail
FROM dbo.tblCustomer AS c
INNER JOIN dbo.tblPurchase AS p
ON p.CustomerID = c.CustomerID;
8) Table purchase and purchaseLine are joined based on ProductID.
Query- qryPurchaseDate
SELECT p.PurchaseID, p.PurchaseDate, pl.PurchaseLine, pl.ProductID, pl.Quantity
FROM dbo.tblPurchase AS p
INNER JOIN dbo.tblPurchaseLine AS pl
ON p.PurchaseID = pl.PurchaseID
ORDER BY p.PurchaseDate;
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.