Tạo cơ sở dữ liệu demo
Cơ sở dữ liệu demo
Cho đến thời điểm hiện tại trong hướng dẫn này, chúng ta đã làm việc với một bảng rất nhỏ và đơn giản trong cơ sở dữ liệu PostgreSQL của mình.
Bây giờ chúng tôi muốn tạo nhiều bảng hơn với nhiều nội dung hơn để có thể thể hiện nhiều tính năng cơ sở dữ liệu hơn.
Chúng tôi sẽ tạo 6 bảng này trong cơ sở dữ liệu PostgreSQL của mình:
Thể loại
khách hàng
các sản phẩm
mệnh lệnh
order_details
sản phẩm thử nghiệm
Dưới đây chúng tôi đã liệt kê tất cả các câu lệnh SQL mà bạn cần để tạo các bảng đó cùng với nội dung.
Bạn không bắt buộc phải tạo các bảng trên hệ thống của riêng mình để tiếp tục với hướng dẫn này, nhưng bạn có thể hiểu rõ hơn cách hoạt động của các câu lệnh PostgreSQL và SQL.
Hãy chắc chắn rằng bạn đã kết nối với cơ sở dữ liệu. Nếu không, hãy làm theo các bước trong chương SQL Shell của hướng dẫn này.
Khi đã kết nối, bạn đã sẵn sàng viết câu lệnh SQL!
THỂ LOẠI
Câu lệnh SQL sau đây sẽ tạo một bảng có tên là categories
:
TẠO danh mục BẢNG
CREATE TABLE categories (
category_id SERIAL NOT NULL PRIMARY KEY,
category_name VARCHAR(255),
description VARCHAR(255)
);
Kết quả
CREATE TABLE
Câu lệnh SQL sau đây sẽ điền nội dung vào bảng categories
:
CHÈN VÀO danh mục
INSERT INTO categories (category_name, description)
VALUES
('Beverages', 'Soft drinks, coffees, teas, beers, and ales'),
('Condiments', 'Sweet and savory sauces, relishes, spreads, and seasonings'),
('Confections', 'Desserts, candies, and sweet breads'),
('Dairy Products', 'Cheeses'),
('Grains/Cereals', 'Breads, crackers, pasta, and cereal'),
('Meat/Poultry', 'Prepared meats'),
('Produce', 'Dried fruit and bean curd'),
('Seafood', 'Seaweed and fish');
Kết quả
INSERT 0 8
Kết quả cũng có thể được xem ở đây: Cơ sở dữ liệu demo - danh mục
KHÁCH HÀNG
Câu lệnh SQL sau đây sẽ tạo một bảng có tên là customers
:
TẠO BẢNG khách hàng
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)
);
Kết quả
CREATE TABLE
Câu lệnh SQL sau đây sẽ điền nội dung vào bảng customers
:
CHÈN VÀO khách hàng
INSERT INTO customers (customer_name, contact_name, address, city, postal_code, country)
VALUES
('Alfreds Futterkiste', 'Maria Anders', 'Obere Str.
57', 'Berlin', '12209', 'Germany'),
('Ana Trujillo Emparedados
y helados', 'Ana Trujillo', 'Avda. de la Constitucion 2222', 'Mexico
D.F.', '05021', 'Mexico'),
('Antonio Moreno Taquera', 'Antonio
Moreno', 'Mataderos 2312', 'Mexico D.F.', '05023', 'Mexico'),
('Around the Horn', 'Thomas Hardy', '120 Hanover Sq.', 'London', 'WA1
1DP', 'UK'),
('Berglunds snabbkoep', 'Christina Berglund', 'Berguvsvegen
8', 'Lulea', 'S-958 22', 'Sweden'),
('Blauer See Delikatessen',
'Hanna Moos', 'Forsterstr. 57', 'Mannheim', '68306', 'Germany'),
('Blondel pere et fils', 'Frederique Citeaux', '24, place Kleber',
'Strasbourg', '67000', 'France'),
('Bolido Comidas preparadas',
'Martin Sommer', 'C/ Araquil, 67', 'Madrid', '28023', 'Spain'),
('Bon app', 'Laurence Lebihans', '12, rue des Bouchers', 'Marseille',
'13008', 'France'),
('Bottom-Dollar Marketse', 'Elizabeth
Lincoln', '23 Tsawassen Blvd.', 'Tsawassen', 'T2F 8M4', 'Canada'),
('Bs Beverages', 'Victoria Ashworth', 'Fauntleroy Circus', 'London',
'EC2 5NT', 'UK'),
('Cactus Comidas para llevar', 'Patricio
Simpson', 'Cerrito 333', 'Buenos Aires', '1010', 'Argentina'),
('Centro comercial Moctezuma', 'Francisco Chang', 'Sierras de Granada
9993', 'Mexico D.F.', '05022', 'Mexico'),
('Chop-suey
Chinese', 'Yang Wang', 'Hauptstr. 29', 'Bern', '3012', 'Switzerland'),
('Comercio Mineiro', 'Pedro Afonso', 'Av. dos Lusiadas, 23', 'Sao
Paulo', '05432-043', 'Brazil'),
('Consolidated Holdings',
'Elizabeth Brown', 'Berkeley Gardens 12 Brewery ', 'London', 'WX1 6LT',
'UK'),
('Drachenblut Delikatessend', 'Sven Ottlieb', 'Walserweg
21', 'Aachen', '52066', 'Germany'),
('Du monde entier',
'Janine Labrune', '67, rue des Cinquante Otages', 'Nantes', '44000',
'France'),
('Eastern Connection', 'Ann Devon', '35 King
George', 'London', 'WX3 6FW', 'UK'),
('Ernst Handel', 'Roland
Mendel', 'Kirchgasse 6', 'Graz', '8010', 'Austria'),
('Familia
Arquibaldo', 'Aria Cruz', 'Rua Oros, 92', 'Sao Paulo', '05442-030',
'Brazil'),
('FISSA Fabrica Inter. Salchichas S.A.', 'Diego
Roel', 'C/ Moralzarzal, 86', 'Madrid', '28034', 'Spain'),
('Folies
gourmandes', 'Martine Rance', '184, chaussee de Tournai', 'Lille',
'59000', 'France'),
('Folk och fe HB', 'Maria Larsson', 'Akergatan
24', 'Brecke', 'S-844 67', 'Sweden'),
('Frankenversand',
'Peter Franken', 'Berliner Platz 43', 'Munchen', '80805', 'Germany'),
('France restauration', 'Carine Schmitt', '54, rue Royale', 'Nantes',
'44000', 'France'),
('Franchi S.p.A.', 'Paolo Accorti', 'Via
Monte Bianco 34', 'Torino', '10100', 'Italy'),
('Furia
Bacalhau e Frutos do Mar', 'Lino Rodriguez ', 'Jardim das rosas n. 32',
'Lisboa', '1675', 'Portugal'),
('Galeria del gastronomo',
'Eduardo Saavedra', 'Rambla de Cataluna, 23', 'Barcelona', '08022',
'Spain'),
('Godos Cocina Tipica', 'Jose Pedro Freyre', 'C/
Romero, 33', 'Sevilla', '41101', 'Spain'),
('Gourmet
Lanchonetes', 'Andre Fonseca', 'Av. Brasil, 442', 'Campinas',
'04876-786', 'Brazil'),
('Great Lakes Food Market', 'Howard
Snyder', '2732 Baker Blvd.', 'Eugene', '97403', 'USA'),
('GROSELLA-Restaurante', 'Manuel Pereira', '5th Ave. Los Palos Grandes',
'Caracas', '1081', 'Venezuela'),
('Hanari Carnes', 'Mario
Pontes', 'Rua do Paco, 67', 'Rio de Janeiro', '05454-876', 'Brazil'),
('HILARION-Abastos', 'Carlos Hernandez', 'Carrera 22 con Ave. Carlos
Soublette #8-35', 'San Cristobal', '5022', 'Venezuela'),
('Hungry Coyote Import Store', 'Yoshi Latimer', 'City Center Plaza 516
Main St.', 'Elgin', '97827', 'USA'),
('Hungry Owl All-Night
Grocers', 'Patricia McKenna', '8 Johnstown Road', 'Cork', '',
'Ireland'),
('Island Trading', 'Helen Bennett', 'Garden House
Crowther Way', 'Cowes', 'PO31 7PJ', 'UK'),
('Koniglich Essen',
'Philip Cramer', 'Maubelstr. 90', 'Brandenburg', '14776', 'Germany'),
('La corne d abondance', 'Daniel Tonini', '67, avenue de l Europe',
'Versailles', '78000', 'France'),
('La maison d Asie',
'Annette Roulet', '1 rue Alsace-Lorraine', 'Toulouse', '31000',
'France'),
('Laughing Bacchus Wine Cellars', 'Yoshi Tannamuri',
'1900 Oak St.', 'Vancouver', 'V3F 2K1', 'Canada'),
('Lazy K
Kountry Store', 'John Steel', '12 Orchestra Terrace', 'Walla Walla',
'99362', 'USA'),
('Lehmanns Marktstand', 'Renate Messner', 'Magazinweg
7', 'Frankfurt a.M. ', '60528', 'Germany'),
('Lets Stop N
Shop', 'Jaime Yorres', '87 Polk St. Suite 5', 'San Francisco', '94117',
'USA'),
('LILA-Supermercado', 'Carlos Gonzalez', 'Carrera 52
con Ave. Bolivar #65-98 Llano Largo', 'Barquisimeto', '3508',
'Venezuela'),
('LINO-Delicateses', 'Felipe Izquierdo', 'Ave. 5
de Mayo Porlamar', 'I. de Margarita', '4980', 'Venezuela'),
('Lonesome Pine Restaurant', 'Fran Wilson', '89 Chiaroscuro Rd.',
'Portland', '97219', 'USA'),
('Magazzini Alimentari Riuniti',
'Giovanni Rovelli', 'Via Ludovico il Moro 22', 'Bergamo', '24100',
'Italy'),
('Maison Dewey', 'Catherine Dewey', 'Rue Joseph-Bens
532', 'Bruxelles', 'B-1180', 'Belgium'),
('Mere Paillarde',
'Jean Fresniere', '43 rue St. Laurent', 'Montreal', 'H1J 1C3',
'Canada'),
('Morgenstern Gesundkost', 'Alexander Feuer', 'Heerstr.
22', 'Leipzig', '04179', 'Germany'),
('North/South', 'Simon
Crowther', 'South House 300 Queensbridge', 'London', 'SW7 1RZ', 'UK'),
('Oceano Atlantico Ltda.', 'Yvonne Moncada', 'Ing. Gustavo Moncada 8585
Piso 20-A', 'Buenos Aires', '1010', 'Argentina'),
('Old World
Delicatessen', 'Rene Phillips', '2743 Bering St.', 'Anchorage', '99508',
'USA'),
('Ottilies Keseladen', 'Henriette Pfalzheim', 'Mehrheimerstr.
369', 'Koln', '50739', 'Germany'),
('Paris specialites',
'Marie Bertrand', '265, boulevard Charonne', 'Paris', '75012',
'France'),
('Pericles Comidas clasicas', 'Guillermo
Fernandez', 'Calle Dr. Jorge Cash 321', 'Mexico D.F.', '05033',
'Mexico'),
('Piccolo und mehr', 'Georg Pipps', 'Geislweg 14',
'Salzburg', '5020', 'Austria'),
('Princesa Isabel Vinhoss',
'Isabel de Castro', 'Estrada da saude n. 58', 'Lisboa', '1756',
'Portugal'),
('Que Delicia', 'Bernardo Batista', 'Rua da
Panificadora, 12', 'Rio de Janeiro', '02389-673', 'Brazil'),
('Queen Cozinha', 'Lucia Carvalho', 'Alameda dos Canarios, 891', 'Sao
Paulo', '05487-020', 'Brazil'),
('QUICK-Stop', 'Horst Kloss',
'Taucherstrasse 10', 'Cunewalde', '01307', 'Germany'),
('Rancho grande', 'Sergio Gutiarrez', 'Av. del Libertador 900', 'Buenos
Aires', '1010', 'Argentina'),
('Rattlesnake Canyon Grocery',
'Paula Wilson', '2817 Milton Dr.', 'Albuquerque', '87110', 'USA'),
('Reggiani Caseifici', 'Maurizio Moroni', 'Strada Provinciale 124',
'Reggio Emilia', '42100', 'Italy'),
('Ricardo Adocicados', 'Janete
Limeira', 'Av. Copacabana, 267', 'Rio de Janeiro', '02389-890',
'Brazil'),
('Richter Supermarkt', 'Michael Holz', 'Grenzacherweg
237', 'Genève', '1203', 'Switzerland'),
('Romero y tomillo',
'Alejandra Camino', 'Gran Via, 1', 'Madrid', '28001', 'Spain'),
('Santa Gourmet', 'Jonas Bergulfsen', 'Erling Skakkes gate 78', 'Stavern',
'4110', 'Norway'),
('Save-a-lot Markets', 'Jose Pavarotti',
'187 Suffolk Ln.', 'Boise', '83720', 'USA'),
('Seven Seas
Imports', 'Hari Kumar', '90 Wadhurst Rd.', 'London', 'OX15 4NB', 'UK'),
('Simons bistro', 'Jytte Petersen', 'Vinbeltet 34', 'Kobenhavn', '1734',
'Denmark'),
('Specialites du monde', 'Dominique Perrier', '25,
rue Lauriston', 'Paris', '75016', 'France'),
('Split Rail Beer
& Ale', 'Art Braunschweiger', 'P.O. Box 555', 'Lander', '82520', 'USA'),
('Supremes delices', 'Pascale Cartrain', 'Boulevard Tirou, 255',
'Charleroi', 'B-6000', 'Belgium'),
('The Big Cheese', 'Liz
Nixon', '89 Jefferson Way Suite 2', 'Portland', '97201', 'USA'),
('The Cracker Box', 'Liu Wong', '55 Grizzly Peak Rd.', 'Butte', '59801',
'USA'),
('Toms Spezialiteten', 'Karin Josephs', 'Luisenstr.
48', 'Manster', '44087', 'Germany'),
('Tortuga Restaurante',
'Miguel Angel Paolino', 'Avda. Azteca 123', 'Mexico D.F.', '05033',
'Mexico'),
('Tradicao Hipermercados', 'Anabela Domingues',
'Av. Ines de Castro, 414', 'Sao Paulo', '05634-030', 'Brazil'),
('Trails Head Gourmet Provisioners', 'Helvetius Nagy', '722 DaVinci
Blvd.', 'Kirkland', '98034', 'USA'),
('Vaffeljernet', 'Palle
Ibsen', 'Smagsloget 45', 'Arhus', '8200', 'Denmark'),
('Victuailles
en stock', 'Mary Saveley', '2, rue du Commerce', 'Lyon', '69004',
'France'),
('Vins et alcools Chevalier', 'Paul Henriot', '59
rue de l Abbaye', 'Reims', '51100', 'France'),
('Die Wandernde
Kuh', 'Rita Moller', 'Adenauerallee 900', 'Stuttgart', '70563',
'Germany'),
('Wartian Herkku', 'Pirkko Koskitalo', 'Torikatu
38', 'Oulu', '90110', 'Finland'),
('Wellington Importadora',
'Paula Parente', 'Rua do Mercado, 12', 'Resende', '08737-363',
'Brazil'),
('White Clover Markets', 'Karl Jablonski', '305 -
14th Ave. S. Suite 3B', 'Seattle', '98128', 'USA'),
('Wilman
Kala', 'Matti Karttunen', 'Keskuskatu 45', 'Helsinki', '21240',
'Finland'),
('Wolski', 'Zbyszek', 'ul. Filtrowa 68', 'Walla',
'01-012', 'Poland');
Kết quả
INSERT 0 91
Kết quả cũng có thể được nhìn thấy ở đây: Cơ sở dữ liệu demo - khách hàng
CÁC SẢN PHẨM
Câu lệnh SQL sau đây sẽ tạo một bảng có tên là products
:
TẠO sản phẩm BẢNG
CREATE TABLE products (
product_id SERIAL NOT NULL PRIMARY
KEY,
product_name VARCHAR(255),
category_id INT,
unit VARCHAR(255),
price
DECIMAL(10, 2)
);
Kết quả
CREATE TABLE
Câu lệnh SQL sau đây sẽ điền nội dung vào bảng products
:
CHÈN VÀO sản phẩm
INSERT INTO products (product_id, product_name, category_id,
unit, price)
VALUES
(1, 'Chais', 1, '10 boxes x 20 bags', 18),
(2, 'Chang', 1, '24 - 12 oz bottles', 19),
(3, 'Aniseed Syrup',
2, '12 - 550 ml bottles', 10),
(4, 'Chef Antons Cajun Seasoning',
2, '48 - 6 oz jars', 22),
(5, 'Chef Antons Gumbo Mix', 2, '36
boxes', 21.35),
(6, 'Grandmas Boysenberry Spread', 2, '12 - 8 oz
jars', 25),
(7, 'Uncle Bobs Organic Dried Pears', 7, '12 - 1 lb
pkgs.', 30),
(8, 'Northwoods Cranberry Sauce', 2, '12 - 12 oz
jars', 40),
(9, 'Mishi Kobe Niku', 6, '18 - 500 g pkgs.', 97),
(10, 'Ikura', 8, '12 - 200 ml jars', 31),
(11, 'Queso Cabrales',
4, '1 kg pkg.', 21),
(12, 'Queso Manchego La Pastora', 4, '10 -
500 g pkgs.', 38),
(13, 'Konbu', 8, '2 kg box', 6),
(14,
'Tofu', 7, '40 - 100 g pkgs.', 23.25),
(15, 'Genen Shouyu', 2,
'24 - 250 ml bottles', 15.5),
(16, 'Pavlova', 3, '32 - 500 g
boxes', 17.45),
(17, 'Alice Mutton', 6, '20 - 1 kg tins', 39),
(18, 'Carnarvon Tigers', 8, '16 kg pkg.', 62.5),
(19, 'Teatime
Chocolate Biscuits', 3, '10 boxes x 12 pieces', 9.2),
(20, 'Sir
Rodneys Marmalade', 3, '30 gift boxes', 81),
(21, 'Sir Rodneys
Scones', 3, '24 pkgs. x 4 pieces', 10),
(22, 'Gustafs Kneckebrod',
5, '24 - 500 g pkgs.', 21),
(23, 'Tunnbrod', 5, '12 - 250 g
pkgs.', 9),
(24, 'Guarani Fantastica', 1, '12 - 355 ml cans',
4.5),
(25, 'NuNuCa Nui-Nougat-Creme', 3, '20 - 450 g glasses',
14),
(26, 'Gumber Gummiberchen', 3, '100 - 250 g bags', 31.23),
(27, 'Schoggi Schokolade', 3, '100 - 100 g pieces', 43.9),
(28, 'Rassle
Sauerkraut', 7, '25 - 825 g cans', 45.6),
(29, 'Thoringer
Rostbratwurst', 6, '50 bags x 30 sausgs.', 123.79),
(30, 'Nord-Ost
Matjeshering', 8, '10 - 200 g glasses', 25.89),
(31, 'Gorgonzola
Telino', 4, '12 - 100 g pkgs', 12.5),
(32, 'Mascarpone Fabioli',
4, '24 - 200 g pkgs.', 32),
(33, 'Geitost', 4, '500 g', 2.5),
(34, 'Sasquatch Ale', 1, '24 - 12 oz bottles', 14),
(35, 'Steeleye
Stout', 1, '24 - 12 oz bottles', 18),
(36, 'Inlagd Sill', 8,
'24 - 250 g jars', 19),
(37, 'Gravad lax', 8, '12 - 500 g pkgs.',
26),
(38, 'Cote de Blaye', 1, '12 - 75 cl bottles', 263.5),
(39, 'Chartreuse verte', 1, '750 cc per bottle', 18),
(40,
'Boston Crab Meat', 8, '24 - 4 oz tins', 18.4),
(41, 'Jacks New
England Clam Chowder', 8, '12 - 12 oz cans', 9.65),
(42,
'Singaporean Hokkien Fried Mee', 5, '32 - 1 kg pkgs.', 14),
(43,
'Ipoh Coffee', 1, '16 - 500 g tins', 46),
(44, 'Gula Malacca',
2, '20 - 2 kg bags', 19.45),
(45, 'Rogede sild', 8, '1k
pkg.', 9.5),
(46, 'Spegesild', 8, '4 - 450 g glasses', 12),
(47, 'Zaanse koeken', 3, '10 - 4 oz boxes', 9.5),
(48, 'Chocolade',
3, '10 pkgs.', 12.75),
(49, 'Maxilaku', 3, '24 - 50 g pkgs.',
20),
(50, 'Valkoinen suklaa', 3, '12 - 100 g bars', 16.25),
(51, 'Manjimup Dried Apples', 7, '50 - 300 g pkgs.', 53),
(52,
'Filo Mix', 5, '16 - 2 kg boxes', 7),
(53, 'Perth Pasties',
6, '48 pieces', 32.8),
(54, 'Tourtiare', 6, '16 pies', 7.45),
(55, 'Pate chinois', 6, '24 boxes x 2 pies', 24),
(56, 'Gnocchi
di nonna Alice', 5, '24 - 250 g pkgs.', 38),
(57, 'Ravioli
Angelo', 5, '24 - 250 g pkgs.', 19.5),
(58, 'Escargots de
Bourgogne', 8, '24 pieces', 13.25),
(59, 'Raclette Courdavault',
4, '5 kg pkg.', 55),
(60, 'Camembert Pierrot', 4, '15 - 300 g
rounds', 34),
(61, 'Sirop d arable', 2, '24 - 500 ml bottles',
28.5),
(62, 'Tarte au sucre', 3, '48 pies', 49.3),
(63,
'Vegie-spread', 2, '15 - 625 g jars', 43.9),
(64, 'Wimmers gute
Semmelknadel', 5, '20 bags x 4 pieces', 33.25),
(65, 'Louisiana
Fiery Hot Pepper Sauce', 2, '32 - 8 oz bottles', 21.05),
(66,
'Louisiana Hot Spiced Okra', 2, '24 - 8 oz jars', 17),
(67,
'Laughing Lumberjack Lager', 1, '24 - 12 oz bottles', 14),
(68,
'Scottish Longbreads', 3, '10 boxes x 8 pieces', 12.5),
(69, 'Gudbrandsdalsost',
4, '10 kg pkg.', 36),
(70, 'Outback Lager', 1, '24 - 355 ml
bottles', 15),
(71, 'Flotemysost', 4, '10 - 500 g pkgs.', 21.5),
(72, 'Mozzarella di Giovanni', 4, '24 - 200 g pkgs.', 34.8),
(73,
'Red Kaviar', 8, '24 - 150 g jars', 15),
(74, 'Longlife Tofu',
7, '5 kg pkg.', 10),
(75, 'Rhenbreu Klosterbier', 1, '24 - 0.5 l
bottles', 7.75),
(76, 'Lakkalikeeri', 1, '500 ml ', 18),
(77,
'Original Frankfurter gr�ne Soae', 2, '12 boxes', 13);
Kết quả
INSERT 0 77
Kết quả cũng có thể được xem ở đây: Cơ sở dữ liệu demo - sản phẩm
ĐƠN HÀNG
Câu lệnh SQL sau đây sẽ tạo một bảng có tên là orders
:
TẠO đơn đặt hàng BẢNG
CREATE TABLE orders (
order_id SERIAL NOT NULL PRIMARY KEY,
customer_id INT,
order_date DATE
);
Kết quả
CREATE TABLE
Câu lệnh SQL sau đây sẽ điền nội dung vào bảng orders
:
CHÈN VÀO đơn hàng
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');
Kết quả
INSERT 0 830
Kết quả cũng có thể được xem ở đây: Cơ sở dữ liệu demo - đơn đặt hàng
ORDER_DETAILS
Câu lệnh SQL sau sẽ tạo một bảng có tên order_details
:
TẠO BẢNG order_details
CREATE TABLE order_details (
order_detail_id SERIAL NOT NULL
PRIMARY KEY,
order_id INT,
product_id INT,
quantity INT
);
Kết quả
CREATE TABLE
Câu lệnh SQL sau đây sẽ điền nội dung vào bảng order_details
:
CHÈN VÀO 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);
Kết quả
INSERT 0 2155
Kết quả cũng có thể được xem tại đây: Cơ sở dữ liệu demo - order_details
SẢN PHẨM THỬ NGHIỆM
Chúng tôi cũng sẽ thêm một bảng có tên là testproducts
cho mục đích trình diễn ở phần sau của hướng dẫn.
Câu lệnh SQL sau sẽ tạo một bảng có tên testproducts
:
TẠO BẢNG sản phẩm thử nghiệm
CREATE TABLE testproducts (
testproduct_id SERIAL NOT NULL
PRIMARY KEY,
product_name VARCHAR(255),
category_id
INT
);
Kết quả
CREATE TABLE
Chúng ta sẽ điền vào bảng 10 sản phẩm giả:
CHÈN VÀO sản phẩm thử nghiệm
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);
Kết quả
INSERT 0 10
Kết quả cũng có thể được xem ở đây: Cơ sở dữ liệu demo - testproducts