選單
×
   ❮   
HTML CSS JAVASCRIPT SQL PYTHON JAVA PHP 如何 W3.CSS C C++ C# BOOTSTRAP REACT MYSQL JQUERY EXCEL XML DJANGO NUMPY PANDAS NODEJS R TYPESCRIPT ANGULAR GIT POSTGRESQL MONGODB ASP AI GO KOTLIN SASS VUE DSA 生成式人工智慧 SCIPY AWS 網路安全 資料科學
     ❯   

建立演示資料庫


演示資料庫

到目前為止,在本教程中,我們一直在 PostgreSQL 資料庫中使用一個非常小而簡單的表。

現在我們想建立更多包含更多內容的表,以便能夠演示更多的資料庫功能。

我們將在 PostgreSQL 資料庫中建立這 6 個表:

categories(類別)
customers(客戶)
products(產品)
orders(訂單)
order_details(訂單詳情)
testproducts(測試產品)

下面我們列出了您需要建立這些表以及其中內容的所有 SQL 語句。

您不需要在自己的系統上建立這些表即可繼續本教程,但這可能有助於您更好地理解 PostgreSQL 和 SQL 語句的工作原理。

請確保您已連線到資料庫。如果未連線,請按照本教程“SQL Shell”章節中的步驟進行操作。

連線後,您就可以編寫 SQL 語句了!


CATEGORIES(類別)

以下 SQL 語句將建立一個名為 categories 的表

CREATE TABLE categories

CREATE TABLE categories (
  category_id SERIAL NOT NULL PRIMARY KEY,
  category_name VARCHAR(255),
  description VARCHAR(255)
);

結果

CREATE TABLE

以下 SQL 語句將填充 categories 表的內容

INSERT INTO categories

INSERT INTO categories (category_name, description)
VALUES
  ('Beverages', '軟飲料、咖啡、茶、啤酒和麥芽酒'),
  ('Condiments', '甜味和鹹味醬汁、調味品、塗抹醬和調味料'),
  ('Confections', '甜點、糖果和甜麵包'),
  ('Dairy Products', '乳酪'),
  ('Grains/Cereals', '麵包、餅乾、義大利麵和穀物'),
  ('Meat/Poultry', '加工肉類'),
  ('Produce', '乾果和豆腐'),
  ('Seafood', '海帶和魚');

結果

INSERT 0 8

結果也可以在此處檢視: 演示資料庫 - categories


CUSTOMERS(客戶)

以下 SQL 語句將建立一個名為 customers 的表

CREATE TABLE customers

CREATE TABLE customers (
  customer_id SERIAL NOT NULL PRIMARY KEY,
  customer_name VARCHAR(255),
  contact_name VARCHAR(255),
  address VARCHAR(255),
  city VARCHAR(255),
  postal_code VARCHAR(255),
  country VARCHAR(255)
);

結果

CREATE TABLE

以下 SQL 語句將填充 customers 表的內容

INSERT INTO customers

INSERT INTO customers (customer_name, contact_name, address, city, postal_code, country)
VALUES
  ('Alfreds Futterkiste', 'Maria Anders', 'Obere Str. 57', '柏林', '12209', '德國'),
  ('Ana Trujillo Emparedados y helados', 'Ana Trujillo', 'Avda. de la Constitucion 2222', '墨西哥城', '05021', '墨西哥'),
  ('Antonio Moreno Taquera', 'Antonio Moreno', 'Mataderos 2312', '墨西哥城', '05023', '墨西哥'),
  ('Around the Horn', 'Thomas Hardy', '120 Hanover Sq.', '倫敦', 'WA1 1DP', '英國'),
  ('Berglunds snabbkoep', 'Christina Berglund', 'Berguvsvegen 8', '呂勒奧', 'S-958 22', '瑞典'),
  ('Blauer See Delikatessen', 'Hanna Moos', 'Forsterstr. 57', '曼海姆', '68306', '德國'),
  ('Blondel pere et fils', 'Frederique Citeaux', '24, place Kleber', '斯特拉斯堡', '67000', '法國'),
  ('Bolido Comidas preparadas', 'Martin Sommer', 'C/ Araquil, 67', '馬德里', '28023', '西班牙'),
  ('Bon app', 'Laurence Lebihans', '12, rue des Bouchers', '馬賽', '13008', '法國'),
  ('Bottom-Dollar Marketse', 'Elizabeth Lincoln', '23 Tsawassen Blvd.', '措瓦森', 'T2F 8M4', '加拿大'),
  ('Bs Beverages', 'Victoria Ashworth', 'Fauntleroy Circus', '倫敦', 'EC2 5NT', '英國'),
  ('Cactus Comidas para llevar', 'Patricio Simpson', 'Cerrito 333', '布宜諾斯艾利斯', '1010', '阿根廷'),
  ('Centro comercial Moctezuma', 'Francisco Chang', 'Sierras de Granada 9993', '墨西哥城', '05022', '墨西哥'),
  ('Chop-suey Chinese', 'Yang Wang', 'Hauptstr. 29', '伯爾尼', '3012', '瑞士'),
  ('Comercio Mineiro', 'Pedro Afonso', 'Av. dos Lusiadas, 23', '聖保羅', '05432-043', '巴西'),
  ('Consolidated Holdings', 'Elizabeth Brown', 'Berkeley Gardens 12 Brewery ', '倫敦', 'WX1 6LT', '英國'),
  ('Drachenblut Delikatessend', 'Sven Ottlieb', 'Walserweg 21', '亞琛', '52066', '德國'),
  ('Du monde entier', 'Janine Labrune', '67, rue des Cinquante Otages', '南特', '44000', '法國'),
  ('Eastern Connection', 'Ann Devon', '35 King George', '倫敦', 'WX3 6FW', '英國'),
  ('Ernst Handel', 'Roland Mendel', 'Kirchgasse 6', '格拉茨', '8010', '奧地利'),
  ('Familia Arquibaldo', 'Aria Cruz', 'Rua Oros, 92', '聖保羅', '05442-030', '巴西'),
  ('FISSA Fabrica Inter. Salchichas S.A.', 'Diego Roel', 'C/ Moralzarzal, 86', '馬德里', '28034', '西班牙'),
  ('Folies gourmandes', 'Martine Rance', '184, chaussee de Tournai', '里爾', '59000', '法國'),
  ('Folk och fe HB', 'Maria Larsson', 'Akergatan 24', '布雷克', 'S-844 67', '瑞典'),
  ('Frankenversand', 'Peter Franken', 'Berliner Platz 43', '慕尼黑', '80805', '德國'),
  ('France restauration', 'Carine Schmitt', '54, rue Royale', '南特', '44000', '法國'),
  ('Franchi S.p.A.', 'Paolo Accorti', 'Via Monte Bianco 34', '都靈', '10100', '義大利'),
  ('Furia Bacalhau e Frutos do Mar', 'Lino Rodriguez ', 'Jardim das rosas n. 32', '里斯本', '1675', '葡萄牙'),
  ('Galeria del gastronomo', 'Eduardo Saavedra', 'Rambla de Cataluna, 23', '巴塞羅那', '08022', '西班牙'),
  ('Godos Cocina Tipica', 'Jose Pedro Freyre', 'C/ Romero, 33', '塞維利亞', '41101', '西班牙'),
  ('Gourmet Lanchonetes', 'Andre Fonseca', 'Av. Brasil, 442', '坎皮納斯', '04876-786', '巴西'),
  ('Great Lakes Food Market', 'Howard Snyder', '2732 Baker Blvd.', '尤金', '97403', '美國'),
  ('GROSELLA-Restaurante', 'Manuel Pereira', '5th Ave. Los Palos Grandes', '加拉加斯', '1081', '委內瑞拉'),
  ('Hanari Carnes', 'Mario Pontes', 'Rua do Paco, 67', '里約熱內盧', '05454-876', '巴西'),
  ('HILARION-Abastos', 'Carlos Hernandez', 'Carrera 22 con Ave. Carlos Soublette #8-35', '聖克里斯托瓦爾', '5022', '委內瑞拉'),
  ('Hungry Coyote Import Store', 'Yoshi Latimer', 'City Center Plaza 516 Main St.', '埃爾金', '97827', '美國'),
  ('Hungry Owl All-Night Grocers', 'Patricia McKenna', '8 Johnstown Road', '科克', '', '愛爾蘭'),
  ('Island Trading', 'Helen Bennett', 'Garden House Crowther Way', '考斯', 'PO31 7PJ', '英國'),
  ('Koniglich Essen', 'Philip Cramer', 'Maubelstr. 90', '勃蘭登堡', '14776', '德國'),
  ('La corne d abondance', 'Daniel Tonini', '67, avenue de l Europe', '凡爾賽', '78000', '法國'),
  ('La maison d Asie', 'Annette Roulet', '1 rue Alsace-Lorraine', '圖盧茲', '31000', '法國'),
  ('Laughing Bacchus Wine Cellars', 'Yoshi Tannamuri', '1900 Oak St.', '溫哥華', 'V3F 2K1', '加拿大'),
  ('Lazy K Kountry Store', 'John Steel', '12 Orchestra Terrace', '瓦拉瓦拉', '99362', '美國'),
  ('Lehmanns Marktstand', 'Renate Messner', 'Magazinweg 7', '法蘭克福', '60528', '德國'),
  ('Lets Stop N Shop', 'Jaime Yorres', '87 Polk St. Suite 5', '舊金山', '94117', '美國'),
  ('LILA-Supermercado', 'Carlos Gonzalez', 'Carrera 52 con Ave. Bolivar #65-98 Llano Largo', '巴基西梅託', '3508', '委內瑞拉'),
  ('LINO-Delicateses', 'Felipe Izquierdo', 'Ave. 5 de Mayo Porlamar', '瑪格麗塔島', '4980', '委內瑞拉'),
  ('Lonesome Pine Restaurant', 'Fran Wilson', '89 Chiaroscuro Rd.', '波特蘭', '97219', '美國'),
  ('Magazzini Alimentari Riuniti', 'Giovanni Rovelli', 'Via Ludovico il Moro 22', '貝加莫', '24100', '義大利'),
  ('Maison Dewey', 'Catherine Dewey', 'Rue Joseph-Bens 532', '布魯塞爾', 'B-1180', '比利時'),
  ('Mere Paillarde', 'Jean Fresniere', '43 rue St. Laurent', '蒙特利爾', 'H1J 1C3', '加拿大'),
  ('Morgenstern Gesundkost', 'Alexander Feuer', 'Heerstr. 22', '萊比錫', '04179', '德國'),
  ('North/South', 'Simon Crowther', 'South House 300 Queensbridge', '倫敦', 'SW7 1RZ', '英國'),
  ('Oceano Atlantico Ltda.', 'Yvonne Moncada', 'Ing. Gustavo Moncada 8585 Piso 20-A', '布宜諾斯艾利斯', '1010', '阿根廷'),
  ('Old World Delicatessen', 'Rene Phillips', '2743 Bering St.', '安克雷奇', '99508', '美國'),
  ('Ottilies Keseladen', 'Henriette Pfalzheim', 'Mehrheimerstr. 369', '科隆', '50739', '德國'),
  ('Paris specialites', 'Marie Bertrand', '265, boulevard Charonne', '巴黎', '75012', '法國'),
  ('Pericles Comidas clasicas', 'Guillermo Fernandez', 'Calle Dr. Jorge Cash 321', '墨西哥城', '05033', '墨西哥'),
  ('Piccolo und mehr', 'Georg Pipps', 'Geislweg 14', '薩爾茨堡', '5020', '奧地利'),
  ('Princesa Isabel Vinhoss', 'Isabel de Castro', 'Estrada da saude n. 58', '里斯本', '1756', '葡萄牙'),
  ('Que Delicia', 'Bernardo Batista', 'Rua da Panificadora, 12', '里約熱內盧', '02389-673', '巴西'),
  ('Queen Cozinha', 'Lucia Carvalho', 'Alameda dos Canarios, 891', '聖保羅', '05487-020', '巴西'),
  ('QUICK-Stop', 'Horst Kloss', 'Taucherstrasse 10', '庫內瓦爾德', '01307', '德國'),
  ('Rancho grande', 'Sergio Gutiarrez', 'Av. del Libertador 900', '布宜諾斯艾利斯', '1010', '阿根廷'),
  ('Rattlesnake Canyon Grocery', 'Paula Wilson', '2817 Milton Dr.', '阿爾伯克基', '87110', '美國'),
  ('Reggiani Caseifici', 'Maurizio Moroni', 'Strada Provinciale 124', '雷焦艾米利亞', '42100', '義大利'),
  ('Ricardo Adocicados', 'Janete Limeira', 'Av. Copacabana, 267', '里約熱內盧', '02389-890', '巴西'),
  ('Richter Supermarkt', 'Michael Holz', 'Grenzacherweg 237', '日內瓦', '1203', '瑞士'),
  ('Romero y tomillo', 'Alejandra Camino', 'Gran Via, 1', '馬德里', '28001', '西班牙'),
  ('Santa Gourmet', 'Jonas Bergulfsen', 'Erling Skakkes gate 78', '斯塔韋恩', '4110', '挪威'),
  ('Save-a-lot Markets', 'Jose Pavarotti', '187 Suffolk Ln.', '博伊西', '83720', '美國'),
  ('Seven Seas Imports', 'Hari Kumar', '90 Wadhurst Rd.', '倫敦', 'OX15 4NB', '英國'),
  ('Simons bistro', 'Jytte Petersen', 'Vinbeltet 34', '哥本哈根', '1734', '丹麥'),
  ('Specialites du monde', 'Dominique Perrier', '25, rue Lauriston', '巴黎', '75016', '法國'),
  ('Split Rail Beer & Ale', 'Art Braunschweiger', 'P.O. Box 555', '蘭德', '82520', '美國'),
  ('Supremes delices', 'Pascale Cartrain', 'Boulevard Tirou, 255', '沙勒羅瓦', 'B-6000', '比利時'),
  ('The Big Cheese', 'Liz Nixon', '89 Jefferson Way Suite 2', '波特蘭', '97201', '美國'),
  ('The Cracker Box', 'Liu Wong', '55 Grizzly Peak Rd.', '比尤特', '59801', '美國'),
  ('Toms Spezialiteten', 'Karin Josephs', 'Luisenstr. 48', '明斯特', '44087', '德國'),
  ('Tortuga Restaurante', 'Miguel Angel Paolino', 'Avda. Azteca 123', '墨西哥城', '05033', '墨西哥'),
  ('Tradicao Hipermercados', 'Anabela Domingues', 'Av. Ines de Castro, 414', '聖保羅', '05634-030', '巴西'),
  ('Trails Head Gourmet Provisioners', 'Helvetius Nagy', '722 DaVinci Blvd.', '柯克蘭', '98034', '美國'),
  ('Vaffeljernet', 'Palle Ibsen', 'Smagsloget 45', '奧胡斯', '8200', '丹麥'),
  ('Victuailles en stock', 'Mary Saveley', '2, rue du Commerce', '里昂', '69004', '法國'),
  ('Vins et alcools Chevalier', 'Paul Henriot', '59 rue de l Abbaye', '蘭斯', '51100', '法國'),
  ('Die Wandernde Kuh', 'Rita Moller', 'Adenauerallee 900', '斯圖加特', '70563', '德國'),
  ('Wartian Herkku', 'Pirkko Koskitalo', 'Torikatu 38', '奧盧', '90110', '芬蘭'),
  ('Wellington Importadora', 'Paula Parente', 'Rua do Mercado, 12', '雷森迪', '08737-363', '巴西'),
  ('White Clover Markets', 'Karl Jablonski', '305 - 14th Ave. S. Suite 3B', '西雅圖', '98128', '美國'),
  ('Wilman Kala', 'Matti Karttunen', 'Keskuskatu 45', '赫爾辛基', '21240', '芬蘭'),
  ('Wolski', 'Zbyszek', 'ul. Filtrowa 68', '瓦拉', '01-012', '波蘭');

結果

INSERT 0 91

結果也可以在此處檢視: 演示資料庫 - customers


PRODUCTS(產品)

以下 SQL 語句將建立一個名為 products 的表

CREATE TABLE products

CREATE TABLE products (
  product_id SERIAL NOT NULL PRIMARY KEY,
  product_name VARCHAR(255),
  category_id INT,
  unit VARCHAR(255),
  price DECIMAL(10, 2)
);

結果

CREATE TABLE

以下 SQL 語句將填充 products 表的內容

INSERT INTO products

INSERT INTO products (product_id, product_name, category_id, unit, price)
VALUES
  (1, 'Chais', 1, '10 盒 x 20 袋', 18),
  (2, 'Chang', 1, '24 瓶 - 12 盎司', 19),
  (3, 'Aniseed Syrup', 2, '12 瓶 - 550 毫升', 10),
  (4, 'Chef Antons Cajun Seasoning', 2, '48 罐 - 6 盎司', 22),
  (5, 'Chef Antons Gumbo Mix', 2, '36 盒', 21.35),
  (6, 'Grandmas Boysenberry Spread', 2, '12 罐 - 8 盎司', 25),
  (7, 'Uncle Bobs Organic Dried Pears', 7, '12 包 - 1 磅', 30),
  (8, 'Northwoods Cranberry Sauce', 2, '12 罐 - 12 盎司', 40),
  (9, 'Mishi Kobe Niku', 6, '18 包 - 500 克', 97),
  (10, 'Ikura', 8, '12 罐 - 200 毫升', 31),
  (11, 'Queso Cabrales', 4, '1 公斤包裝', 21),
  (12, 'Queso Manchego La Pastora', 4, '10 包 - 500 克', 38),
  (13, 'Konbu', 8, '2 公斤盒', 6),
  (14, 'Tofu', 7, '40 包 - 100 克', 23.25),
  (15, 'Genen Shouyu', 2, '24 瓶 - 250 毫升', 15.5),
  (16, 'Pavlova', 3, '32 盒 - 500 克', 17.45),
  (17, 'Alice Mutton', 6, '20 罐 - 1 公斤', 39),
  (18, 'Carnarvon Tigers', 8, '16 公斤包裝', 62.5),
  (19, 'Teatime Chocolate Biscuits', 3, '10 盒 x 12 塊', 9.2),
  (20, 'Sir Rodneys Marmalade', 3, '30 禮盒', 81),
  (21, 'Sir Rodneys Scones', 3, '24 包 x 4 塊', 10),
  (22, 'Gustafs Kneckebrod', 5, '24 包 - 500 克', 21),
  (23, 'Tunnbrod', 5, '12 包 - 250 克', 9),
  (24, 'Guarani Fantastica', 1, '12 罐 - 355 毫升', 4.5),
  (25, 'NuNuCa Nui-Nougat-Creme', 3, '20 杯 - 450 克', 14),
  (26, 'Gumber Gummiberchen', 3, '100 袋 - 250 克', 31.23),
  (27, 'Schoggi Schokolade', 3, '100 塊 - 100 克', 43.9),
  (28, 'Rassle Sauerkraut', 7, '25 罐 - 825 克', 45.6),
  (29, 'Thoringer Rostbratwurst', 6, '50 袋 x 30 根香腸', 123.79),
  (30, 'Nord-Ost Matjeshering', 8, '10 罐 - 200 克', 25.89),
  (31, 'Gorgonzola Telino', 4, '12 包 - 100 克', 12.5),
  (32, 'Mascarpone Fabioli', 4, '24 包 - 200 克', 32),
  (33, 'Geitost', 4, '500 克', 2.5),
  (34, 'Sasquatch Ale', 1, '24 瓶 - 12 盎司', 14),
  (35, 'Steeleye Stout', 1, '24 瓶 - 12 盎司', 18),
  (36, 'Inlagd Sill', 8, '24 罐 - 250 克', 19),
  (37, 'Gravad lax', 8, '12 包 - 500 克', 26),
  (38, 'Cote de Blaye', 1, '12 瓶 - 75 釐升', 263.5),
  (39, 'Chartreuse verte', 1, '每瓶 750 毫升', 18),
  (40, 'Boston Crab Meat', 8, '24 罐 - 4 盎司', 18.4),
  (41, 'Jacks New England Clam Chowder', 8, '12 罐 - 12 盎司', 9.65),
  (42, 'Singaporean Hokkien Fried Mee', 5, '32 包 - 1 公斤', 14),
  (43, 'Ipoh Coffee', 1, '16 罐 - 500 克', 46),
  (44, 'Gula Malacca', 2, '20 袋 - 2 公斤', 19.45),
  (45, 'Rogede sild', 8, '1 公斤包裝', 9.5),
  (46, 'Spegesild', 8, '4 罐 - 450 克', 12),
  (47, 'Zaanse koeken', 3, '10 盒 - 4 盎司', 9.5),
  (48, 'Chocolade', 3, '10 包', 12.75),
  (49, 'Maxilaku', 3, '24 包 - 50 克', 20),
  (50, 'Valkoinen suklaa', 3, '12 條 - 100 克', 16.25),
  (51, 'Manjimup Dried Apples', 7, '50 包 - 300 克', 53),
  (52, 'Filo Mix', 5, '16 盒 - 2 公斤', 7),
  (53, 'Perth Pasties', 6, '48 塊', 32.8),
  (54, 'Tourtiare', 6, '16 派', 7.45),
  (55, 'Pate chinois', 6, '24 盒 x 2 派', 24),
  (56, 'Gnocchi di nonna Alice', 5, '24 包 - 250 克', 38),
  (57, 'Ravioli Angelo', 5, '24 包 - 250 克', 19.5),
  (58, 'Escargots de Bourgogne', 8, '24 塊', 13.25),
  (59, 'Raclette Courdavault', 4, '5 公斤包裝', 55),
  (60, 'Camembert Pierrot', 4, '15 塊 - 300 克圓盤', 34),
  (61, 'Sirop d arable', 2, '24 瓶 - 500 毫升', 28.5),
  (62, 'Tarte au sucre', 3, '48 派', 49.3),
  (63, 'Vegie-spread', 2, '15 罐 - 625 克', 43.9),
  (64, 'Wimmers gute Semmelknadel', 5, '20 袋 x 4 塊', 33.25),
  (65, 'Louisiana Fiery Hot Pepper Sauce', 2, '32 瓶 - 8 盎司', 21.05),
  (66, 'Louisiana Hot Spiced Okra', 2, '24 罐 - 8 盎司', 17),
  (67, 'Laughing Lumberjack Lager', 1, '24 瓶 - 12 盎司', 14),
  (68, 'Scottish Longbreads', 3, '10 盒 x 8 塊', 12.5),
  (69, 'Gudbrandsdalsost', 4, '10 公斤包裝', 36),
  (70, 'Outback Lager', 1, '24 瓶 - 355 毫升', 15),
  (71, 'Flotemysost', 4, '10 包 - 500 克', 21.5),
  (72, 'Mozzarella di Giovanni', 4, '24 包 - 200 克', 34.8),
  (73, 'Red Kaviar', 8, '24 罐 - 150 克', 15),
  (74, 'Longlife Tofu', 7, '5 公斤包裝', 10),
  (75, 'Rhenbreu Klosterbier', 1, '24 瓶 - 0.5 升', 7.75),
  (76, 'Lakkalikeeri', 1, '500 毫升 ', 18),
  (77, 'Original Frankfurter gr�ne Soae', 2, '12 盒', 13);

結果

INSERT 0 77

結果也可以在此處檢視: 演示資料庫 - products


ORDERS(訂單)

以下 SQL 語句將建立一個名為 orders 的表

CREATE TABLE orders

CREATE TABLE orders (
  order_id SERIAL NOT NULL PRIMARY KEY,
  customer_id INT,
  order_date DATE
);

結果

CREATE TABLE

以下 SQL 語句將填充 orders 表的內容

INSERT INTO orders

INSERT INTO orders (order_id, customer_id, order_date)
VALUES
  (10248, 90, '2021-07-04'),
  (10249, 81, '2021-07-05'),
  (10250, 34, '2021-07-08'),
  (10251, 84, '2021-07-08'),
  (10252, 76, '2021-07-09'),
  (10253, 34, '2021-07-10'),
  (10254, 14, '2021-07-11'),
  (10255, 68, '2021-07-12'),
  (10256, 88, '2021-07-15'),
  (10257, 35, '2021-07-16'),
  (10258, 20, '2021-07-17'),
  (10259, 13, '2021-07-18'),
  (10260, 55, '2021-07-19'),
  (10261, 61, '2021-07-19'),
  (10262, 65, '2021-07-22'),
  (10263, 20, '2021-07-23'),
  (10264, 24, '2021-07-24'),
  (10265, 7, '2021-07-25'),
  (10266, 87, '2021-07-26'),
  (10267, 25, '2021-07-29'),
  (10268, 33, '2021-07-30'),
  (10269, 89, '2021-07-31'),
  (10270, 87, '2021-08-01'),
  (10271, 75, '2021-08-01'),
  (10272, 65, '2021-08-02'),
  (10273, 63, '2021-08-05'),
  (10274, 85, '2021-08-06'),
  (10275, 49, '2021-08-07'),
  (10276, 80, '2021-08-08'),
  (10277, 52, '2021-08-09'),
  (10278, 5, '2021-08-12'),
  (10279, 44, '2021-08-13'),
  (10280, 5, '2021-08-14'),
  (10281, 69, '2021-08-14'),
  (10282, 69, '2021-08-15'),
  (10283, 46, '2021-08-16'),
  (10284, 44, '2021-08-19'),
  (10285, 63, '2021-08-20'),
  (10286, 63, '2021-08-21'),
  (10287, 67, '2021-08-22'),
  (10288, 66, '2021-08-23'),
  (10289, 11, '2021-08-26'),
  (10290, 15, '2021-08-27'),
  (10291, 61, '2021-08-27'),
  (10292, 81, '2021-08-28'),
  (10293, 80, '2021-08-29'),
  (10294, 65, '2021-08-30'),
  (10295, 85, '2021-09-02'),
  (10296, 46, '2021-09-03'),
  (10297, 7, '2021-09-04'),
  (10298, 37, '2021-09-05'),
  (10299, 67, '2021-09-06'),
  (10300, 49, '2021-09-09'),
  (10301, 86, '2021-09-09'),
  (10302, 76, '2021-09-10'),
  (10303, 30, '2021-09-11'),
  (10304, 80, '2021-09-12'),
  (10305, 55, '2021-09-13'),
  (10306, 69, '2021-09-16'),
  (10307, 48, '2021-09-17'),
  (10308, 2, '2021-09-18'),
  (10309, 37, '2021-09-19'),
  (10310, 77, '2021-09-20'),
  (10311, 18, '2021-09-20'),
  (10312, 86, '2021-09-23'),
  (10313, 63, '2021-09-24'),
  (10314, 65, '2021-09-25'),
  (10315, 38, '2021-09-26'),
  (10316, 65, '2021-09-27'),
  (10317, 48, '2021-09-30'),
  (10318, 38, '2021-10-01'),
  (10319, 80, '2021-10-02'),
  (10320, 87, '2021-10-03'),
  (10321, 38, '2021-10-03'),
  (10322, 58, '2021-10-04'),
  (10323, 39, '2021-10-07'),
  (10324, 71, '2021-10-08'),
  (10325, 39, '2021-10-09'),
  (10326, 8, '2021-10-10'),
  (10327, 24, '2021-10-11'),
  (10328, 28, '2021-10-14'),
  (10329, 75, '2021-10-15'),
  (10330, 46, '2021-10-16'),
  (10331, 9, '2021-10-16'),
  (10332, 51, '2021-10-17'),
  (10333, 87, '2021-10-18'),
  (10334, 84, '2021-10-21'),
  (10335, 37, '2021-10-22'),
  (10336, 60, '2021-10-23'),
  (10337, 25, '2021-10-24'),
  (10338, 55, '2021-10-25'),
  (10339, 51, '2021-10-28'),
  (10340, 9, '2021-10-29'),
  (10341, 73, '2021-10-29'),
  (10342, 25, '2021-10-30'),
  (10343, 44, '2021-10-31'),
  (10344, 89, '2021-11-01'),
  (10345, 63, '2021-11-04'),
  (10346, 65, '2021-11-05'),
  (10347, 21, '2021-11-06'),
  (10348, 86, '2021-11-07'),
  (10349, 75, '2021-11-08'),
  (10350, 41, '2021-11-11'),
  (10351, 20, '2021-11-11'),
  (10352, 28, '2021-11-12'),
  (10353, 59, '2021-11-13'),
  (10354, 58, '2021-11-14'),
  (10355, 4, '2021-11-15'),
  (10356, 86, '2021-11-18'),
  (10357, 46, '2021-11-19'),
  (10358, 41, '2021-11-20'),
  (10359, 72, '2021-11-21'),
  (10360, 7, '2021-11-22'),
  (10361, 63, '2021-11-22'),
  (10362, 9, '2021-11-25'),
  (10363, 17, '2021-11-26'),
  (10364, 19, '2021-11-26'),
  (10365, 3, '2021-11-27'),
  (10366, 29, '2021-11-28'),
  (10367, 83, '2021-11-28'),
  (10368, 20, '2021-11-29'),
  (10369, 75, '2021-12-02'),
  (10370, 14, '2021-12-03'),
  (10371, 41, '2021-12-03'),
  (10372, 62, '2021-12-04'),
  (10373, 37, '2021-12-05'),
  (10374, 91, '2021-12-05'),
  (10375, 36, '2021-12-06'),
  (10376, 51, '2021-12-09'),
  (10377, 72, '2021-12-09'),
  (10378, 24, '2021-12-10'),
  (10379, 61, '2021-12-11'),
  (10380, 37, '2021-12-12'),
  (10381, 46, '2021-12-12'),
  (10382, 20, '2021-12-13'),
  (10383, 4, '2021-12-16'),
  (10384, 5, '2021-12-16'),
  (10385, 75, '2021-12-17'),
  (10386, 21, '2021-12-18'),
  (10387, 70, '2021-12-18'),
  (10388, 72, '2021-12-19'),
  (10389, 10, '2021-12-20'),
  (10390, 20, '2021-12-23'),
  (10391, 17, '2021-12-23'),
  (10392, 59, '2021-12-24'),
  (10393, 71, '2021-12-25'),
  (10394, 36, '2021-12-25'),
  (10395, 35, '2021-12-26'),
  (10396, 25, '2021-12-27'),
  (10397, 60, '2021-12-27'),
  (10398, 71, '2021-12-30'),
  (10399, 83, '2021-12-31'),
  (10400, 19, '2022-01-01'),
  (10401, 65, '2022-01-01'),
  (10402, 20, '2022-01-02'),
  (10403, 20, '2022-01-03'),
  (10404, 49, '2022-01-03'),
  (10405, 47, '2022-01-06'),
  (10406, 62, '2022-01-07'),
  (10407, 56, '2022-01-07'),
  (10408, 23, '2022-01-08'),
  (10409, 54, '2022-01-09'),
  (10410, 10, '2022-01-10'),
  (10411, 10, '2022-01-10'),
  (10412, 87, '2022-01-13'),
  (10413, 41, '2022-01-14'),
  (10414, 21, '2022-01-14'),
  (10415, 36, '2022-01-15'),
  (10416, 87, '2022-01-16'),
  (10417, 73, '2022-01-16'),
  (10418, 63, '2022-01-17'),
  (10419, 68, '2022-01-20'),
  (10420, 88, '2022-01-21'),
  (10421, 61, '2022-01-21'),
  (10422, 27, '2022-01-22'),
  (10423, 31, '2022-01-23'),
  (10424, 51, '2022-01-23'),
  (10425, 41, '2022-01-24'),
  (10426, 29, '2022-01-27'),
  (10427, 59, '2022-01-27'),
  (10428, 66, '2022-01-28'),
  (10429, 37, '2022-01-29'),
  (10430, 20, '2022-01-30'),
  (10431, 10, '2022-01-30'),
  (10432, 75, '2022-01-31'),
  (10433, 60, '2022-02-03'),
  (10434, 24, '2022-02-03'),
  (10435, 16, '2022-02-04'),
  (10436, 7, '2022-02-05'),
  (10437, 87, '2022-02-05'),
  (10438, 79, '2022-02-06'),
  (10439, 51, '2022-02-07'),
  (10440, 71, '2022-02-10'),
  (10441, 55, '2022-02-10'),
  (10442, 20, '2022-02-11'),
  (10443, 66, '2022-02-12'),
  (10444, 5, '2022-02-12'),
  (10445, 5, '2022-02-13'),
  (10446, 79, '2022-02-14'),
  (10447, 67, '2022-02-14'),
  (10448, 64, '2022-02-17'),
  (10449, 7, '2022-02-18'),
  (10450, 84, '2022-02-19'),
  (10451, 63, '2022-02-19'),
  (10452, 71, '2022-02-20'),
  (10453, 4, '2022-02-21'),
  (10454, 41, '2022-02-21'),
  (10455, 87, '2022-02-24'),
  (10456, 39, '2022-02-25'),
  (10457, 39, '2022-02-25'),
  (10458, 76, '2022-02-26'),
  (10459, 84, '2022-02-27'),
  (10460, 24, '2022-02-28'),
  (10461, 46, '2022-02-28'),
  (10462, 16, '2022-03-03'),
  (10463, 76, '2022-03-04'),
  (10464, 28, '2022-03-04'),
  (10465, 83, '2022-03-05'),
  (10466, 15, '2022-03-06'),
  (10467, 49, '2022-03-06'),
  (10468, 39, '2022-03-07'),
  (10469, 89, '2022-03-10'),
  (10470, 9, '2022-03-11'),
  (10471, 11, '2022-03-11'),
  (10472, 72, '2022-03-12'),
  (10473, 38, '2022-03-13'),
  (10474, 58, '2022-03-13'),
  (10475, 76, '2022-03-14'),
  (10476, 35, '2022-03-17'),
  (10477, 60, '2022-03-17'),
  (10478, 84, '2022-03-18'),
  (10479, 65, '2022-03-19'),
  (10480, 23, '2022-03-20'),
  (10481, 67, '2022-03-20'),
  (10482, 43, '2022-03-21'),
  (10483, 89, '2022-03-24'),
  (10484, 11, '2022-03-24'),
  (10485, 47, '2022-03-25'),
  (10486, 35, '2022-03-26'),
  (10487, 62, '2022-03-26'),
  (10488, 25, '2022-03-27'),
  (10489, 59, '2022-03-28'),
  (10490, 35, '2022-03-31'),
  (10491, 28, '2022-03-31'),
  (10492, 10, '2022-04-01'),
  (10493, 41, '2022-04-02'),
  (10494, 15, '2022-04-02'),
  (10495, 42, '2022-04-03'),
  (10496, 81, '2022-04-04'),
  (10497, 44, '2022-04-04'),
  (10498, 35, '2022-04-07'),
  (10499, 46, '2022-04-08'),
  (10500, 41, '2022-04-09'),
  (10501, 6, '2022-04-09'),
  (10502, 58, '2022-04-10'),
  (10503, 37, '2022-04-11'),
  (10504, 89, '2022-04-11'),
  (10505, 51, '2022-04-14'),
  (10506, 39, '2022-04-15'),
  (10507, 3, '2022-04-15'),
  (10508, 56, '2022-04-16'),
  (10509, 6, '2022-04-17'),
  (10510, 71, '2022-04-18'),
  (10511, 9, '2022-04-18'),
  (10512, 21, '2022-04-21'),
  (10513, 86, '2022-04-22'),
  (10514, 20, '2022-04-22'),
  (10515, 63, '2022-04-23'),
  (10516, 37, '2022-04-24'),
  (10517, 53, '2022-04-24'),
  (10518, 80, '2022-04-25'),
  (10519, 14, '2022-04-28'),
  (10520, 70, '2022-04-29'),
  (10521, 12, '2022-04-29'),
  (10522, 44, '2022-04-30'),
  (10523, 72, '2022-05-01'),
  (10524, 5, '2022-05-01'),
  (10525, 9, '2022-05-02'),
  (10526, 87, '2022-05-05'),
  (10527, 63, '2022-05-05'),
  (10528, 32, '2022-05-06'),
  (10529, 50, '2022-05-07'),
  (10530, 59, '2022-05-08'),
  (10531, 54, '2022-05-08'),
  (10532, 19, '2022-05-09'),
  (10533, 24, '2022-05-12'),
  (10534, 44, '2022-05-12'),
  (10535, 3, '2022-05-13'),
  (10536, 44, '2022-05-14'),
  (10537, 68, '2022-05-14'),
  (10538, 11, '2022-05-15'),
  (10539, 11, '2022-05-16'),
  (10540, 63, '2022-05-19'),
  (10541, 34, '2022-05-19'),
  (10542, 39, '2022-05-20'),
  (10543, 46, '2022-05-21'),
  (10544, 48, '2022-05-21'),
  (10545, 43, '2022-05-22'),
  (10546, 84, '2022-05-23'),
  (10547, 72, '2022-05-23'),
  (10548, 79, '2022-05-26'),
  (10549, 63, '2022-05-27'),
  (10550, 30, '2022-05-28'),
  (10551, 28, '2022-05-28'),
  (10552, 35, '2022-05-29'),
  (10553, 87, '2022-05-30'),
  (10554, 56, '2022-05-30'),
  (10555, 71, '2022-06-02'),
  (10556, 73, '2022-06-03'),
  (10557, 44, '2022-06-03'),
  (10558, 4, '2022-06-04'),
  (10559, 7, '2022-06-05'),
  (10560, 25, '2022-06-06'),
  (10561, 24, '2022-06-06'),
  (10562, 66, '2022-06-09'),
  (10563, 67, '2022-06-10'),
  (10564, 65, '2022-06-10'),
  (10565, 51, '2022-06-11'),
  (10566, 7, '2022-06-12'),
  (10567, 37, '2022-06-12'),
  (10568, 29, '2022-06-13'),
  (10569, 65, '2022-06-16'),
  (10570, 51, '2022-06-17'),
  (10571, 20, '2022-06-17'),
  (10572, 5, '2022-06-18'),
  (10573, 3, '2022-06-19'),
  (10574, 82, '2022-06-19'),
  (10575, 52, '2022-06-20'),
  (10576, 80, '2022-06-23'),
  (10577, 82, '2022-06-23'),
  (10578, 11, '2022-06-24'),
  (10579, 45, '2022-06-25'),
  (10580, 56, '2022-06-26'),
  (10581, 21, '2022-06-26'),
  (10582, 6, '2022-06-27'),
  (10583, 87, '2022-06-30'),
  (10584, 7, '2022-06-30'),
  (10585, 88, '2022-07-01'),
  (10586, 66, '2022-07-02'),
  (10587, 61, '2022-07-02'),
  (10588, 63, '2022-07-03'),
  (10589, 32, '2022-07-04'),
  (10590, 51, '2022-07-07'),
  (10591, 83, '2022-07-07'),
  (10592, 44, '2022-07-08'),
  (10593, 44, '2022-07-09'),
  (10594, 55, '2022-07-09'),
  (10595, 20, '2022-07-10'),
  (10596, 89, '2022-07-11'),
  (10597, 59, '2022-07-11'),
  (10598, 65, '2022-07-14'),
  (10599, 11, '2022-07-15'),
  (10600, 36, '2022-07-16'),
  (10601, 35, '2022-07-16'),
  (10602, 83, '2022-07-17'),
  (10603, 71, '2022-07-18'),
  (10604, 28, '2022-07-18'),
  (10605, 51, '2022-07-21'),
  (10606, 81, '2022-07-22'),
  (10607, 71, '2022-07-22'),
  (10608, 79, '2022-07-23'),
  (10609, 18, '2022-07-24'),
  (10610, 41, '2022-07-25'),
  (10611, 91, '2022-07-25'),
  (10612, 71, '2022-07-28'),
  (10613, 35, '2022-07-29'),
  (10614, 6, '2022-07-29'),
  (10615, 90, '2022-07-30'),
  (10616, 32, '2022-07-31'),
  (10617, 32, '2022-07-31'),
  (10618, 51, '2022-08-01'),
  (10619, 51, '2022-08-04'),
  (10620, 42, '2022-08-05'),
  (10621, 38, '2022-08-05'),
  (10622, 67, '2022-08-06'),
  (10623, 25, '2022-08-07'),
  (10624, 78, '2022-08-07'),
  (10625, 2, '2022-08-08'),
  (10626, 5, '2022-08-11'),
  (10627, 71, '2022-08-11'),
  (10628, 7, '2022-08-12'),
  (10629, 30, '2022-08-12'),
  (10630, 39, '2022-08-13'),
  (10631, 41, '2022-08-14'),
  (10632, 86, '2022-08-14'),
  (10633, 20, '2022-08-15'),
  (10634, 23, '2022-08-15'),
  (10635, 49, '2022-08-18'),
  (10636, 87, '2022-08-19'),
  (10637, 62, '2022-08-19'),
  (10638, 47, '2022-08-20'),
  (10639, 70, '2022-08-20'),
  (10640, 86, '2022-08-21'),
  (10641, 35, '2022-08-22'),
  (10642, 73, '2022-08-22'),
  (10643, 1, '2022-08-25'),
  (10644, 88, '2022-08-25'),
  (10645, 34, '2022-08-26'),
  (10646, 37, '2022-08-27'),
  (10647, 61, '2022-08-27'),
  (10648, 67, '2022-08-28'),
  (10649, 50, '2022-08-28'),
  (10650, 21, '2022-08-29'),
  (10651, 86, '2022-09-01'),
  (10652, 31, '2022-09-01'),
  (10653, 25, '2022-09-02'),
  (10654, 5, '2022-09-02'),
  (10655, 66, '2022-09-03'),
  (10656, 32, '2022-09-04'),
  (10657, 71, '2022-09-04'),
  (10658, 63, '2022-09-05'),
  (10659, 62, '2022-09-05'),
  (10660, 36, '2022-09-08'),
  (10661, 37, '2022-09-09'),
  (10662, 48, '2022-09-09'),
  (10663, 9, '2022-09-10'),
  (10664, 28, '2022-09-10'),
  (10665, 48, '2022-09-11'),
  (10666, 68, '2022-09-12'),
  (10667, 20, '2022-09-12'),
  (10668, 86, '2022-09-15'),
  (10669, 73, '2022-09-15'),
  (10670, 25, '2022-09-16'),
  (10671, 26, '2022-09-17'),
  (10672, 5, '2022-09-17'),
  (10673, 90, '2022-09-18'),
  (10674, 38, '2022-09-18'),
  (10675, 25, '2022-09-19'),
  (10676, 80, '2022-09-22'),
  (10677, 3, '2022-09-22'),
  (10678, 71, '2022-09-23'),
  (10679, 7, '2022-09-23'),
  (10680, 55, '2022-09-24'),
  (10681, 32, '2022-09-25'),
  (10682, 3, '2022-09-25'),
  (10683, 18, '2022-09-26'),
  (10684, 56, '2022-09-26'),
  (10685, 31, '2022-09-29'),
  (10686, 59, '2022-09-30'),
  (10687, 37, '2022-09-30'),
  (10688, 83, '2022-10-01'),
  (10689, 5, '2022-10-01'),
  (10690, 34, '2022-10-02'),
  (10691, 63, '2022-10-03'),
  (10692, 1, '2022-10-03'),
  (10693, 89, '2022-10-06'),
  (10694, 63, '2022-10-06'),
  (10695, 90, '2022-10-07'),
  (10696, 89, '2022-10-08'),
  (10697, 47, '2022-10-08'),
  (10698, 20, '2022-10-09'),
  (10699, 52, '2022-10-09'),
  (10700, 71, '2022-10-10'),
  (10701, 37, '2022-10-13'),
  (10702, 1, '2022-10-13'),
  (10703, 24, '2022-10-14'),
  (10704, 62, '2022-10-14'),
  (10705, 35, '2022-10-15'),
  (10706, 55, '2022-10-16'),
  (10707, 4, '2022-10-16'),
  (10708, 77, '2022-10-17'),
  (10709, 31, '2022-10-17'),
  (10710, 27, '2022-10-20'),
  (10711, 71, '2022-10-21'),
  (10712, 37, '2022-10-21'),
  (10713, 71, '2022-10-22'),
  (10714, 71, '2022-10-22'),
  (10715, 9, '2022-10-23'),
  (10716, 64, '2022-10-24'),
  (10717, 25, '2022-10-24'),
  (10718, 39, '2022-10-27'),
  (10719, 45, '2022-10-27'),
  (10720, 61, '2022-10-28'),
  (10721, 63, '2022-10-29'),
  (10722, 71, '2022-10-29'),
  (10723, 89, '2022-10-30'),
  (10724, 51, '2022-10-30'),
  (10725, 21, '2022-10-31'),
  (10726, 19, '2022-11-03'),
  (10727, 66, '2022-11-03'),
  (10728, 62, '2022-11-04'),
  (10729, 47, '2022-11-04'),
  (10730, 9, '2022-11-05'),
  (10731, 14, '2022-11-06'),
  (10732, 9, '2022-11-06'),
  (10733, 5, '2022-11-07'),
  (10734, 31, '2022-11-07'),
  (10735, 45, '2022-11-10'),
  (10736, 37, '2022-11-11'),
  (10737, 85, '2022-11-11'),
  (10738, 74, '2022-11-12'),
  (10739, 85, '2022-11-12'),
  (10740, 89, '2022-11-13'),
  (10741, 4, '2022-11-14'),
  (10742, 10, '2022-11-14'),
  (10743, 4, '2022-11-17'),
  (10744, 83, '2022-11-17'),
  (10745, 63, '2022-11-18'),
  (10746, 14, '2022-11-19'),
  (10747, 59, '2022-11-19'),
  (10748, 71, '2022-11-20'),
  (10749, 38, '2022-11-20'),
  (10750, 87, '2022-11-21'),
  (10751, 68, '2022-11-24'),
  (10752, 53, '2022-11-24'),
  (10753, 27, '2022-11-25'),
  (10754, 49, '2022-11-25'),
  (10755, 9, '2022-11-26'),
  (10756, 75, '2022-11-27'),
  (10757, 71, '2022-11-27'),
  (10758, 68, '2022-11-28'),
  (10759, 2, '2022-11-28'),
  (10760, 50, '2022-12-01'),
  (10761, 65, '2022-12-02'),
  (10762, 24, '2022-12-02'),
  (10763, 23, '2022-12-03'),
  (10764, 20, '2022-12-03'),
  (10765, 63, '2022-12-04'),
  (10766, 56, '2022-12-05'),
  (10767, 76, '2022-12-05'),
  (10768, 4, '2022-12-08'),
  (10769, 83, '2022-12-08'),
  (10770, 34, '2022-12-09'),
  (10771, 20, '2022-12-10'),
  (10772, 44, '2022-12-10'),
  (10773, 20, '2022-12-11'),
  (10774, 24, '2022-12-11'),
  (10775, 78, '2022-12-12'),
  (10776, 20, '2022-12-15'),
  (10777, 31, '2022-12-15'),
  (10778, 5, '2022-12-16'),
  (10779, 52, '2022-12-16'),
  (10780, 46, '2022-12-16'),
  (10781, 87, '2022-12-17'),
  (10782, 12, '2022-12-17'),
  (10783, 34, '2022-12-18'),
  (10784, 49, '2022-12-18'),
  (10785, 33, '2022-12-18'),
  (10786, 62, '2022-12-19'),
  (10787, 41, '2022-12-19'),
  (10788, 63, '2022-12-22'),
  (10789, 23, '2022-12-22'),
  (10790, 31, '2022-12-22'),
  (10791, 25, '2022-12-23'),
  (10792, 91, '2022-12-23'),
  (10793, 4, '2022-12-24'),
  (10794, 61, '2022-12-24'),
  (10795, 20, '2022-12-24'),
  (10796, 35, '2022-12-25'),
  (10797, 17, '2022-12-25'),
  (10798, 38, '2022-12-26'),
  (10799, 39, '2022-12-26'),
  (10800, 72, '2022-12-26'),
  (10801, 8, '2022-12-29'),
  (10802, 73, '2022-12-29'),
  (10803, 88, '2022-12-30'),
  (10804, 72, '2022-12-30'),
  (10805, 77, '2022-12-30'),
  (10806, 84, '2022-12-31'),
  (10807, 27, '2022-12-31'),
  (10808, 60, '2023-01-01'),
  (10809, 88, '2023-01-01'),
  (10810, 42, '2023-01-01'),
  (10811, 47, '2023-01-02'),
  (10812, 66, '2023-01-02'),
  (10813, 67, '2023-01-05'),
  (10814, 84, '2023-01-05'),
  (10815, 71, '2023-01-05'),
  (10816, 32, '2023-01-06'),
  (10817, 39, '2023-01-06'),
  (10818, 49, '2023-01-07'),
  (10819, 12, '2023-01-07'),
  (10820, 65, '2023-01-07'),
  (10821, 75, '2023-01-08'),
  (10822, 82, '2023-01-08'),
  (10823, 46, '2023-01-09'),
  (10824, 24, '2023-01-09'),
  (10825, 17, '2023-01-09'),
  (10826, 7, '2023-01-12'),
  (10827, 9, '2023-01-12'),
  (10828, 64, '2023-01-13'),
  (10829, 38, '2023-01-13'),
  (10830, 81, '2023-01-13'),
  (10831, 70, '2023-01-14'),
  (10832, 41, '2023-01-14'),
  (10833, 56, '2023-01-15'),
  (10834, 81, '2023-01-15'),
  (10835, 1, '2023-01-15'),
  (10836, 20, '2023-01-16'),
  (10837, 5, '2023-01-16'),
  (10838, 47, '2023-01-19'),
  (10839, 81, '2023-01-19'),
  (10840, 47, '2023-01-19'),
  (10841, 76, '2023-01-20'),
  (10842, 80, '2023-01-20'),
  (10843, 84, '2023-01-21'),
  (10844, 59, '2023-01-21'),
  (10845, 63, '2023-01-21'),
  (10846, 76, '2023-01-22'),
  (10847, 71, '2023-01-22'),
  (10848, 16, '2023-01-23'),
  (10849, 39, '2023-01-23'),
  (10850, 84, '2023-01-23'),
  (10851, 67, '2023-01-26'),
  (10852, 65, '2023-01-26'),
  (10853, 6, '2023-01-27'),
  (10854, 20, '2023-01-27'),
  (10855, 55, '2023-01-27'),
  (10856, 3, '2023-01-28'),
  (10857, 5, '2023-01-28'),
  (10858, 40, '2023-01-29'),
  (10859, 25, '2023-01-29'),
  (10860, 26, '2023-01-29'),
  (10861, 89, '2023-01-30'),
  (10862, 44, '2023-01-30'),
  (10863, 35, '2023-02-02'),
  (10864, 4, '2023-02-02'),
  (10865, 63, '2023-02-02'),
  (10866, 5, '2023-02-03'),
  (10867, 48, '2023-02-03'),
  (10868, 62, '2023-02-04'),
  (10869, 72, '2023-02-04'),
  (10870, 91, '2023-02-04'),
  (10871, 9, '2023-02-05'),
  (10872, 30, '2023-02-05'),
  (10873, 90, '2023-02-06'),
  (10874, 30, '2023-02-06'),
  (10875, 5, '2023-02-06'),
  (10876, 9, '2023-02-09'),
  (10877, 67, '2023-02-09'),
  (10878, 63, '2023-02-10'),
  (10879, 90, '2023-02-10'),
  (10880, 24, '2023-02-10'),
  (10881, 12, '2023-02-11'),
  (10882, 71, '2023-02-11'),
  (10883, 48, '2023-02-12'),
  (10884, 45, '2023-02-12'),
  (10885, 76, '2023-02-12'),
  (10886, 34, '2023-02-13'),
  (10887, 29, '2023-02-13'),
  (10888, 30, '2023-02-16'),
  (10889, 65, '2023-02-16'),
  (10890, 18, '2023-02-16'),
  (10891, 44, '2023-02-17'),
  (10892, 50, '2023-02-17'),
  (10893, 39, '2023-02-18'),
  (10894, 71, '2023-02-18'),
  (10895, 20, '2023-02-18'),
  (10896, 50, '2023-02-19'),
  (10897, 37, '2023-02-19'),
  (10898, 54, '2023-02-20'),
  (10899, 46, '2023-02-20'),
  (10900, 88, '2023-02-20'),
  (10901, 35, '2023-02-23'),
  (10902, 24, '2023-02-23'),
  (10903, 34, '2023-02-24'),
  (10904, 89, '2023-02-24'),
  (10905, 88, '2023-02-24'),
  (10906, 91, '2023-02-25'),
  (10907, 74, '2023-02-25'),
  (10908, 66, '2023-02-26'),
  (10909, 70, '2023-02-26'),
  (10910, 90, '2023-02-26'),
  (10911, 30, '2023-02-26'),
  (10912, 37, '2023-02-26'),
  (10913, 62, '2023-02-26'),
  (10914, 62, '2023-02-27'),
  (10915, 80, '2023-02-27'),
  (10916, 64, '2023-02-27'),
  (10917, 69, '2023-03-02'),
  (10918, 10, '2023-03-02'),
  (10919, 47, '2023-03-02'),
  (10920, 4, '2023-03-03'),
  (10921, 83, '2023-03-03'),
  (10922, 34, '2023-03-03'),
  (10923, 41, '2023-03-03'),
  (10924, 5, '2023-03-04'),
  (10925, 34, '2023-03-04'),
  (10926, 2, '2023-03-04'),
  (10927, 40, '2023-03-05'),
  (10928, 29, '2023-03-05'),
  (10929, 25, '2023-03-05'),
  (10930, 76, '2023-03-06'),
  (10931, 68, '2023-03-06'),
  (10932, 9, '2023-03-06'),
  (10933, 38, '2023-03-06'),
  (10934, 44, '2023-03-09'),
  (10935, 88, '2023-03-09'),
  (10936, 32, '2023-03-09'),
  (10937, 12, '2023-03-10'),
  (10938, 63, '2023-03-10'),
  (10939, 49, '2023-03-10'),
  (10940, 9, '2023-03-11'),
  (10941, 71, '2023-03-11'),
  (10942, 66, '2023-03-11'),
  (10943, 11, '2023-03-11'),
  (10944, 10, '2023-03-12'),
  (10945, 52, '2023-03-12'),
  (10946, 83, '2023-03-12'),
  (10947, 11, '2023-03-13'),
  (10948, 30, '2023-03-13'),
  (10949, 10, '2023-03-13'),
  (10950, 49, '2023-03-16'),
  (10951, 68, '2023-03-16'),
  (10952, 1, '2023-03-16'),
  (10953, 4, '2023-03-16'),
  (10954, 47, '2023-03-17'),
  (10955, 24, '2023-03-17'),
  (10956, 6, '2023-03-17'),
  (10957, 35, '2023-03-18'),
  (10958, 54, '2023-03-18'),
  (10959, 31, '2023-03-18'),
  (10960, 35, '2023-03-19'),
  (10961, 62, '2023-03-19'),
  (10962, 63, '2023-03-19'),
  (10963, 28, '2023-03-19'),
  (10964, 74, '2023-03-20'),
  (10965, 55, '2023-03-20'),
  (10966, 14, '2023-03-20'),
  (10967, 79, '2023-03-23'),
  (10968, 20, '2023-03-23'),
  (10969, 15, '2023-03-23'),
  (10970, 8, '2023-03-24'),
  (10971, 26, '2023-03-24'),
  (10972, 40, '2023-03-24'),
  (10973, 40, '2023-03-24'),
  (10974, 75, '2023-03-25'),
  (10975, 10, '2023-03-25'),
  (10976, 35, '2023-03-25'),
  (10977, 24, '2023-03-26'),
  (10978, 50, '2023-03-26'),
  (10979, 20, '2023-03-26'),
  (10980, 24, '2023-03-27'),
  (10981, 34, '2023-03-27'),
  (10982, 10, '2023-03-27'),
  (10983, 71, '2023-03-27'),
  (10984, 71, '2023-03-30'),
  (10985, 37, '2023-03-30'),
  (10986, 54, '2023-03-30'),
  (10987, 19, '2023-03-31'),
  (10988, 65, '2023-03-31'),
  (10989, 61, '2023-03-31'),
  (10990, 20, '2023-04-01'),
  (10991, 63, '2023-04-01'),
  (10992, 77, '2023-04-01'),
  (10993, 24, '2023-04-01'),
  (10994, 83, '2023-04-02'),
  (10995, 58, '2023-04-02'),
  (10996, 63, '2023-04-02'),
  (10997, 46, '2023-04-03'),
  (10998, 91, '2023-04-03'),
  (10999, 56, '2023-04-03'),
  (11000, 65, '2023-04-06'),
  (11001, 24, '2023-04-06'),
  (11002, 71, '2023-04-06'),
  (11003, 78, '2023-04-06'),
  (11004, 50, '2023-04-07'),
  (11005, 90, '2023-04-07'),
  (11006, 32, '2023-04-07'),
  (11007, 60, '2023-04-08'),
  (11008, 20, '2023-04-08'),
  (11009, 30, '2023-04-08'),
  (11010, 66, '2023-04-09'),
  (11011, 1, '2023-04-09'),
  (11012, 25, '2023-04-09'),
  (11013, 69, '2023-04-09'),
  (11014, 47, '2023-04-10'),
  (11015, 70, '2023-04-10'),
  (11016, 4, '2023-04-10'),
  (11017, 20, '2023-04-13'),
  (11018, 48, '2023-04-13'),
  (11019, 64, '2023-04-13'),
  (11020, 56, '2023-04-14'),
  (11021, 63, '2023-04-14'),
  (11022, 34, '2023-04-14'),
  (11023, 11, '2023-04-14'),
  (11024, 19, '2023-04-15'),
  (11025, 87, '2023-04-15'),
  (11026, 27, '2023-04-15'),
  (11027, 10, '2023-04-16'),
  (11028, 39, '2023-04-16'),
  (11029, 14, '2023-04-16'),
  (11030, 71, '2023-04-17'),
  (11031, 71, '2023-04-17'),
  (11032, 89, '2023-04-17'),
  (11033, 68, '2023-04-17'),
  (11034, 55, '2023-04-20'),
  (11035, 76, '2023-04-20'),
  (11036, 17, '2023-04-20'),
  (11037, 30, '2023-04-21'),
  (11038, 76, '2023-04-21'),
  (11039, 47, '2023-04-21'),
  (11040, 32, '2023-04-22'),
  (11041, 14, '2023-04-22'),
  (11042, 15, '2023-04-22'),
  (11043, 74, '2023-04-22'),
  (11044, 91, '2023-04-23'),
  (11045, 10, '2023-04-23'),
  (11046, 86, '2023-04-23'),
  (11047, 19, '2023-04-24'),
  (11048, 10, '2023-04-24'),
  (11049, 31, '2023-04-24'),
  (11050, 24, '2023-04-27'),
  (11051, 41, '2023-04-27'),
  (11052, 34, '2023-04-27'),
  (11053, 59, '2023-04-27'),
  (11054, 12, '2023-04-28'),
  (11055, 35, '2023-04-28'),
  (11056, 19, '2023-04-28'),
  (11057, 53, '2023-04-29'),
  (11058, 6, '2023-04-29'),
  (11059, 67, '2023-04-29'),
  (11060, 27, '2023-04-30'),
  (11061, 32, '2023-04-30'),
  (11062, 66, '2023-04-30'),
  (11063, 37, '2023-04-30'),
  (11064, 71, '2023-05-01'),
  (11065, 46, '2023-05-01'),
  (11066, 89, '2023-05-01'),
  (11067, 17, '2023-05-04'),
  (11068, 62, '2023-05-04'),
  (11069, 80, '2023-05-04'),
  (11070, 44, '2023-05-05'),
  (11071, 46, '2023-05-05'),
  (11072, 20, '2023-05-05'),
  (11073, 58, '2023-05-05'),
  (11074, 73, '2023-05-06'),
  (11075, 68, '2023-05-06'),
  (11076, 9, '2023-05-06'),
  (11077, 65, '2023-05-06');

結果

INSERT 0 830

結果也可以在此處檢視: 演示資料庫 - orders


ORDER_DETAILS(訂單詳情)

以下 SQL 語句將建立一個名為 order_details 的表

CREATE TABLE order_details

CREATE TABLE order_details (
  order_detail_id SERIAL NOT NULL PRIMARY KEY,
  order_id INT,
  product_id INT,
  quantity INT
);

結果

CREATE TABLE

以下 SQL 語句將填充 order_details 表的內容

INSERT INTO order_details

INSERT INTO order_details (order_id, product_id, quantity)
VALUES
  (10248, 11, 12),
  (10248, 42, 10),
  (10248, 72, 5),
  (10249, 14, 9),
  (10249, 51, 40),
  (10250, 41, 10),
  (10250, 51, 35),
  (10250, 65, 15),
  (10251, 22, 6),
  (10251, 57, 15),
  (10251, 65, 20),
  (10252, 20, 40),
  (10252, 33, 25),
  (10252, 60, 40),
  (10253, 31, 20),
  (10253, 39, 42),
  (10253, 49, 40),
  (10254, 24, 15),
  (10254, 55, 21),
  (10254, 74, 21),
  (10255, 2, 20),
  (10255, 16, 35),
  (10255, 36, 25),
  (10255, 59, 30),
  (10256, 53, 15),
  (10256, 77, 12),
  (10257, 27, 25),
  (10257, 39, 6),
  (10257, 77, 15),
  (10258, 2, 50),
  (10258, 5, 65),
  (10258, 32, 6),
  (10259, 21, 10),
  (10259, 37, 1),
  (10260, 41, 16),
  (10260, 57, 50),
  (10260, 62, 15),
  (10260, 70, 21),
  (10261, 21, 20),
  (10261, 35, 20),
  (10262, 5, 12),
  (10262, 7, 15),
  (10262, 56, 2),
  (10263, 16, 60),
  (10263, 24, 28),
  (10263, 30, 60),
  (10263, 74, 36),
  (10264, 2, 35),
  (10264, 41, 25),
  (10265, 17, 30),
  (10265, 70, 20),
  (10266, 12, 12),
  (10267, 40, 50),
  (10267, 59, 70),
  (10267, 76, 15),
  (10268, 29, 10),
  (10268, 72, 4),
  (10269, 33, 60),
  (10269, 72, 20),
  (10270, 36, 30),
  (10270, 43, 25),
  (10271, 33, 24),
  (10272, 20, 6),
  (10272, 31, 40),
  (10272, 72, 24),
  (10273, 10, 24),
  (10273, 31, 15),
  (10273, 33, 20),
  (10273, 40, 60),
  (10273, 76, 33),
  (10274, 71, 20),
  (10274, 72, 7),
  (10275, 24, 12),
  (10275, 59, 6),
  (10276, 10, 15),
  (10276, 13, 10),
  (10277, 28, 20),
  (10277, 62, 12),
  (10278, 44, 16),
  (10278, 59, 15),
  (10278, 63, 8),
  (10278, 73, 25),
  (10279, 17, 15),
  (10280, 24, 12),
  (10280, 55, 20),
  (10280, 75, 30),
  (10281, 19, 1),
  (10281, 24, 6),
  (10281, 35, 4),
  (10282, 30, 6),
  (10282, 57, 2),
  (10283, 15, 20),
  (10283, 19, 18),
  (10283, 60, 35),
  (10283, 72, 3),
  (10284, 27, 15),
  (10284, 44, 21),
  (10284, 60, 20),
  (10284, 67, 5),
  (10285, 1, 45),
  (10285, 40, 40),
  (10285, 53, 36),
  (10286, 35, 100),
  (10286, 62, 40),
  (10287, 16, 40),
  (10287, 34, 20),
  (10287, 46, 15),
  (10288, 54, 10),
  (10288, 68, 3),
  (10289, 3, 30),
  (10289, 64, 9),
  (10290, 5, 20),
  (10290, 29, 15),
  (10290, 49, 15),
  (10290, 77, 10),
  (10291, 13, 20),
  (10291, 44, 24),
  (10291, 51, 2),
  (10292, 20, 20),
  (10293, 18, 12),
  (10293, 24, 10),
  (10293, 63, 5),
  (10293, 75, 6),
  (10294, 1, 18),
  (10294, 17, 15),
  (10294, 43, 15),
  (10294, 60, 21),
  (10294, 75, 6),
  (10295, 56, 4),
  (10296, 11, 12),
  (10296, 16, 30),
  (10296, 69, 15),
  (10297, 39, 60),
  (10297, 72, 20),
  (10298, 2, 40),
  (10298, 36, 40),
  (10298, 59, 30),
  (10298, 62, 15),
  (10299, 19, 15),
  (10299, 70, 20),
  (10300, 66, 30),
  (10300, 68, 20),
  (10301, 40, 10),
  (10301, 56, 20),
  (10302, 17, 40),
  (10302, 28, 28),
  (10302, 43, 12),
  (10303, 40, 40),
  (10303, 65, 30),
  (10303, 68, 15),
  (10304, 49, 30),
  (10304, 59, 10),
  (10304, 71, 2),
  (10305, 18, 25),
  (10305, 29, 25),
  (10305, 39, 30),
  (10306, 30, 10),
  (10306, 53, 10),
  (10306, 54, 5),
  (10307, 62, 10),
  (10307, 68, 3),
  (10308, 69, 1),
  (10308, 70, 5),
  (10309, 4, 20),
  (10309, 6, 30),
  (10309, 42, 2),
  (10309, 43, 20),
  (10309, 71, 3),
  (10310, 16, 10),
  (10310, 62, 5),
  (10311, 42, 6),
  (10311, 69, 7),
  (10312, 28, 4),
  (10312, 43, 24),
  (10312, 53, 20),
  (10312, 75, 10),
  (10313, 36, 12),
  (10314, 32, 40),
  (10314, 58, 30),
  (10314, 62, 25),
  (10315, 34, 14),
  (10315, 70, 30),
  (10316, 41, 10),
  (10316, 62, 70),
  (10317, 1, 20),
  (10318, 41, 20),
  (10318, 76, 6),
  (10319, 17, 8),
  (10319, 28, 14),
  (10319, 76, 30),
  (10320, 71, 30),
  (10321, 35, 10),
  (10322, 52, 20),
  (10323, 15, 5),
  (10323, 25, 4),
  (10323, 39, 4),
  (10324, 16, 21),
  (10324, 35, 70),
  (10324, 46, 30),
  (10324, 59, 40),
  (10324, 63, 80),
  (10325, 6, 6),
  (10325, 13, 12),
  (10325, 14, 9),
  (10325, 31, 4),
  (10325, 72, 40),
  (10326, 4, 24),
  (10326, 57, 16),
  (10326, 75, 50),
  (10327, 2, 25),
  (10327, 11, 50),
  (10327, 30, 35),
  (10327, 58, 30),
  (10328, 59, 9),
  (10328, 65, 40),
  (10328, 68, 10),
  (10329, 19, 10),
  (10329, 30, 8),
  (10329, 38, 20),
  (10329, 56, 12),
  (10330, 26, 50),
  (10330, 72, 25),
  (10331, 54, 15),
  (10332, 18, 40),
  (10332, 42, 10),
  (10332, 47, 16),
  (10333, 14, 10),
  (10333, 21, 10),
  (10333, 71, 40),
  (10334, 52, 8),
  (10334, 68, 10),
  (10335, 2, 7),
  (10335, 31, 25),
  (10335, 32, 6),
  (10335, 51, 48),
  (10336, 4, 18),
  (10337, 23, 40),
  (10337, 26, 24),
  (10337, 36, 20),
  (10337, 37, 28),
  (10337, 72, 25),
  (10338, 17, 20),
  (10338, 30, 15),
  (10339, 4, 10),
  (10339, 17, 70),
  (10339, 62, 28),
  (10340, 18, 20),
  (10340, 41, 12),
  (10340, 43, 40),
  (10341, 33, 8),
  (10341, 59, 9),
  (10342, 2, 24),
  (10342, 31, 56),
  (10342, 36, 40),
  (10342, 55, 40),
  (10343, 64, 50),
  (10343, 68, 4),
  (10343, 76, 15),
  (10344, 4, 35),
  (10344, 8, 70),
  (10345, 8, 70),
  (10345, 19, 80),
  (10345, 42, 9),
  (10346, 17, 36),
  (10346, 56, 20),
  (10347, 25, 10),
  (10347, 39, 50),
  (10347, 40, 4),
  (10347, 75, 6),
  (10348, 1, 15),
  (10348, 23, 25),
  (10349, 54, 24),
  (10350, 50, 15),
  (10350, 69, 18),
  (10351, 38, 20),
  (10351, 41, 13),
  (10351, 44, 77),
  (10351, 65, 10),
  (10352, 24, 10),
  (10352, 54, 20),
  (10353, 11, 12),
  (10353, 38, 50),
  (10354, 1, 12),
  (10354, 29, 4),
  (10355, 24, 25),
  (10355, 57, 25),
  (10356, 31, 30),
  (10356, 55, 12),
  (10356, 69, 20),
  (10357, 10, 30),
  (10357, 26, 16),
  (10357, 60, 8),
  (10358, 24, 10),
  (10358, 34, 10),
  (10358, 36, 20),
  (10359, 16, 56),
  (10359, 31, 70),
  (10359, 60, 80),
  (10360, 28, 30),
  (10360, 29, 35),
  (10360, 38, 10),
  (10360, 49, 35),
  (10360, 54, 28),
  (10361, 39, 54),
  (10361, 60, 55),
  (10362, 25, 50),
  (10362, 51, 20),
  (10362, 54, 24),
  (10363, 31, 20),
  (10363, 75, 12),
  (10363, 76, 12),
  (10364, 69, 30),
  (10364, 71, 5),
  (10365, 11, 24),
  (10366, 65, 5),
  (10366, 77, 5),
  (10367, 34, 36),
  (10367, 54, 18),
  (10367, 65, 15),
  (10367, 77, 7),
  (10368, 21, 5),
  (10368, 28, 13),
  (10368, 57, 25),
  (10368, 64, 35),
  (10369, 29, 20),
  (10369, 56, 18),
  (10370, 1, 15),
  (10370, 64, 30),
  (10370, 74, 20),
  (10371, 36, 6),
  (10372, 20, 12),
  (10372, 38, 40),
  (10372, 60, 70),
  (10372, 72, 42),
  (10373, 58, 80),
  (10373, 71, 50),
  (10374, 31, 30),
  (10374, 58, 15),
  (10375, 14, 15),
  (10375, 54, 10),
  (10376, 31, 42),
  (10377, 28, 20),
  (10377, 39, 20),
  (10378, 71, 6),
  (10379, 41, 8),
  (10379, 63, 16),
  (10379, 65, 20),
  (10380, 30, 18),
  (10380, 53, 20),
  (10380, 60, 6),
  (10380, 70, 30),
  (10381, 74, 14),
  (10382, 5, 32),
  (10382, 18, 9),
  (10382, 29, 14),
  (10382, 33, 60),
  (10382, 74, 50),
  (10383, 13, 20),
  (10383, 50, 15),
  (10383, 56, 20),
  (10384, 20, 28),
  (10384, 60, 15),
  (10385, 7, 10),
  (10385, 60, 20),
  (10385, 68, 8),
  (10386, 24, 15),
  (10386, 34, 10),
  (10387, 24, 15),
  (10387, 28, 6),
  (10387, 59, 12),
  (10387, 71, 15),
  (10388, 45, 15),
  (10388, 52, 20),
  (10388, 53, 40),
  (10389, 10, 16),
  (10389, 55, 15),
  (10389, 62, 20),
  (10389, 70, 30),
  (10390, 31, 60),
  (10390, 35, 40),
  (10390, 46, 45),
  (10390, 72, 24),
  (10391, 13, 18),
  (10392, 69, 50),
  (10393, 2, 25),
  (10393, 14, 42),
  (10393, 25, 7),
  (10393, 26, 70),
  (10393, 31, 32),
  (10394, 13, 10),
  (10394, 62, 10),
  (10395, 46, 28),
  (10395, 53, 70),
  (10395, 69, 8),
  (10396, 23, 40),
  (10396, 71, 60),
  (10396, 72, 21),
  (10397, 21, 10),
  (10397, 51, 18),
  (10398, 35, 30),
  (10398, 55, 120),
  (10399, 68, 60),
  (10399, 71, 30),
  (10399, 76, 35),
  (10399, 77, 14),
  (10400, 29, 21),
  (10400, 35, 35),
  (10400, 49, 30),
  (10401, 30, 18),
  (10401, 56, 70),
  (10401, 65, 20),
  (10401, 71, 60),
  (10402, 23, 60),
  (10402, 63, 65),
  (10403, 16, 21),
  (10403, 48, 70),
  (10404, 26, 30),
  (10404, 42, 40),
  (10404, 49, 30),
  (10405, 3, 50),
  (10406, 1, 10),
  (10406, 21, 30),
  (10406, 28, 42),
  (10406, 36, 5),
  (10406, 40, 2),
  (10407, 11, 30),
  (10407, 69, 15),
  (10407, 71, 15),
  (10408, 37, 10),
  (10408, 54, 6),
  (10408, 62, 35),
  (10409, 14, 12),
  (10409, 21, 12),
  (10410, 33, 49),
  (10410, 59, 16),
  (10411, 41, 25),
  (10411, 44, 40),
  (10411, 59, 9),
  (10412, 14, 20),
  (10413, 1, 24),
  (10413, 62, 40),
  (10413, 76, 14),
  (10414, 19, 18),
  (10414, 33, 50),
  (10415, 17, 2),
  (10415, 33, 20),
  (10416, 19, 20),
  (10416, 53, 10),
  (10416, 57, 20),
  (10417, 38, 50),
  (10417, 46, 2),
  (10417, 68, 36),
  (10417, 77, 35),
  (10418, 2, 60),
  (10418, 47, 55),
  (10418, 61, 16),
  (10418, 74, 15),
  (10419, 60, 60),
  (10419, 69, 20),
  (10420, 9, 20),
  (10420, 13, 2),
  (10420, 70, 8),
  (10420, 73, 20),
  (10421, 19, 4),
  (10421, 26, 30),
  (10421, 53, 15),
  (10421, 77, 10),
  (10422, 26, 2),
  (10423, 31, 14),
  (10423, 59, 20),
  (10424, 35, 60),
  (10424, 38, 49),
  (10424, 68, 30),
  (10425, 55, 10),
  (10425, 76, 20),
  (10426, 56, 5),
  (10426, 64, 7),
  (10427, 14, 35),
  (10428, 46, 20),
  (10429, 50, 40),
  (10429, 63, 35),
  (10430, 17, 45),
  (10430, 21, 50),
  (10430, 56, 30),
  (10430, 59, 70),
  (10431, 17, 50),
  (10431, 40, 50),
  (10431, 47, 30),
  (10432, 26, 10),
  (10432, 54, 40),
  (10433, 56, 28),
  (10434, 11, 6),
  (10434, 76, 18),
  (10435, 2, 10),
  (10435, 22, 12),
  (10435, 72, 10),
  (10436, 46, 5),
  (10436, 56, 40),
  (10436, 64, 30),
  (10436, 75, 24),
  (10437, 53, 15),
  (10438, 19, 15),
  (10438, 34, 20),
  (10438, 57, 15),
  (10439, 12, 15),
  (10439, 16, 16),
  (10439, 64, 6),
  (10439, 74, 30),
  (10440, 2, 45),
  (10440, 16, 49),
  (10440, 29, 24),
  (10440, 61, 90),
  (10441, 27, 50),
  (10442, 11, 30),
  (10442, 54, 80),
  (10442, 66, 60),
  (10443, 11, 6),
  (10443, 28, 12),
  (10444, 17, 10),
  (10444, 26, 15),
  (10444, 35, 8),
  (10444, 41, 30),
  (10445, 39, 6),
  (10445, 54, 15),
  (10446, 19, 12),
  (10446, 24, 20),
  (10446, 31, 3),
  (10446, 52, 15),
  (10447, 19, 40),
  (10447, 65, 35),
  (10447, 71, 2),
  (10448, 26, 6),
  (10448, 40, 20),
  (10449, 10, 14),
  (10449, 52, 20),
  (10449, 62, 35),
  (10450, 10, 20),
  (10450, 54, 6),
  (10451, 55, 120),
  (10451, 64, 35),
  (10451, 65, 28),
  (10451, 77, 55),
  (10452, 28, 15),
  (10452, 44, 100),
  (10453, 48, 15),
  (10453, 70, 25),
  (10454, 16, 20),
  (10454, 33, 20),
  (10454, 46, 10),
  (10455, 39, 20),
  (10455, 53, 50),
  (10455, 61, 25),
  (10455, 71, 30),
  (10456, 21, 40),
  (10456, 49, 21),
  (10457, 59, 36),
  (10458, 26, 30),
  (10458, 28, 30),
  (10458, 43, 20),
  (10458, 56, 15),
  (10458, 71, 50),
  (10459, 7, 16),
  (10459, 46, 20),
  (10459, 72, 40),
  (10460, 68, 21),
  (10460, 75, 4),
  (10461, 21, 40),
  (10461, 30, 28),
  (10461, 55, 60),
  (10462, 13, 1),
  (10462, 23, 21),
  (10463, 19, 21),
  (10463, 42, 50),
  (10464, 4, 16),
  (10464, 43, 3),
  (10464, 56, 30),
  (10464, 60, 20),
  (10465, 24, 25),
  (10465, 29, 18),
  (10465, 40, 20),
  (10465, 45, 30),
  (10465, 50, 25),
  (10466, 11, 10),
  (10466, 46, 5),
  (10467, 24, 28),
  (10467, 25, 12),
  (10468, 30, 8),
  (10468, 43, 15),
  (10469, 2, 40),
  (10469, 16, 35),
  (10469, 44, 2),
  (10470, 18, 30),
  (10470, 23, 15),
  (10470, 64, 8),
  (10471, 7, 30),
  (10471, 56, 20),
  (10472, 24, 80),
  (10472, 51, 18),
  (10473, 33, 12),
  (10473, 71, 12),
  (10474, 14, 12),
  (10474, 28, 18),
  (10474, 40, 21),
  (10474, 75, 10),
  (10475, 31, 35),
  (10475, 66, 60),
  (10475, 76, 42),
  (10476, 55, 2),
  (10476, 70, 12),
  (10477, 1, 15),
  (10477, 21, 21),
  (10477, 39, 20),
  (10478, 10, 20),
  (10479, 38, 30),
  (10479, 53, 28),
  (10479, 59, 60),
  (10479, 64, 30),
  (10480, 47, 30),
  (10480, 59, 12),
  (10481, 49, 24),
  (10481, 60, 40),
  (10482, 40, 10),
  (10483, 34, 35),
  (10483, 77, 30),
  (10484, 21, 14),
  (10484, 40, 10),
  (10484, 51, 3),
  (10485, 2, 20),
  (10485, 3, 20),
  (10485, 55, 30),
  (10485, 70, 60),
  (10486, 11, 5),
  (10486, 51, 25),
  (10486, 74, 16),
  (10487, 19, 5),
  (10487, 26, 30),
  (10487, 54, 24),
  (10488, 59, 30),
  (10488, 73, 20),
  (10489, 11, 15),
  (10489, 16, 18),
  (10490, 59, 60),
  (10490, 68, 30),
  (10490, 75, 36),
  (10491, 44, 15),
  (10491, 77, 7),
  (10492, 25, 60),
  (10492, 42, 20),
  (10493, 65, 15),
  (10493, 66, 10),
  (10493, 69, 10),
  (10494, 56, 30),
  (10495, 23, 10),
  (10495, 41, 20),
  (10495, 77, 5),
  (10496, 31, 20),
  (10497, 56, 14),
  (10497, 72, 25),
  (10497, 77, 25),
  (10498, 24, 14),
  (10498, 40, 5),
  (10498, 42, 30),
  (10499, 28, 20),
  (10499, 49, 25),
  (10500, 15, 12),
  (10500, 28, 8),
  (10501, 54, 20),
  (10502, 45, 21),
  (10502, 53, 6),
  (10502, 67, 30),
  (10503, 14, 70),
  (10503, 65, 20),
  (10504, 2, 12),
  (10504, 21, 12),
  (10504, 53, 10),
  (10504, 61, 25),
  (10505, 62, 3),
  (10506, 25, 18),
  (10506, 70, 14),
  (10507, 43, 15),
  (10507, 48, 15),
  (10508, 13, 10),
  (10508, 39, 10),
  (10509, 28, 3),
  (10510, 29, 36),
  (10510, 75, 36),
  (10511, 4, 50),
  (10511, 7, 50),
  (10511, 8, 10),
  (10512, 24, 10),
  (10512, 46, 9),
  (10512, 47, 6),
  (10512, 60, 12),
  (10513, 21, 40),
  (10513, 32, 50),
  (10513, 61, 15),
  (10514, 20, 39),
  (10514, 28, 35),
  (10514, 56, 70),
  (10514, 65, 39),
  (10514, 75, 50),
  (10515, 9, 16),
  (10515, 16, 50),
  (10515, 27, 120),
  (10515, 33, 16),
  (10515, 60, 84),
  (10516, 18, 25),
  (10516, 41, 80),
  (10516, 42, 20),
  (10517, 52, 6),
  (10517, 59, 4),
  (10517, 70, 6),
  (10518, 24, 5),
  (10518, 38, 15),
  (10518, 44, 9),
  (10519, 10, 16),
  (10519, 56, 40),
  (10519, 60, 10),
  (10520, 24, 8),
  (10520, 53, 5),
  (10521, 35, 3),
  (10521, 41, 10),
  (10521, 68, 6),
  (10522, 1, 40),
  (10522, 8, 24),
  (10522, 30, 20),
  (10522, 40, 25),
  (10523, 17, 25),
  (10523, 20, 15),
  (10523, 37, 18),
  (10523, 41, 6),
  (10524, 10, 2),
  (10524, 30, 10),
  (10524, 43, 60),
  (10524, 54, 15),
  (10525, 36, 30),
  (10525, 40, 15),
  (10526, 1, 8),
  (10526, 13, 10),
  (10526, 56, 30),
  (10527, 4, 50),
  (10527, 36, 30),
  (10528, 11, 3),
  (10528, 33, 8),
  (10528, 72, 9),
  (10529, 55, 14),
  (10529, 68, 20),
  (10529, 69, 10),
  (10530, 17, 40),
  (10530, 43, 25),
  (10530, 61, 20),
  (10530, 76, 50),
  (10531, 59, 2),
  (10532, 30, 15),
  (10532, 66, 24),
  (10533, 4, 50),
  (10533, 72, 24),
  (10533, 73, 24),
  (10534, 30, 10),
  (10534, 40, 10),
  (10534, 54, 10),
  (10535, 11, 50),
  (10535, 40, 10),
  (10535, 57, 5),
  (10535, 59, 15),
  (10536, 12, 15),
  (10536, 31, 20),
  (10536, 33, 30),
  (10536, 60, 35),
  (10537, 31, 30),
  (10537, 51, 6),
  (10537, 58, 20),
  (10537, 72, 21),
  (10537, 73, 9),
  (10538, 70, 7),
  (10538, 72, 1),
  (10539, 13, 8),
  (10539, 21, 15),
  (10539, 33, 15),
  (10539, 49, 6),
  (10540, 3, 60),
  (10540, 26, 40),
  (10540, 38, 30),
  (10540, 68, 35),
  (10541, 24, 35),
  (10541, 38, 4),
  (10541, 65, 36),
  (10541, 71, 9),
  (10542, 11, 15),
  (10542, 54, 24),
  (10543, 12, 30),
  (10543, 23, 70),
  (10544, 28, 7),
  (10544, 67, 7),
  (10545, 11, 10),
  (10546, 7, 10),
  (10546, 35, 30),
  (10546, 62, 40),
  (10547, 32, 24),
  (10547, 36, 60),
  (10548, 34, 10),
  (10548, 41, 14),
  (10549, 31, 55),
  (10549, 45, 100),
  (10549, 51, 48),
  (10550, 17, 8),
  (10550, 19, 10),
  (10550, 21, 6),
  (10550, 61, 10),
  (10551, 16, 40),
  (10551, 35, 20),
  (10551, 44, 40),
  (10552, 69, 18),
  (10552, 75, 30),
  (10553, 11, 15),
  (10553, 16, 14),
  (10553, 22, 24),
  (10553, 31, 30),
  (10553, 35, 6),
  (10554, 16, 30),
  (10554, 23, 20),
  (10554, 62, 20),
  (10554, 77, 10),
  (10555, 14, 30),
  (10555, 19, 35),
  (10555, 24, 18),
  (10555, 51, 20),
  (10555, 56, 40),
  (10556, 72, 24),
  (10557, 64, 30),
  (10557, 75, 20),
  (10558, 47, 25),
  (10558, 51, 20),
  (10558, 52, 30),
  (10558, 53, 18),
  (10558, 73, 3),
  (10559, 41, 12),
  (10559, 55, 18),
  (10560, 30, 20),
  (10560, 62, 15),
  (10561, 44, 10),
  (10561, 51, 50),
  (10562, 33, 20),
  (10562, 62, 10),
  (10563, 36, 25),
  (10563, 52, 70),
  (10564, 17, 16),
  (10564, 31, 6),
  (10564, 55, 25),
  (10565, 24, 25),
  (10565, 64, 18),
  (10566, 11, 35),
  (10566, 18, 18),
  (10566, 76, 10),
  (10567, 31, 60),
  (10567, 51, 3),
  (10567, 59, 40),
  (10568, 10, 5),
  (10569, 31, 35),
  (10569, 76, 30),
  (10570, 11, 15),
  (10570, 56, 60),
  (10571, 14, 11),
  (10571, 42, 28),
  (10572, 16, 12),
  (10572, 32, 10),
  (10572, 40, 50),
  (10572, 75, 15),
  (10573, 17, 18),
  (10573, 34, 40),
  (10573, 53, 25),
  (10574, 33, 14),
  (10574, 40, 2),
  (10574, 62, 10),
  (10574, 64, 6),
  (10575, 59, 12),
  (10575, 63, 6),
  (10575, 72, 30),
  (10575, 76, 10),
  (10576, 1, 10),
  (10576, 31, 20),
  (10576, 44, 21),
  (10577, 39, 10),
  (10577, 75, 20),
  (10577, 77, 18),
  (10578, 35, 20),
  (10578, 57, 6),
  (10579, 15, 10),
  (10579, 75, 21),
  (10580, 14, 15),
  (10580, 41, 9),
  (10580, 65, 30),
  (10581, 75, 50),
  (10582, 57, 4),
  (10582, 76, 14),
  (10583, 29, 10),
  (10583, 60, 24),
  (10583, 69, 10),
  (10584, 31, 50),
  (10585, 47, 15),
  (10586, 52, 4),
  (10587, 26, 6),
  (10587, 35, 20),
  (10587, 77, 20),
  (10588, 18, 40),
  (10588, 42, 100),
  (10589, 35, 4),
  (10590, 1, 20),
  (10590, 77, 60),
  (10591, 3, 14),
  (10591, 7, 10),
  (10591, 54, 50),
  (10592, 15, 25),
  (10592, 26, 5),
  (10593, 20, 21),
  (10593, 69, 20),
  (10593, 76, 4),
  (10594, 52, 24),
  (10594, 58, 30),
  (10595, 35, 30),
  (10595, 61, 120),
  (10595, 69, 65),
  (10596, 56, 5),
  (10596, 63, 24),
  (10596, 75, 30),
  (10597, 24, 35),
  (10597, 57, 20),
  (10597, 65, 12),
  (10598, 27, 50),
  (10598, 71, 9),
  (10599, 62, 10),
  (10600, 54, 4),
  (10600, 73, 30),
  (10601, 13, 60),
  (10601, 59, 35),
  (10602, 77, 5),
  (10603, 22, 48),
  (10603, 49, 25),
  (10604, 48, 6),
  (10604, 76, 10),
  (10605, 16, 30),
  (10605, 59, 20),
  (10605, 60, 70),
  (10605, 71, 15),
  (10606, 4, 20),
  (10606, 55, 20),
  (10606, 62, 10),
  (10607, 7, 45),
  (10607, 17, 100),
  (10607, 33, 14),
  (10607, 40, 42),
  (10607, 72, 12),
  (10608, 56, 28),
  (10609, 1, 3),
  (10609, 10, 10),
  (10609, 21, 6),
  (10610, 36, 21),
  (10611, 1, 6),
  (10611, 2, 10),
  (10611, 60, 15),
  (10612, 10, 70),
  (10612, 36, 55),
  (10612, 49, 18),
  (10612, 60, 40),
  (10612, 76, 80),
  (10613, 13, 8),
  (10613, 75, 40),
  (10614, 11, 14),
  (10614, 21, 8),
  (10614, 39, 5),
  (10615, 55, 5),
  (10616, 38, 15),
  (10616, 56, 14),
  (10616, 70, 15),
  (10616, 71, 15),
  (10617, 59, 30),
  (10618, 6, 70),
  (10618, 56, 20),
  (10618, 68, 15),
  (10619, 21, 42),
  (10619, 22, 40),
  (10620, 24, 5),
  (10620, 52, 5),
  (10621, 19, 5),
  (10621, 23, 10),
  (10621, 70, 20),
  (10621, 71, 15),
  (10622, 2, 20),
  (10622, 68, 18),
  (10623, 14, 21),
  (10623, 19, 15),
  (10623, 21, 25),
  (10623, 24, 3),
  (10623, 35, 30),
  (10624, 28, 10),
  (10624, 29, 6),
  (10624, 44, 10),
  (10625, 14, 3),
  (10625, 42, 5),
  (10625, 60, 10),
  (10626, 53, 12),
  (10626, 60, 20),
  (10626, 71, 20),
  (10627, 62, 15),
  (10627, 73, 35),
  (10628, 1, 25),
  (10629, 29, 20),
  (10629, 64, 9),
  (10630, 55, 12),
  (10630, 76, 35),
  (10631, 75, 8),
  (10632, 2, 30),
  (10632, 33, 20),
  (10633, 12, 36),
  (10633, 13, 13),
  (10633, 26, 35),
  (10633, 62, 80),
  (10634, 7, 35),
  (10634, 18, 50),
  (10634, 51, 15),
  (10634, 75, 2),
  (10635, 4, 10),
  (10635, 5, 15),
  (10635, 22, 40),
  (10636, 4, 25),
  (10636, 58, 6),
  (10637, 11, 10),
  (10637, 50, 25),
  (10637, 56, 60),
  (10638, 45, 20),
  (10638, 65, 21),
  (10638, 72, 60),
  (10639, 18, 8),
  (10640, 69, 20),
  (10640, 70, 15),
  (10641, 2, 50),
  (10641, 40, 60),
  (10642, 21, 30),
  (10642, 61, 20),
  (10643, 28, 15),
  (10643, 39, 21),
  (10643, 46, 2),
  (10644, 18, 4),
  (10644, 43, 20),
  (10644, 46, 21),
  (10645, 18, 20),
  (10645, 36, 15),
  (10646, 1, 15),
  (10646, 10, 18),
  (10646, 71, 30),
  (10646, 77, 35),
  (10647, 19, 30),
  (10647, 39, 20),
  (10648, 22, 15),
  (10648, 24, 15),
  (10649, 28, 20),
  (10649, 72, 15),
  (10650, 30, 30),
  (10650, 53, 25),
  (10650, 54, 30),
  (10651, 19, 12),
  (10651, 22, 20),
  (10652, 30, 2),
  (10652, 42, 20),
  (10653, 16, 30),
  (10653, 60, 20),
  (10654, 4, 12),
  (10654, 39, 20),
  (10654, 54, 6),
  (10655, 41, 20),
  (10656, 14, 3),
  (10656, 44, 28),
  (10656, 47, 6),
  (10657, 15, 50),
  (10657, 41, 24),
  (10657, 46, 45),
  (10657, 47, 10),
  (10657, 56, 45),
  (10657, 60, 30),
  (10658, 21, 60),
  (10658, 40, 70),
  (10658, 60, 55),
  (10658, 77, 70),
  (10659, 31, 20),
  (10659, 40, 24),
  (10659, 70, 40),
  (10660, 20, 21),
  (10661, 39, 3),
  (10661, 58, 49),
  (10662, 68, 10),
  (10663, 40, 30),
  (10663, 42, 30),
  (10663, 51, 20),
  (10664, 10, 24),
  (10664, 56, 12),
  (10664, 65, 15),
  (10665, 51, 20),
  (10665, 59, 1),
  (10665, 76, 10),
  (10666, 29, 36),
  (10666, 65, 10),
  (10667, 69, 45),
  (10667, 71, 14),
  (10668, 31, 8),
  (10668, 55, 4),
  (10668, 64, 15),
  (10669, 36, 30),
  (10670, 23, 32),
  (10670, 46, 60),
  (10670, 67, 25),
  (10670, 73, 50),
  (10670, 75, 25),
  (10671, 16, 10),
  (10671, 62, 10),
  (10671, 65, 12),
  (10672, 38, 15),
  (10672, 71, 12),
  (10673, 16, 3),
  (10673, 42, 6),
  (10673, 43, 6),
  (10674, 23, 5),
  (10675, 14, 30),
  (10675, 53, 10),
  (10675, 58, 30),
  (10676, 10, 2),
  (10676, 19, 7),
  (10676, 44, 21),
  (10677, 26, 30),
  (10677, 33, 8),
  (10678, 12, 100),
  (10678, 33, 30),
  (10678, 41, 120),
  (10678, 54, 30),
  (10679, 59, 12),
  (10680, 16, 50),
  (10680, 31, 20),
  (10680, 42, 40),
  (10681, 19, 30),
  (10681, 21, 12),
  (10681, 64, 28),
  (10682, 33, 30),
  (10682, 66, 4),
  (10682, 75, 30),
  (10683, 52, 9),
  (10684, 40, 20),
  (10684, 47, 40),
  (10684, 60, 30),
  (10685, 10, 20),
  (10685, 41, 4),
  (10685, 47, 15),
  (10686, 17, 30),
  (10686, 26, 15),
  (10687, 9, 50),
  (10687, 29, 10),
  (10687, 36, 6),
  (10688, 10, 18),
  (10688, 28, 60),
  (10688, 34, 14),
  (10689, 1, 35),
  (10690, 56, 20),
  (10690, 77, 30),
  (10691, 1, 30),
  (10691, 29, 40),
  (10691, 43, 40),
  (10691, 44, 24),
  (10691, 62, 48),
  (10692, 63, 20),
  (10693, 9, 6),
  (10693, 54, 60),
  (10693, 69, 30),
  (10693, 73, 15),
  (10694, 7, 90),
  (10694, 59, 25),
  (10694, 70, 50),
  (10695, 8, 10),
  (10695, 12, 4),
  (10695, 24, 20),
  (10696, 17, 20),
  (10696, 46, 18),
  (10697, 19, 7),
  (10697, 35, 9),
  (10697, 58, 30),
  (10697, 70, 30),
  (10698, 11, 15),
  (10698, 17, 8),
  (10698, 29, 12),
  (10698, 65, 65),
  (10698, 70, 8),
  (10699, 47, 12),
  (10700, 1, 5),
  (10700, 34, 12),
  (10700, 68, 40),
  (10700, 71, 60),
  (10701, 59, 42),
  (10701, 71, 20),
  (10701, 76, 35),
  (10702, 3, 6),
  (10702, 76, 15),
  (10703, 2, 5),
  (10703, 59, 35),
  (10703, 73, 35),
  (10704, 4, 6),
  (10704, 24, 35),
  (10704, 48, 24),
  (10705, 31, 20),
  (10705, 32, 4),
  (10706, 16, 20),
  (10706, 43, 24),
  (10706, 59, 8),
  (10707, 55, 21),
  (10707, 57, 40),
  (10707, 70, 28),
  (10708, 5, 4),
  (10708, 36, 5),
  (10709, 8, 40),
  (10709, 51, 28),
  (10709, 60, 10),
  (10710, 19, 5),
  (10710, 47, 5),
  (10711, 19, 12),
  (10711, 41, 42),
  (10711, 53, 120),
  (10712, 53, 3),
  (10712, 56, 30),
  (10713, 10, 18),
  (10713, 26, 30),
  (10713, 45, 110),
  (10713, 46, 24),
  (10714, 2, 30),
  (10714, 17, 27),
  (10714, 47, 50),
  (10714, 56, 18),
  (10714, 58, 12),
  (10715, 10, 21),
  (10715, 71, 30),
  (10716, 21, 5),
  (10716, 51, 7),
  (10716, 61, 10),
  (10717, 21, 32),
  (10717, 54, 15),
  (10717, 69, 25),
  (10718, 12, 36),
  (10718, 16, 20),
  (10718, 36, 40),
  (10718, 62, 20),
  (10719, 18, 12),
  (10719, 30, 3),
  (10719, 54, 40),
  (10720, 35, 21),
  (10720, 71, 8),
  (10721, 44, 50),
  (10722, 2, 3),
  (10722, 31, 50),
  (10722, 68, 45),
  (10722, 75, 42),
  (10723, 26, 15),
  (10724, 10, 16),
  (10724, 61, 5),
  (10725, 41, 12),
  (10725, 52, 4),
  (10725, 55, 6),
  (10726, 4, 25),
  (10726, 11, 5),
  (10727, 17, 20),
  (10727, 56, 10),
  (10727, 59, 10),
  (10728, 30, 15),
  (10728, 40, 6),
  (10728, 55, 12),
  (10728, 60, 15),
  (10729, 1, 50),
  (10729, 21, 30),
  (10729, 50, 40),
  (10730, 16, 15),
  (10730, 31, 3),
  (10730, 65, 10),
  (10731, 21, 40),
  (10731, 51, 30),
  (10732, 76, 20),
  (10733, 14, 16),
  (10733, 28, 20),
  (10733, 52, 25),
  (10734, 6, 30),
  (10734, 30, 15),
  (10734, 76, 20),
  (10735, 61, 20),
  (10735, 77, 2),
  (10736, 65, 40),
  (10736, 75, 20),
  (10737, 13, 4),
  (10737, 41, 12),
  (10738, 16, 3),
  (10739, 36, 6),
  (10739, 52, 18),
  (10740, 28, 5),
  (10740, 35, 35),
  (10740, 45, 40),
  (10740, 56, 14),
  (10741, 2, 15),
  (10742, 3, 20),
  (10742, 60, 50),
  (10742, 72, 35),
  (10743, 46, 28),
  (10744, 40, 50),
  (10745, 18, 24),
  (10745, 44, 16),
  (10745, 59, 45),
  (10745, 72, 7),
  (10746, 13, 6),
  (10746, 42, 28),
  (10746, 62, 9),
  (10746, 69, 40),
  (10747, 31, 8),
  (10747, 41, 35),
  (10747, 63, 9),
  (10747, 69, 30),
  (10748, 23, 44),
  (10748, 40, 40),
  (10748, 56, 28),
  (10749, 56, 15),
  (10749, 59, 6),
  (10749, 76, 10),
  (10750, 14, 5),
  (10750, 45, 40),
  (10750, 59, 25),
  (10751, 26, 12),
  (10751, 30, 30),
  (10751, 50, 20),
  (10751, 73, 15),
  (10752, 1, 8),
  (10752, 69, 3),
  (10753, 45, 4),
  (10753, 74, 5),
  (10754, 40, 3),
  (10755, 47, 30),
  (10755, 56, 30),
  (10755, 57, 14),
  (10755, 69, 25),
  (10756, 18, 21),
  (10756, 36, 20),
  (10756, 68, 6),
  (10756, 69, 20),
  (10757, 34, 30),
  (10757, 59, 7),
  (10757, 62, 30),
  (10757, 64, 24),
  (10758, 26, 20),
  (10758, 52, 60),
  (10758, 70, 40),
  (10759, 32, 10),
  (10760, 25, 12),
  (10760, 27, 40),
  (10760, 43, 30),
  (10761, 25, 35),
  (10761, 75, 18),
  (10762, 39, 16),
  (10762, 47, 30),
  (10762, 51, 28),
  (10762, 56, 60),
  (10763, 21, 40),
  (10763, 22, 6),
  (10763, 24, 20),
  (10764, 3, 20),
  (10764, 39, 130),
  (10765, 65, 80),
  (10766, 2, 40),
  (10766, 7, 35),
  (10766, 68, 40),
  (10767, 42, 2),
  (10768, 22, 4),
  (10768, 31, 50),
  (10768, 60, 15),
  (10768, 71, 12),
  (10769, 41, 30),
  (10769, 52, 15),
  (10769, 61, 20),
  (10769, 62, 15),
  (10770, 11, 15),
  (10771, 71, 16),
  (10772, 29, 18),
  (10772, 59, 25),
  (10773, 17, 33),
  (10773, 31, 70),
  (10773, 75, 7),
  (10774, 31, 2),
  (10774, 66, 50),
  (10775, 10, 6),
  (10775, 67, 3),
  (10776, 31, 16),
  (10776, 42, 12),
  (10776, 45, 27),
  (10776, 51, 120),
  (10777, 42, 20),
  (10778, 41, 10),
  (10779, 16, 20),
  (10779, 62, 20),
  (10780, 70, 35),
  (10780, 77, 15),
  (10781, 54, 3),
  (10781, 56, 20),
  (10781, 74, 35),
  (10782, 31, 1),
  (10783, 31, 10),
  (10783, 38, 5),
  (10784, 36, 30),
  (10784, 39, 2),
  (10784, 72, 30),
  (10785, 10, 10),
  (10785, 75, 10),
  (10786, 8, 30),
  (10786, 30, 15),
  (10786, 75, 42),
  (10787, 2, 15),
  (10787, 29, 20),
  (10788, 19, 50),
  (10788, 75, 40),
  (10789, 18, 30),
  (10789, 35, 15),
  (10789, 63, 30),
  (10789, 68, 18),
  (10790, 7, 3),
  (10790, 56, 20),
  (10791, 29, 14),
  (10791, 41, 20),
  (10792, 2, 10),
  (10792, 54, 3),
  (10792, 68, 15),
  (10793, 41, 14),
  (10793, 52, 8),
  (10794, 14, 15),
  (10794, 54, 6),
  (10795, 16, 65),
  (10795, 17, 35),
  (10796, 26, 21),
  (10796, 44, 10),
  (10796, 64, 35),
  (10796, 69, 24),
  (10797, 11, 20),
  (10798, 62, 2),
  (10798, 72, 10),
  (10799, 13, 20),
  (10799, 24, 20),
  (10799, 59, 25),
  (10800, 11, 50),
  (10800, 51, 10),
  (10800, 54, 7),
  (10801, 17, 40),
  (10801, 29, 20),
  (10802, 30, 25),
  (10802, 51, 30),
  (10802, 55, 60),
  (10802, 62, 5),
  (10803, 19, 24),
  (10803, 25, 15),
  (10803, 59, 15),
  (10804, 10, 36),
  (10804, 28, 24),
  (10804, 49, 4),
  (10805, 34, 10),
  (10805, 38, 10),
  (10806, 2, 20),
  (10806, 65, 2),
  (10806, 74, 15),
  (10807, 40, 1),
  (10808, 56, 20),
  (10808, 76, 50),
  (10809, 52, 20),
  (10810, 13, 7),
  (10810, 25, 5),
  (10810, 70, 5),
  (10811, 19, 15),
  (10811, 23, 18),
  (10811, 40, 30),
  (10812, 31, 16),
  (10812, 72, 40),
  (10812, 77, 20),
  (10813, 2, 12),
  (10813, 46, 35),
  (10814, 41, 20),
  (10814, 43, 20),
  (10814, 48, 8),
  (10814, 61, 30),
  (10815, 33, 16),
  (10816, 38, 30),
  (10816, 62, 20),
  (10817, 26, 40),
  (10817, 38, 30),
  (10817, 40, 60),
  (10817, 62, 25),
  (10818, 32, 20),
  (10818, 41, 20),
  (10819, 43, 7),
  (10819, 75, 20),
  (10820, 56, 30),
  (10821, 35, 20),
  (10821, 51, 6),
  (10822, 62, 3),
  (10822, 70, 6),
  (10823, 11, 20),
  (10823, 57, 15),
  (10823, 59, 40),
  (10823, 77, 15),
  (10824, 41, 12),
  (10824, 70, 9),
  (10825, 26, 12),
  (10825, 53, 20),
  (10826, 31, 35),
  (10826, 57, 15),
  (10827, 10, 15),
  (10827, 39, 21),
  (10828, 20, 5),
  (10828, 38, 2),
  (10829, 2, 10),
  (10829, 8, 20),
  (10829, 13, 10),
  (10829, 60, 21),
  (10830, 6, 6),
  (10830, 39, 28),
  (10830, 60, 30),
  (10830, 68, 24),
  (10831, 19, 2),
  (10831, 35, 8),
  (10831, 38, 8),
  (10831, 43, 9),
  (10832, 13, 3),
  (10832, 25, 10),
  (10832, 44, 16),
  (10832, 64, 3),
  (10833, 7, 20),
  (10833, 31, 9),
  (10833, 53, 9),
  (10834, 29, 8),
  (10834, 30, 20),
  (10835, 59, 15),
  (10835, 77, 2),
  (10836, 22, 52),
  (10836, 35, 6),
  (10836, 57, 24),
  (10836, 60, 60),
  (10836, 64, 30),
  (10837, 13, 6),
  (10837, 40, 25),
  (10837, 47, 40),
  (10837, 76, 21),
  (10838, 1, 4),
  (10838, 18, 25),
  (10838, 36, 50),
  (10839, 58, 30),
  (10839, 72, 15),
  (10840, 25, 6),
  (10840, 39, 10),
  (10841, 10, 16),
  (10841, 56, 30),
  (10841, 59, 50),
  (10841, 77, 15),
  (10842, 11, 15),
  (10842, 43, 5),
  (10842, 68, 20),
  (10842, 70, 12),
  (10843, 51, 4),
  (10844, 22, 35),
  (10845, 23, 70),
  (10845, 35, 25),
  (10845, 42, 42),
  (10845, 58, 60),
  (10845, 64, 48),
  (10846, 4, 21),
  (10846, 70, 30),
  (10846, 74, 20),
  (10847, 1, 80),
  (10847, 19, 12),
  (10847, 37, 60),
  (10847, 45, 36),
  (10847, 60, 45),
  (10847, 71, 55),
  (10848, 5, 30),
  (10848, 9, 3),
  (10849, 3, 49),
  (10849, 26, 18),
  (10850, 25, 20),
  (10850, 33, 4),
  (10850, 70, 30),
  (10851, 2, 5),
  (10851, 25, 10),
  (10851, 57, 10),
  (10851, 59, 42),
  (10852, 2, 15),
  (10852, 17, 6),
  (10852, 62, 50),
  (10853, 18, 10),
  (10854, 10, 100),
  (10854, 13, 65),
  (10855, 16, 50),
  (10855, 31, 14),
  (10855, 56, 24),
  (10855, 65, 15),
  (10856, 2, 20),
  (10856, 42, 20),
  (10857, 3, 30),
  (10857, 26, 35),
  (10857, 29, 10),
  (10858, 7, 5),
  (10858, 27, 10),
  (10858, 70, 4),
  (10859, 24, 40),
  (10859, 54, 35),
  (10859, 64, 30),
  (10860, 51, 3),
  (10860, 76, 20),
  (10861, 17, 42),
  (10861, 18, 20),
  (10861, 21, 40),
  (10861, 33, 35),
  (10861, 62, 3),
  (10862, 11, 25),
  (10862, 52, 8),
  (10863, 1, 20),
  (10863, 58, 12),
  (10864, 35, 4),
  (10864, 67, 15),
  (10865, 38, 60),
  (10865, 39, 80),
  (10866, 2, 21),
  (10866, 24, 6),
  (10866, 30, 40),
  (10867, 53, 3),
  (10868, 26, 20),
  (10868, 35, 30),
  (10868, 49, 42),
  (10869, 1, 40),
  (10869, 11, 10),
  (10869, 23, 50),
  (10869, 68, 20),
  (10870, 35, 3),
  (10870, 51, 2),
  (10871, 6, 50),
  (10871, 16, 12),
  (10871, 17, 16),
  (10872, 55, 10),
  (10872, 62, 20),
  (10872, 64, 15),
  (10872, 65, 21),
  (10873, 21, 20),
  (10873, 28, 3),
  (10874, 10, 10),
  (10875, 19, 25),
  (10875, 47, 21),
  (10875, 49, 15),
  (10876, 46, 21),
  (10876, 64, 20),
  (10877, 16, 30),
  (10877, 18, 25),
  (10878, 20, 20),
  (10879, 40, 12),
  (10879, 65, 10),
  (10879, 76, 10),
  (10880, 23, 30),
  (10880, 61, 30),
  (10880, 70, 50),
  (10881, 73, 10),
  (10882, 42, 25),
  (10882, 49, 20),
  (10882, 54, 32),
  (10883, 24, 8),
  (10884, 21, 40),
  (10884, 56, 21),
  (10884, 65, 12),
  (10885, 2, 20),
  (10885, 24, 12),
  (10885, 70, 30),
  (10885, 77, 25),
  (10886, 10, 70),
  (10886, 31, 35),
  (10886, 77, 40),
  (10887, 25, 5),
  (10888, 2, 20),
  (10888, 68, 18),
  (10889, 11, 40),
  (10889, 38, 40),
  (10890, 17, 15),
  (10890, 34, 10),
  (10890, 41, 14),
  (10891, 30, 15),
  (10892, 59, 40),
  (10893, 8, 30),
  (10893, 24, 10),
  (10893, 29, 24),
  (10893, 30, 35),
  (10893, 36, 20),
  (10894, 13, 28),
  (10894, 69, 50),
  (10894, 75, 120),
  (10895, 24, 110),
  (10895, 39, 45),
  (10895, 40, 91),
  (10895, 60, 100),
  (10896, 45, 15),
  (10896, 56, 16),
  (10897, 29, 80),
  (10897, 30, 36),
  (10898, 13, 5),
  (10899, 39, 8),
  (10900, 70, 3),
  (10901, 41, 30),
  (10901, 71, 30),
  (10902, 55, 30),
  (10902, 62, 6),
  (10903, 13, 40),
  (10903, 65, 21),
  (10903, 68, 20),
  (10904, 58, 15),
  (10904, 62, 35),
  (10905, 1, 20),
  (10906, 61, 15),
  (10907, 75, 14),
  (10908, 7, 20),
  (10908, 52, 14),
  (10909, 7, 12),
  (10909, 16, 15),
  (10909, 41, 5),
  (10910, 19, 12),
  (10910, 49, 10),
  (10910, 61, 5),
  (10911, 1, 10),
  (10911, 17, 12),
  (10911, 67, 15),
  (10912, 11, 40),
  (10912, 29, 60),
  (10913, 4, 30),
  (10913, 33, 40),
  (10913, 58, 15),
  (10914, 71, 25),
  (10915, 17, 10),
  (10915, 33, 30),
  (10915, 54, 10),
  (10916, 16, 6),
  (10916, 32, 6),
  (10916, 57, 20),
  (10917, 30, 1),
  (10917, 60, 10),
  (10918, 1, 60),
  (10918, 60, 25),
  (10919, 16, 24),
  (10919, 25, 24),
  (10919, 40, 20),
  (10920, 50, 24),
  (10921, 35, 10),
  (10921, 63, 40),
  (10922, 17, 15),
  (10922, 24, 35),
  (10923, 42, 10),
  (10923, 43, 10),
  (10923, 67, 24),
  (10924, 10, 20),
  (10924, 28, 30),
  (10924, 75, 6),
  (10925, 36, 25),
  (10925, 52, 12),
  (10926, 11, 2),
  (10926, 13, 10),
  (10926, 19, 7),
  (10926, 72, 10),
  (10927, 20, 5),
  (10927, 52, 5),
  (10927, 76, 20),
  (10928, 47, 5),
  (10928, 76, 5),
  (10929, 21, 60),
  (10929, 75, 49),
  (10929, 77, 15),
  (10930, 21, 36),
  (10930, 27, 25),
  (10930, 55, 25),
  (10930, 58, 30),
  (10931, 13, 42),
  (10931, 57, 30),
  (10932, 16, 30),
  (10932, 62, 14),
  (10932, 72, 16),
  (10932, 75, 20),
  (10933, 53, 2),
  (10933, 61, 30),
  (10934, 6, 20),
  (10935, 1, 21),
  (10935, 18, 4),
  (10935, 23, 8),
  (10936, 36, 30),
  (10937, 28, 8),
  (10937, 34, 20),
  (10938, 13, 20),
  (10938, 43, 24),
  (10938, 60, 49),
  (10938, 71, 35),
  (10939, 2, 10),
  (10939, 67, 40),
  (10940, 7, 8),
  (10940, 13, 20),
  (10941, 31, 44),
  (10941, 62, 30),
  (10941, 68, 80),
  (10941, 72, 50),
  (10942, 49, 28),
  (10943, 13, 15),
  (10943, 22, 21),
  (10943, 46, 15),
  (10944, 11, 5),
  (10944, 44, 18),
  (10944, 56, 18),
  (10945, 13, 20),
  (10945, 31, 10),
  (10946, 10, 25),
  (10946, 24, 25),
  (10946, 77, 40),
  (10947, 59, 4),
  (10948, 50, 9),
  (10948, 51, 40),
  (10948, 55, 4),
  (10949, 6, 12),
  (10949, 10, 30),
  (10949, 17, 6),
  (10949, 62, 60),
  (10950, 4, 5),
  (10951, 33, 15),
  (10951, 41, 6),
  (10951, 75, 50),
  (10952, 6, 16),
  (10952, 28, 2),
  (10953, 20, 50),
  (10953, 31, 50),
  (10954, 16, 28),
  (10954, 31, 25),
  (10954, 45, 30),
  (10954, 60, 24),
  (10955, 75, 12),
  (10956, 21, 12),
  (10956, 47, 14),
  (10956, 51, 8),
  (10957, 30, 30),
  (10957, 35, 40),
  (10957, 64, 8),
  (10958, 5, 20),
  (10958, 7, 6),
  (10958, 72, 5),
  (10959, 75, 20),
  (10960, 24, 10),
  (10960, 41, 24),
  (10961, 52, 6),
  (10961, 76, 60),
  (10962, 7, 45),
  (10962, 13, 77),
  (10962, 53, 20),
  (10962, 69, 9),
  (10962, 76, 44),
  (10963, 60, 2),
  (10964, 18, 6),
  (10964, 38, 5),
  (10964, 69, 10),
  (10965, 51, 16),
  (10966, 37, 8),
  (10966, 56, 12),
  (10966, 62, 12),
  (10967, 19, 12),
  (10967, 49, 40),
  (10968, 12, 30),
  (10968, 24, 30),
  (10968, 64, 4),
  (10969, 46, 9),
  (10970, 52, 40),
  (10971, 29, 14),
  (10972, 17, 6),
  (10972, 33, 7),
  (10973, 26, 5),
  (10973, 41, 6),
  (10973, 75, 10),
  (10974, 63, 10),
  (10975, 8, 16),
  (10975, 75, 10),
  (10976, 28, 20),
  (10977, 39, 30),
  (10977, 47, 30),
  (10977, 51, 10),
  (10977, 63, 20),
  (10978, 8, 20),
  (10978, 21, 40),
  (10978, 40, 10),
  (10978, 44, 6),
  (10979, 7, 18),
  (10979, 12, 20),
  (10979, 24, 80),
  (10979, 27, 30),
  (10979, 31, 24),
  (10979, 63, 35),
  (10980, 75, 40),
  (10981, 38, 60),
  (10982, 7, 20),
  (10982, 43, 9),
  (10983, 13, 84),
  (10983, 57, 15),
  (10984, 16, 55),
  (10984, 24, 20),
  (10984, 36, 40),
  (10985, 16, 36),
  (10985, 18, 8),
  (10985, 32, 35),
  (10986, 11, 30),
  (10986, 20, 15),
  (10986, 76, 10),
  (10986, 77, 15),
  (10987, 7, 60),
  (10987, 43, 6),
  (10987, 72, 20),
  (10988, 7, 60),
  (10988, 62, 40),
  (10989, 6, 40),
  (10989, 11, 15),
  (10989, 41, 4),
  (10990, 21, 65),
  (10990, 34, 60),
  (10990, 55, 65),
  (10990, 61, 66),
  (10991, 2, 50),
  (10991, 70, 20),
  (10991, 76, 90),
  (10992, 72, 2),
  (10993, 29, 50),
  (10993, 41, 35),
  (10994, 59, 18),
  (10995, 51, 20),
  (10995, 60, 4),
  (10996, 42, 40),
  (10997, 32, 50),
  (10997, 46, 20),
  (10997, 52, 20),
  (10998, 24, 12),
  (10998, 61, 7),
  (10998, 74, 20),
  (10998, 75, 30),
  (10999, 41, 20),
  (10999, 51, 15),
  (10999, 77, 21),
  (11000, 4, 25),
  (11000, 24, 30),
  (11000, 77, 30),
  (11001, 7, 60),
  (11001, 22, 25),
  (11001, 46, 25),
  (11001, 55, 6),
  (11002, 13, 56),
  (11002, 35, 15),
  (11002, 42, 24),
  (11002, 55, 40),
  (11003, 1, 4),
  (11003, 40, 10),
  (11003, 52, 10),
  (11004, 26, 6),
  (11004, 76, 6),
  (11005, 1, 2),
  (11005, 59, 10),
  (11006, 1, 8),
  (11006, 29, 2),
  (11007, 8, 30),
  (11007, 29, 10),
  (11007, 42, 14),
  (11008, 28, 70),
  (11008, 34, 90),
  (11008, 71, 21),
  (11009, 24, 12),
  (11009, 36, 18),
  (11009, 60, 9),
  (11010, 7, 20),
  (11010, 24, 10),
  (11011, 58, 40),
  (11011, 71, 20),
  (11012, 19, 50),
  (11012, 60, 36),
  (11012, 71, 60),
  (11013, 23, 10),
  (11013, 42, 4),
  (11013, 45, 20),
  (11013, 68, 2),
  (11014, 41, 28),
  (11015, 30, 15),
  (11015, 77, 18),
  (11016, 31, 15),
  (11016, 36, 16),
  (11017, 3, 25),
  (11017, 59, 110),
  (11017, 70, 30),
  (11018, 12, 20),
  (11018, 18, 10),
  (11018, 56, 5),
  (11019, 46, 3),
  (11019, 49, 2),
  (11020, 10, 24),
  (11021, 2, 11),
  (11021, 20, 15),
  (11021, 26, 63),
  (11021, 51, 44),
  (11021, 72, 35),
  (11022, 19, 35),
  (11022, 69, 30),
  (11023, 7, 4),
  (11023, 43, 30),
  (11024, 26, 12),
  (11024, 33, 30),
  (11024, 65, 21),
  (11024, 71, 50),
  (11025, 1, 10),
  (11025, 13, 20),
  (11026, 18, 8),
  (11026, 51, 10),
  (11027, 24, 30),
  (11027, 62, 21),
  (11028, 55, 35),
  (11028, 59, 24),
  (11029, 56, 20),
  (11029, 63, 12),
  (11030, 2, 100),
  (11030, 5, 70),
  (11030, 29, 60),
  (11030, 59, 100),
  (11031, 1, 45),
  (11031, 13, 80),
  (11031, 24, 21),
  (11031, 64, 20),
  (11031, 71, 16),
  (11032, 36, 35),
  (11032, 38, 25),
  (11032, 59, 30),
  (11033, 53, 70),
  (11033, 69, 36),
  (11034, 21, 15),
  (11034, 44, 12),
  (11034, 61, 6),
  (11035, 1, 10),
  (11035, 35, 60),
  (11035, 42, 30),
  (11035, 54, 10),
  (11036, 13, 7),
  (11036, 59, 30),
  (11037, 70, 4),
  (11038, 40, 5),
  (11038, 52, 2),
  (11038, 71, 30),
  (11039, 28, 20),
  (11039, 35, 24),
  (11039, 49, 60),
  (11039, 57, 28),
  (11040, 21, 20),
  (11041, 2, 30),
  (11041, 63, 30),
  (11042, 44, 15),
  (11042, 61, 4),
  (11043, 11, 10),
  (11044, 62, 12),
  (11045, 33, 15),
  (11045, 51, 24),
  (11046, 12, 20),
  (11046, 32, 15),
  (11046, 35, 18),
  (11047, 1, 25),
  (11047, 5, 30),
  (11048, 68, 42),
  (11049, 2, 10),
  (11049, 12, 4),
  (11050, 76, 50),
  (11051, 24, 10),
  (11052, 43, 30),
  (11052, 61, 10),
  (11053, 18, 35),
  (11053, 32, 20),
  (11053, 64, 25),
  (11054, 33, 10),
  (11054, 67, 20),
  (11055, 24, 15),
  (11055, 25, 15),
  (11055, 51, 20),
  (11055, 57, 20),
  (11056, 7, 40),
  (11056, 55, 35),
  (11056, 60, 50),
  (11057, 70, 3),
  (11058, 21, 3),
  (11058, 60, 21),
  (11058, 61, 4),
  (11059, 13, 30),
  (11059, 17, 12),
  (11059, 60, 35),
  (11060, 60, 4),
  (11060, 77, 10),
  (11061, 60, 15),
  (11062, 53, 10),
  (11062, 70, 12),
  (11063, 34, 30),
  (11063, 40, 40),
  (11063, 41, 30),
  (11064, 17, 77),
  (11064, 41, 12),
  (11064, 53, 25),
  (11064, 55, 4),
  (11064, 68, 55),
  (11065, 30, 4),
  (11065, 54, 20),
  (11066, 16, 3),
  (11066, 19, 42),
  (11066, 34, 35),
  (11067, 41, 9),
  (11068, 28, 8),
  (11068, 43, 36),
  (11068, 77, 28),
  (11069, 39, 20),
  (11070, 1, 40),
  (11070, 2, 20),
  (11070, 16, 30),
  (11070, 31, 20),
  (11071, 7, 15),
  (11071, 13, 10),
  (11072, 2, 8),
  (11072, 41, 40),
  (11072, 50, 22),
  (11072, 64, 130),
  (11073, 11, 10),
  (11073, 24, 20),
  (11074, 16, 14),
  (11075, 2, 10),
  (11075, 46, 30),
  (11075, 76, 2),
  (11076, 6, 20),
  (11076, 14, 20),
  (11076, 19, 10),
  (11077, 2, 24),
  (11077, 3, 4),
  (11077, 4, 1),
  (11077, 6, 1),
  (11077, 7, 1),
  (11077, 8, 2),
  (11077, 10, 1),
  (11077, 12, 2),
  (11077, 13, 4),
  (11077, 14, 1),
  (11077, 16, 2),
  (11077, 20, 1),
  (11077, 23, 2),
  (11077, 32, 1),
  (11077, 39, 2),
  (11077, 41, 3),
  (11077, 46, 3),
  (11077, 52, 2),
  (11077, 55, 2),
  (11077, 60, 2),
  (11077, 64, 2),
  (11077, 66, 1),
  (11077, 73, 2),
  (11077, 75, 4),
  (11077, 77, 2);

結果

INSERT 0 2155

結果也可以在此處檢視: 演示資料庫 - order_details


TESTPRODUCTS(測試產品)

我們還將新增一個名為 testproducts 的表,用於本教程後續的演示。

以下 SQL 語句將建立一個名為 testproducts 的表

CREATE TABLE testproducts

CREATE TABLE testproducts (
  testproduct_id SERIAL NOT NULL PRIMARY KEY,
  product_name VARCHAR(255),
  category_id INT
);

結果

CREATE TABLE

我們將用 10 個虛擬產品填充該表

INSERT INTO testproducts

INSERT INTO testproducts (product_name, category_id)
VALUES
  ('Johns Fruit Cake', 3),
  ('Marys Healthy Mix', 9),
  ('Peters Scary Stuff', 10),
  ('Jims Secret Recipe', 11),
  ('Elisabeths Best Apples', 12),
  ('Janes Favorite Cheese', 4),
  ('Billys Home Made Pizza', 13),
  ('Ellas Special Salmon', 8),
  ('Roberts Rich Spaghetti', 5),
  ('Mias Popular Ice', 14);

結果

INSERT 0 10

結果也可以在此處檢視: 演示資料庫 - testproducts


×

聯絡銷售

如果您想將 W3Schools 服務用於教育機構、團隊或企業,請傳送電子郵件給我們
sales@w3schools.com

報告錯誤

如果您想報告錯誤,或想提出建議,請傳送電子郵件給我們
help@w3schools.com

W3Schools 經過最佳化,旨在方便學習和培訓。示例可能經過簡化,以提高閱讀和學習體驗。教程、參考資料和示例會不斷審查,以避免錯誤,但我們無法保證所有內容的完全正確性。使用 W3Schools 即表示您已閱讀並接受我們的使用條款Cookie 和隱私政策

版權所有 1999-2024 Refsnes Data。保留所有權利。W3Schools 由 W3.CSS 提供支援