SQL Database Insert and Retrieve

The provided content appears to be a series of SQL INSERT statements used to populate a database table called [dbo].[Sales]. The table has ten columns: FirstName, LastName, StreetAddress, City, State, Zipcode, StoreID, ProductID, Quantity, and SalesID. Each INSERT statement provides values for these columns, likely representing individual sales transactions.

USE [AllApplianceCo]
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Orlando', N'Gee', N'8713 Yosemite Ct.',
N'Houston', N'TX', N'77001', 11, 6, 1, 15001)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Keith', N'Harris', N'1318 Lasalle
Street', N'Houston', N'TX', N'77005', 15, 1, 1,
15002)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Donna', N'Carreras', N'9178 Jumping
St.', N'Houston', N'TX', N'77001', 11, 1, 1,
15003)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Janet', N'Gates', N'9228 Via Del Sol',
N'Houston', N'TX', N'77005', 15, 2, 2, 15004)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Lucy', N'Harrington', N'26910 Indela
Road', N'Tulsa', N'OK', N'74101', 13, 2, 1, 15005)
GO

INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Rosmarie', N'Carroll', N'2681 Eagle
Peak', N'Tulsa', N'OK', N'74105', 13, 2, 2, 15006)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Dominic', N'Gash', N'7943 Walnut Ave',
N'Tulsa', N'OK', N'74121', 14, 1, 1, 15007)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Kathleen', N'Garza', N'6388 Lake City
Way', N'Tulsa', N'OK', N'74129', 14, 3, 2, 15008)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Katherine', N'Harding', N'52560 Free
Street', N'Tulsa', N'OK', N'74129', 14, 4, 1,
15009)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Johnny', N'Caprio', N'22580 Free
Street', N'Tulsa', N'OK', N'74133', 13, 2, 1,
15010)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])

VALUES (N'Christopher', N'Beck', N'2575 Bloor
Street East', N'Memphis', N'TN', N'38105', 17, 2,
1, 15011)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'David', N'Liu', N'1484 Jacob Road',
N'Memphis', N'TN', N'38108', 17, 3, 1, 15012)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'John', N'Beaver', N'575 Rue St Amable',
N'Memphis', N'TN', N'38109', 17, 2, 1, 15013)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Jean', N'Handley', N'2512-4th Ave Sw',
N'Memphis', N'TN', N'38109', 17, 3, 2, 15014)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Jinghao', N'Liu', N'55 Lakeshore Blvd
East', N'Memphis', N'TN', N'38101', 17, 5, 1,
15015)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Linda', N'Burnett', N'6333 Cote Vertu',
N'Memphis', N'TN', N'38102', 17, 3, 2, 15016)
GO

INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Kerim', N'Hanif', N'3255 Front Street
West', N'Memphis', N'TN', N'38102', 17, 2, 1,
15017)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Kevin', N'Liu', N'2550 Signet Drive',
N'Memphis', N'TN', N'38103', 17, 2, 1, 15018)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Donald', N'Blanton', N'6777 Kingsway',
N'Houston', N'TX', N'77001', 11, 7, 2, 15019)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Jackie', N'Blackwell', N'5250 Burning
St', N'Houston', N'TX', N'77005', 15, 1, 1, 15020)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Bryan', N'Hamilton', N'600 Slater
Street', N'Houston', N'TX', N'77001', 11, 6, 2,
15021)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])

VALUES (N'Todd', N'Logan', N'25575 The Queensway',
N'Houston', N'TX', N'77005', 15, 2, 2, 15022)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Barbara', N'German', N'2521 McPherson
Street', N'Tulsa', N'OK', N'74101', 13, 2, 1,
15023)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Jim', N'Geist', N'2560 Bay Street',
N'Tulsa', N'OK', N'74105', 13, 2, 1, 15024)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Betty', N'Haines', N'630 University
Avenue', N'Tulsa', N'OK', N'74121', 14, 3, 2,
15025)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Sharon', N'Looney', N'992 St Clair Ave
East', N'Tulsa', N'OK', N'74129', 14, 3, 2, 15026)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Darren', N'Gehring', N'99, Rue Saint-
pierre', N'Tulsa', N'OK', N'74129', 14, 4, 2,
15027)

GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Erin', N'Hagens', N'25245 Sherbrooke
St', N'Tulsa', N'OK', N'74133', 13, 2, 1, 15028)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Jeremy', N'Los', N'655-4th Ave S.W.',
N'Houston', N'TX', N'77017', 11, 1, 1, 15029)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Elsa', N'Leavitt', N'25900-700-9th Ave
S.W.', N'Houston', N'TX', N'77021', 11, 6, 1,
15030)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'David', N'Lawrence', N'Po Box 83270',
N'Houston', N'TX', N'77021', 15, 1, 2, 15031)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Hattie', N'Haemon', N'400 West Pender
St', N'Houston', N'TX', N'77013', 15, 2, 1, 15032)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])

VALUES (N'Orlando', N'Gee', N'8713 Yosemite Ct.',
N'Houston', N'TX', N'77001', 11, 1, 1, 15033)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Keith', N'Harris', N'1318 Lasalle
Street', N'Houston', N'TX', N'77005', 11, 6, 1,
15034)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Donna', N'Carreras', N'9178 Jumping
St.', N'Houston', N'TX', N'77001', 15, 2, 1,
15035)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Robert', N'Jones', N'14Jones St',
N'Houston', N'TX', N'77001', 11, 6, 1, 15036)
GO