Question

Insert the following records into the Manufacturer table. It is important that you insert the data exactly as shown below, including any commas or periods. Since this problem will require multiple SQL statements, you must end each statement with a semicolon.

Remember only submit the specific SQL statements required by the problem definition.

ManufacturerID	ManufacturerName	Address	City	State	PostalCode	Phone
100	Classic Shoes Inc	521 Schaefer Ave	Chino	CA	91710	714-276-1180
101	All About Boots	80 Enterprise Avenue South	Secaucus	NJ	17094
102	Sports Footwear	22500 S. Vermont Ave	Torrence	CA	90502	310-783-1900
103	Fancy Feet LLC	910 S Los Angeles Street # 704	Los Angeles	CA	90015	877-740-7732

Answer 1

INSERT INTO Manufacturer VALUES (100, 'Classic Shoes Inc', '521 Schaefer Ave', 'Chino', 'CA', '91710', '714-276-1180');

INSERT INTO Manufacturer VALUES (101, 'All About Boots', '80 Enterprise Avenue South', 'Secaucus', 'NJ', '17094', null);

INSERT INTO Manufacturer VALUES (102, 'Sports Footwear', '22500 S. Vermont Ave', 'Torrence', 'CA', '90502', '310-783-1900');

INSERT INTO Manufacturer VALUES (103, 'Fancy Feet LLC', '910 S Los Angeles Street # 704', 'Los Angeles', 'CA', '90015', '877-740-7732');