Spørring Sybase Database

'20', '25'); INSERT INTO Products (Product, Kategori, Antall, kostpris, SellingPrice) VERDIER ('clothe Box "," husholdning "," 45 "," 16 "," 21'); Sett inn i Products (Product, Kategori, Antall, kostpris, SellingPrice) VERDIER ('Perfume', 'skjønnhet', '100', '2', '3'); INSERT INTO Products (Product, Kategori, Antall, kostpris, SellingPrice) VERDIER ('Banana', 'Fruit "," 125 "," 5 "," 7'); INSERT INTO Products (Product, Kategori, Antall, kostpris, SellingPrice) VERDIER ('pære', 'Fruit "," 135 "," 3 "," 4'); INSERT INTO Kunder (navn, adresse, by, stat, land, telefonnummer) VALUES ('Great Lakes Food Shop', '2 732 Baker Blvd', 'Eugene', 'ELLER', 'USA', '514 555-7555') ; INSERT INTO Kunder (navn, adresse, by, stat, land, telefonnummer) VALUES ('John Steel "," Sing Terrasse', 'Walla', 'WA', 'USA', '509-555-6221'); INSERT INTO Kunder (navn, adresse, by, stat, land, telefonnummer) VALUES ('Start og Shop', '87 Polk St.

Suite 5 ',' San Francisco ',' CA ',' USA "," 415-655 -5938 '); INSERT INTO Kunder (navn, adresse, by, stat, land, telefonnummer) verdier ('Lonesome Gold Restaurant', 'Chiaroscuro Rd.', 'Portland', 'eller', 'USA', '503-555-9573') ; INSERT INTO Kunder (navn, adresse, by, stat, land, telefonnummer) VALUES ('New World Delicatessen "," Bering St.

', 'Anchorage', 'AK', 'USA', '907-555-7584') ; INSERT INTO Leverandører (navn, adresse, by, stat, land, telefonnummer) VALUES ('tema Kjeks, Ltd', '29 Kings Way "," Manchester "," M14 "," USA "," 161-555-4448 ' ); INSERT INTO Leverandører (navn, adresse, by, stat, land, telefonnummer) VALUES ('New England Cannery', '2200 Paul Revere Blvd.

', 'Boston', 'MA', 'USA', '617-555-3267 '); INSERT INTO Leverandører (navn, adresse, by, stat, land, telefonnummer) verdier ('Bigfoot Bryggerier "," 3400 - 8th Avenue Suite 210', 'Bend', 'ELLER', 'USA', '503-555-9931 '); INSERT INTO Leverandører (navn, adresse, by, stat, land, telefonnummer) VERDIER ('Grandma Kellys Homestead', '707 Oxford Rd.

', 'Ann Arbor "," MI "," USA "," 313-555-3349 '); INSERT INTO Leverandører (navn, adresse, by, stat, land, telefonnummer) VALUES ('New Orleans Cajun Delights', 'PO Box 25934', 'New Orleans', 'LA', 'USA', '100-555-4822 '); INSERT INTO Medarbeider (navn, adresse, by, stat, Country, Telefon, NRK) VERDIER ('John Smith "," 2817 Milton Dr.', 'Boston', 'MA', 'USA', '505-555-5939 ', 1); INSERT INTO Medarbeider (navn, adresse, by, stat, Country, Telefon, NRK) VERDIER ('Mary Jones', '187 Suffolk Ln.

', 'Boston', 'MA', 'USA', '208-555-8097 ', 1); INSERT IN