Sales.sql

CREATE TABLE dim_product (
    product_id INT PRIMARY KEY,
    product_name VARCHAR(100),
    category VARCHAR(50)
    -- Add any other relevant attributes here
);

CREATE TABLE dim_store (
    store_id INT PRIMARY KEY,
    store_name VARCHAR(100),
    city VARCHAR(50),
    state VARCHAR(50),
    country VARCHAR(50)
    -- Add any other relevant attributes here
);

CREATE TABLE dim_time (
    time_id INT PRIMARY KEY,
    date DATE,
    day_of_week VARCHAR(10),
    month VARCHAR(20),
    year INT
    -- Add any other relevant attributes here
);

CREATE TABLE dim_sales_name (
    sales_name_id INT PRIMARY KEY,
    sales_name VARCHAR(100),
    sales_age INT, -- Age attribute
    sales_gender VARCHAR(10) -- Gender attribute
    -- Add any other relevant attributes here
);

Create table fact_sales (
	sale_id INT,
	store_id INT,
	sales_name_id INT,
	time_id INT,
	product_id INT,
	quantity INT,
	price INT
);


-- Adding FOREIGN KEY constraints
ALTER TABLE fact_sales
    ADD CONSTRAINT fk_product_id FOREIGN KEY (product_id) REFERENCES dim_product(product_id),
    ADD CONSTRAINT fk_sales_name_id FOREIGN KEY (sales_name_id) REFERENCES dim_sales_name(sales_name_id),
    ADD CONSTRAINT fk_store_id FOREIGN KEY (store_id) REFERENCES dim_store(store_id),
    ADD CONSTRAINT fk_time_id FOREIGN KEY (time_id) REFERENCES dim_time(time_id);
   
   
   
-- Sample data for dim_product
INSERT INTO dim_product (product_id, product_name, category) VALUES
(1, 'Caffè Americano', 'Coffee'),
(2, 'Caramel Macchiato', 'Coffee'),
(3, 'Iced Green Tea Latte', 'Tea'),
(4, 'Java Chip Frappuccino', 'Coffee'),
(5, 'Croissant', 'Bakery'),
(6, 'Pumpkin Spice Latte', 'Coffee'),
(7, 'Blueberry Muffin', 'Bakery'),
(8, 'Chai Tea Latte', 'Tea'),
(9, 'Flat White', 'Coffee'),
(10, 'Mocha', 'Coffee');

-- Sample data for dim_store
INSERT INTO dim_store (store_id, store_name, city, state, country) VALUES
(1, 'Starbucks Central', 'New York', 'NY', 'USA'),
(2, 'Downtown Starbucks', 'Los Angeles', 'CA', 'USA'),
(3, 'Starbucks Corner', 'Chicago', 'IL', 'USA');


-- Sample data for dim_sales_name (additional rows)
INSERT INTO dim_sales_name (sales_name_id, sales_name, sales_age, sales_gender) values
(1, 'John Doe', 35, 'Male'),
(2, 'Jane Smith', 28, 'Female'),
(3, 'Michael Johnson', 45, 'Male'),
(4, 'Emily Brown', 32, 'Female'),
(5, 'Daniel Williams', 40, 'Male'),
(6, 'Jessica Davis', 26, 'Female'),
(7, 'David Martinez', 38, 'Male'),
(8, 'Sophia Wilson', 29, 'Female'),
(9, 'James Anderson', 41, 'Male'),
(10, 'Olivia Taylor', 34, 'Female');


-- Sample data for dim_time
-- Sample data for dim_time
INSERT INTO dim_time (time_id, date, day_of_week, month, year) VALUES
(1, '2024-01-01', 'Monday', 'January', 2024), -- New Year's Day
(2, '2024-01-02', 'Tuesday', 'January', 2024),
(3, '2024-01-03', 'Wednesday', 'January', 2024),
(4, '2024-01-04', 'Thursday', 'January', 2024),
(5, '2024-01-05', 'Friday', 'January', 2024),
(6, '2024-01-06', 'Saturday', 'January', 2024),
(7, '2024-01-07', 'Sunday', 'January', 2024),
(8, '2024-01-08', 'Monday', 'January', 2024),
(9, '2024-01-09', 'Tuesday', 'January', 2024),
(10, '2024-01-10', 'Wednesday', 'January', 2024),
(11, '2024-01-11', 'Thursday', 'January', 2024),
(12, '2024-01-12', 'Friday', 'January', 2024),
(13, '2024-01-13', 'Saturday', 'January', 2024),
(14, '2024-01-14', 'Sunday', 'January', 2024),
(15, '2024-01-15', 'Monday', 'January', 2024),
(16, '2024-01-16', 'Tuesday', 'January', 2024),
(17, '2024-01-17', 'Wednesday', 'January', 2024),
(18, '2024-01-18', 'Thursday', 'January', 2024),
(19, '2024-01-19', 'Friday', 'January', 2024),
(20, '2024-01-20', 'Saturday', 'January', 2024),
(21, '2024-01-21', 'Sunday', 'January', 2024),
(22, '2024-01-22', 'Monday', 'January', 2024),
(23, '2024-01-23', 'Tuesday', 'January', 2024),
(24, '2024-01-24', 'Wednesday', 'January', 2024),
(25, '2024-01-25', 'Thursday', 'January', 2024),
(26, '2024-01-26', 'Friday', 'January', 2024),
(27, '2024-01-27', 'Saturday', 'January', 2024),
(28, '2024-01-28', 'Sunday', 'January', 2024),
(29, '2024-01-29', 'Monday', 'January', 2024),
(30, '2024-01-30', 'Tuesday', 'January', 2024),
(31, '2024-01-31', 'Wednesday', 'January', 2024);


INSERT INTO public.fact_sales (sale_id,store_id,sales_name_id,time_id,product_id,quantity,price) VALUES
	 (13,3,2,7,10,4,6),
	 (12,2,7,31,5,3,9),
	 (1,2,4,4,3,2,6),
	 (2,3,9,22,7,2,6),
	 (3,1,9,30,9,4,5),
	 (4,1,10,18,6,5,11),
	 (5,2,2,27,6,1,12),
	 (6,2,3,22,8,1,15),
	 (7,2,1,25,8,5,11),
	 (8,1,2,27,2,5,7),
	 (9,2,7,5,10,2,5),
	 (10,1,1,19,2,3,12),
	 (11,1,10,17,10,5,6),
	 (14,3,3,26,4,5,11),
	 (15,1,10,23,1,2,11),
	 (16,1,10,15,10,3,9),
	 (17,1,3,20,10,1,7),
	 (18,1,6,2,8,1,14),
	 (19,1,4,19,7,2,6),
	 (20,3,8,11,3,5,8),
	 (21,3,5,23,6,5,15),
	 (22,2,9,29,5,4,14),
	 (23,2,4,15,7,5,9),
	 (24,2,4,9,6,2,15),
	 (25,3,4,1,6,4,13),
	 (26,2,10,2,5,2,5),
	 (27,3,7,30,7,5,5),
	 (28,2,2,4,10,4,15),
	 (29,3,6,15,10,5,10),
	 (30,3,6,13,8,3,6),
	 (31,3,5,5,9,5,12),
	 (32,1,9,5,7,2,7),
	 (33,2,1,11,9,4,12),
	 (34,3,10,9,5,3,6),
	 (35,1,9,17,4,4,6),
	 (36,3,10,29,3,2,14),
	 (37,3,2,1,4,3,12),
	 (38,3,8,19,6,1,8),
	 (39,1,9,16,5,3,6),
	 (40,1,5,21,10,3,13),
	 (41,2,4,26,9,2,10),
	 (42,1,1,28,1,3,9),
	 (43,3,3,29,2,3,6),
	 (44,2,7,29,7,5,10),
	 (45,1,9,26,7,4,14),
	 (46,2,4,2,9,5,15),
	 (47,2,5,3,2,1,12),
	 (48,2,4,24,2,1,11),
	 (49,2,5,27,6,3,13),
	 (50,2,7,7,4,1,7),
	 (51,2,4,20,2,1,5),
	 (52,1,10,1,4,1,6),
	 (53,3,2,17,5,4,10),
	 (54,2,4,27,6,1,9),
	 (55,1,9,19,4,4,15),
	 (56,3,1,24,4,5,14),
	 (57,3,3,9,10,2,12),
	 (58,3,6,31,5,1,11),
	 (59,3,9,5,4,5,11),
	 (60,1,8,7,2,2,7),
	 (61,3,6,15,3,5,11),
	 (62,3,9,10,10,3,12),
	 (63,2,4,16,3,3,5),
	 (64,1,4,21,4,2,9),
	 (65,2,10,9,3,1,15),
	 (66,1,7,14,10,1,9),
	 (67,3,3,18,7,3,6),
	 (68,3,1,22,9,3,14),
	 (69,1,7,22,3,2,6),
	 (70,2,2,1,1,1,15),
	 (71,3,10,10,10,4,9),
	 (72,1,2,29,2,4,14),
	 (73,2,5,31,9,3,7),
	 (74,2,4,3,10,4,12),
	 (75,2,2,26,10,1,12),
	 (76,2,2,10,4,2,7),
	 (77,2,3,6,7,1,10),
	 (78,2,2,13,5,1,11),
	 (79,2,6,23,6,1,14),
	 (80,3,9,24,10,1,5),
	 (81,1,3,24,5,5,10),
	 (82,3,1,1,2,4,14),
	 (83,3,6,10,6,4,6),
	 (84,3,1,16,1,2,10),
	 (85,2,3,18,4,1,10),
	 (86,1,3,17,10,1,7),
	 (87,3,2,4,3,1,12),
	 (88,1,4,19,1,5,13),
	 (89,2,9,27,2,5,15),
	 (90,3,10,16,10,1,5),
	 (91,2,10,11,5,2,9),
	 (92,1,8,9,3,5,11),
	 (93,1,3,2,7,3,10),
	 (94,3,6,4,8,2,14),
	 (95,2,4,19,7,5,11),
	 (96,2,5,31,10,4,14),
	 (97,2,8,6,4,1,12),
	 (98,3,1,7,9,1,9),
	 (99,2,5,5,7,2,13),
	 (100,2,7,11,1,5,11),
	 (101,2,8,11,5,4,9),
	 (102,1,8,20,5,3,6),
	 (103,3,6,8,5,1,9),
	 (104,2,1,2,1,1,8),
	 (105,2,1,16,3,5,11),
	 (106,2,10,30,1,5,6),
	 (107,2,3,12,5,4,5),
	 (108,3,2,21,3,4,10),
	 (109,2,6,11,9,3,12),
	 (110,3,3,4,3,1,14),
	 (111,1,8,23,3,3,7),
	 (112,3,4,24,9,4,10),
	 (113,1,3,6,10,1,6),
	 (114,3,3,22,4,3,6),
	 (115,3,2,13,1,3,8),
	 (116,2,3,26,8,5,14),
	 (117,3,1,7,7,4,7),
	 (118,3,3,9,4,4,5),
	 (119,1,7,26,8,2,12),
	 (120,3,2,5,9,1,8),
	 (121,1,9,16,2,2,5),
	 (122,2,8,16,4,1,9),
	 (123,3,3,24,9,3,7),
	 (124,2,6,19,3,4,13),
	 (125,1,6,4,10,2,5),
	 (126,1,8,29,2,1,8),
	 (127,3,3,22,3,2,9),
	 (128,3,7,25,7,5,6),
	 (129,2,2,28,4,4,15),
	 (130,2,4,15,5,4,9),
	 (131,3,2,16,7,3,10),
	 (132,2,4,17,3,2,15),
	 (133,1,7,5,8,3,15),
	 (134,1,8,11,7,4,5),
	 (135,1,8,24,3,2,6),
	 (136,1,3,23,9,4,8),
	 (137,2,4,26,6,2,8),
	 (138,3,8,13,8,3,11),
	 (139,3,1,14,1,1,13),
	 (140,2,4,26,7,5,9),
	 (141,3,1,25,5,3,8),
	 (142,2,5,28,9,4,5),
	 (143,1,1,28,1,4,12),
	 (144,3,7,26,1,3,8),
	 (145,2,1,2,7,5,9),
	 (146,2,5,23,9,5,12),
	 (147,3,10,3,5,5,8),
	 (148,2,10,15,6,4,15),
	 (149,2,5,5,4,3,7),
	 (150,1,5,20,2,3,12),
	 (151,2,10,31,5,1,11),
	 (152,3,6,24,1,2,11),
	 (153,1,1,26,7,3,8),
	 (154,3,7,6,4,3,5),
	 (155,2,10,7,10,4,7),
	 (156,1,4,5,7,1,5),
	 (157,2,1,8,8,3,10),
	 (158,3,4,16,3,5,9),
	 (159,2,6,2,2,4,5),
	 (160,1,10,23,1,3,13),
	 (161,2,1,17,1,4,15),
	 (162,3,3,3,3,4,10),
	 (163,2,8,28,10,3,15),
	 (164,2,7,29,4,4,13),
	 (165,3,2,5,5,4,8),
	 (166,1,6,6,10,2,12),
	 (167,2,4,31,9,1,13),
	 (168,3,1,10,3,2,12),
	 (169,3,5,10,5,5,8),
	 (170,1,10,15,7,2,13),
	 (171,1,5,19,8,2,8),
	 (172,2,4,13,2,2,8),
	 (173,2,4,4,7,4,6),
	 (174,1,9,30,3,1,13),
	 (175,3,4,28,9,2,10),
	 (176,1,2,31,6,1,14),
	 (177,2,4,22,4,3,6),
	 (178,1,6,5,2,5,11),
	 (179,3,7,31,9,3,9),
	 (180,2,8,22,5,1,14),
	 (181,2,2,17,7,3,14),
	 (182,1,5,7,8,1,7),
	 (183,2,1,11,5,4,13),
	 (184,1,1,14,4,2,13),
	 (185,3,10,16,7,3,14),
	 (186,2,8,29,10,1,8),
	 (187,3,1,19,2,3,8),
	 (188,1,1,3,8,5,8),
	 (189,3,6,29,7,5,11),
	 (190,1,9,2,6,1,8),
	 (191,3,2,27,7,4,10),
	 (192,1,8,17,9,3,13),
	 (193,1,2,7,6,4,15),
	 (194,3,3,9,7,2,12),
	 (195,1,5,4,3,2,7),
	 (196,3,4,19,7,3,7),
	 (197,1,7,26,3,3,8),
	 (198,1,1,9,2,2,13),
	 (199,1,4,10,4,5,5),
	 (200,1,6,15,7,4,5),
	 (201,1,4,20,6,2,9),
	 (202,3,9,15,9,4,6),
	 (203,1,5,29,10,2,11),
	 (204,1,10,3,6,1,7),
	 (205,2,7,13,1,5,13),
	 (206,3,1,21,6,5,7),
	 (207,3,2,28,8,5,9),
	 (208,1,7,12,2,5,12),
	 (209,3,8,20,4,3,9),
	 (210,2,1,29,1,1,12),
	 (211,2,3,3,4,5,8),
	 (212,1,9,11,5,4,11),
	 (213,3,9,30,3,5,8),
	 (214,3,8,10,5,4,7),
	 (215,1,9,21,6,3,10),
	 (216,3,1,27,3,1,12),
	 (217,1,5,30,2,5,14),
	 (218,1,9,1,3,2,7),
	 (219,1,9,22,8,1,9),
	 (220,1,5,8,10,4,12),
	 (221,2,1,5,5,2,12),
	 (222,1,4,30,9,1,12),
	 (223,2,4,12,6,4,11),
	 (224,3,10,8,5,1,15),
	 (225,1,2,5,6,3,8),
	 (226,2,10,11,1,5,5),
	 (227,2,6,29,6,3,13),
	 (228,1,8,23,10,5,5),
	 (229,3,5,22,6,5,15),
	 (230,3,7,22,10,3,7),
	 (231,2,1,2,9,4,13),
	 (232,1,7,3,1,5,6),
	 (233,2,3,10,7,5,11),
	 (234,1,6,19,3,4,8),
	 (235,1,8,29,3,2,9),
	 (236,1,1,10,7,5,7),
	 (237,1,2,5,10,3,7),
	 (238,2,4,10,2,4,7),
	 (239,3,9,17,9,5,5),
	 (240,1,7,21,4,5,15),
	 (241,1,2,22,5,1,7),
	 (242,3,1,20,4,2,11),
	 (243,1,5,8,4,3,11),
	 (244,2,5,17,3,5,10),
	 (245,1,9,2,9,5,14),
	 (246,3,2,30,7,5,8),
	 (247,1,10,13,5,2,6),
	 (248,1,8,17,10,3,6),
	 (249,3,8,7,5,2,13),
	 (250,2,4,13,5,1,7),
	 (251,2,1,16,3,3,14),
	 (252,2,9,2,8,2,15),
	 (253,1,10,10,1,2,6),
	 (254,3,1,7,9,5,14),
	 (255,2,10,22,9,2,10),
	 (256,2,3,5,6,1,12),
	 (257,3,1,12,8,1,5),
	 (258,3,3,29,3,4,8),
	 (259,1,5,12,3,4,9),
	 (260,1,2,29,7,1,14),
	 (261,1,9,1,4,4,13),
	 (262,1,3,7,8,3,13),
	 (263,1,6,16,7,1,13),
	 (264,2,5,5,10,1,6),
	 (265,2,3,27,3,5,13),
	 (266,3,1,10,4,2,15),
	 (267,1,6,28,4,4,5),
	 (268,2,7,26,3,4,9),
	 (269,3,9,23,2,3,7),
	 (270,2,6,4,9,4,6),
	 (271,1,8,31,3,3,15),
	 (272,1,7,31,5,3,11),
	 (273,2,8,12,8,1,10),
	 (274,2,5,13,2,3,10),
	 (275,3,10,8,9,3,6),
	 (276,1,10,8,5,3,12),
	 (277,3,6,6,6,1,11),
	 (278,2,1,6,6,3,14),
	 (279,3,8,21,2,2,14),
	 (280,2,4,8,6,4,9),
	 (281,2,2,1,4,1,13),
	 (282,2,4,25,2,1,6),
	 (283,1,2,21,2,5,14),
	 (284,2,2,26,10,4,7),
	 (285,1,1,28,5,1,11),
	 (286,1,4,16,8,2,15),
	 (287,2,9,11,7,2,8),
	 (288,2,6,6,9,5,11),
	 (289,3,2,31,9,4,9),
	 (290,2,8,6,6,2,6),
	 (291,2,1,27,3,4,14),
	 (292,3,6,13,1,1,14),
	 (293,2,1,25,5,3,6),
	 (294,1,10,5,6,3,7),
	 (295,1,6,1,6,2,11),
	 (296,2,5,8,2,1,5),
	 (297,3,1,2,6,2,15),
	 (298,1,6,25,8,4,8),
	 (299,3,6,31,2,5,12),
	 (300,2,5,2,2,1,8),
	 (301,1,7,30,8,5,5),
	 (302,2,5,3,5,2,10),
	 (303,3,6,14,2,1,7),
	 (304,1,10,23,10,5,8),
	 (305,1,2,16,5,5,13),
	 (306,3,3,7,4,5,13),
	 (307,1,6,31,7,2,5),
	 (308,1,8,13,7,1,6),
	 (309,1,8,23,3,5,14),
	 (310,3,4,14,5,5,14),
	 (311,3,8,8,9,2,9),
	 (312,1,6,30,9,2,13),
	 (313,3,9,30,4,5,10),
	 (314,2,6,2,4,4,14),
	 (315,1,2,22,2,1,13),
	 (316,1,2,16,1,3,12),
	 (317,3,1,20,6,5,13),
	 (318,1,1,9,7,3,12),
	 (319,1,2,19,7,2,8),
	 (320,3,9,10,6,2,9),
	 (321,1,9,5,10,5,14),
	 (322,2,5,10,1,2,13),
	 (323,1,2,9,4,5,8),
	 (324,2,8,4,3,2,13),
	 (325,3,2,3,2,5,10),
	 (326,1,9,23,9,1,11),
	 (327,1,1,20,9,4,7),
	 (328,1,4,8,7,4,14),
	 (329,1,2,4,7,2,11),
	 (330,3,6,2,8,4,8),
	 (331,3,9,7,10,1,5),
	 (332,2,10,23,1,5,13),
	 (333,2,2,21,5,5,15),
	 (334,2,5,18,3,2,10),
	 (335,2,7,16,4,4,7),
	 (336,1,4,22,8,2,15),
	 (337,2,1,18,7,4,9),
	 (338,1,4,13,10,3,11),
	 (339,1,1,27,10,4,11),
	 (340,2,6,6,7,4,14),
	 (341,3,5,7,6,4,13),
	 (342,1,6,8,5,3,7),
	 (343,1,10,28,1,2,9),
	 (344,1,1,16,9,2,9),
	 (345,3,4,8,9,4,11),
	 (346,2,6,6,7,5,5),
	 (347,3,3,5,2,3,8),
	 (348,1,7,13,7,1,8),
	 (349,3,5,19,10,4,5),
	 (350,3,9,10,6,2,7),
	 (351,3,1,26,7,5,12),
	 (352,3,1,17,6,2,9),
	 (353,2,9,21,8,3,6),
	 (354,3,7,4,7,3,14),
	 (355,3,8,17,9,5,9),
	 (356,3,5,31,3,4,13),
	 (357,1,6,2,4,3,15),
	 (358,1,2,19,1,2,5),
	 (359,1,4,8,2,1,15),
	 (360,3,8,17,4,5,8),
	 (361,3,1,23,6,5,12),
	 (362,2,5,19,6,3,6),
	 (363,1,1,29,9,4,13),
	 (364,2,7,21,9,4,9),
	 (365,2,4,7,6,2,9),
	 (366,3,1,31,8,1,7),
	 (367,2,10,18,9,1,11),
	 (368,3,2,23,7,4,9),
	 (369,2,1,26,6,1,11),
	 (370,2,7,31,9,3,10),
	 (371,1,8,31,4,3,14),
	 (372,3,6,8,2,5,15),
	 (373,2,4,4,2,3,11),
	 (374,2,6,4,5,2,7),
	 (375,2,7,20,8,4,11),
	 (376,1,1,12,8,4,7),
	 (377,2,5,4,10,5,8),
	 (378,3,2,19,10,1,9),
	 (379,2,5,29,2,1,15),
	 (380,1,1,12,1,3,11),
	 (381,2,9,12,8,3,12),
	 (382,2,5,7,2,2,6),
	 (383,1,2,12,5,4,15),
	 (384,1,4,2,3,4,11),
	 (385,3,9,12,2,5,6),
	 (386,2,8,2,5,2,8),
	 (387,3,8,27,9,5,5),
	 (388,3,9,7,1,4,6),
	 (389,2,10,1,5,2,11),
	 (390,3,2,29,5,4,14),
	 (391,1,5,20,3,2,11),
	 (392,2,8,8,10,5,14),
	 (393,3,10,13,2,2,6),
	 (394,2,8,20,1,5,11),
	 (395,1,5,17,5,2,7),
	 (396,3,7,15,4,3,8),
	 (397,1,8,31,10,3,10),
	 (398,1,8,6,2,3,10),
	 (399,2,7,21,2,4,13),
	 (400,1,6,10,9,1,6),
	 (401,1,8,5,1,3,9),
	 (402,2,9,12,4,1,8),
	 (403,1,7,20,5,2,6),
	 (404,1,2,4,10,1,14),
	 (405,1,9,5,2,3,14),
	 (406,3,1,8,8,4,7),
	 (407,3,5,19,5,5,10),
	 (408,3,9,19,1,1,9),
	 (409,2,10,24,3,2,9),
	 (410,2,9,1,7,2,5),
	 (411,2,2,20,8,2,15),
	 (412,2,8,10,8,5,5),
	 (413,3,10,10,7,1,10),
	 (414,2,2,17,8,5,10),
	 (415,2,3,31,8,2,6),
	 (416,3,2,16,2,3,12),
	 (417,3,6,23,10,2,15),
	 (418,1,5,18,2,2,6),
	 (419,3,3,10,3,3,14),
	 (420,3,7,10,1,5,10),
	 (421,2,1,16,9,4,7),
	 (422,3,6,13,2,1,14),
	 (423,2,1,30,4,2,10),
	 (424,3,6,20,5,1,12),
	 (425,2,8,25,9,2,9),
	 (426,3,2,24,9,1,8),
	 (427,1,9,25,9,1,9),
	 (428,3,3,1,5,4,13),
	 (429,1,6,20,4,3,7),
	 (430,3,3,25,3,1,13),
	 (431,3,5,27,9,2,10),
	 (432,3,8,18,2,3,9),
	 (433,1,4,25,3,1,14),
	 (434,2,7,8,8,1,6),
	 (435,3,6,20,8,5,6),
	 (436,1,5,8,3,1,9),
	 (437,1,10,26,7,2,12),
	 (438,3,3,3,2,5,7),
	 (439,1,3,20,7,5,5),
	 (440,2,5,29,3,2,8),
	 (441,2,9,31,3,3,6),
	 (442,2,2,24,10,2,8),
	 (443,3,1,5,4,1,13),
	 (444,1,8,12,7,1,11),
	 (445,3,4,31,1,1,13),
	 (446,2,1,25,8,1,5),
	 (447,1,1,18,7,1,6),
	 (448,3,2,15,8,1,7),
	 (449,3,3,18,7,4,11),
	 (450,1,6,7,9,1,6),
	 (451,3,4,8,10,5,6),
	 (452,3,4,2,8,5,7),
	 (453,1,6,14,10,4,11),
	 (454,1,7,28,4,5,7),
	 (455,3,7,20,6,3,7),
	 (456,1,2,23,7,5,5),
	 (457,1,7,26,9,5,13),
	 (458,1,8,23,9,3,8),
	 (459,3,5,18,5,1,15),
	 (460,2,3,29,10,1,9),
	 (461,2,3,3,6,5,12),
	 (462,3,9,22,4,5,6),
	 (463,3,7,31,1,5,14),
	 (464,2,9,8,5,4,15),
	 (465,3,1,19,8,5,5),
	 (466,2,9,15,9,4,15),
	 (467,3,8,18,8,2,6),
	 (468,1,6,19,8,1,7),
	 (469,2,7,19,9,1,7),
	 (470,3,9,12,3,1,10),
	 (471,1,6,1,6,5,12),
	 (472,1,8,9,3,2,12),
	 (473,3,9,2,5,1,14),
	 (474,2,9,9,2,5,10),
	 (475,2,7,14,4,5,11),
	 (476,1,8,1,2,4,15),
	 (477,2,1,2,8,3,15),
	 (478,3,8,10,5,1,8),
	 (479,2,7,24,2,5,5),
	 (480,3,5,22,4,4,11),
	 (481,3,1,27,5,1,11),
	 (482,2,3,30,2,1,8),
	 (483,1,10,27,6,3,14),
	 (484,1,3,18,1,1,15),
	 (485,3,3,26,7,3,14),
	 (486,3,7,31,6,3,12),
	 (487,3,3,13,7,5,13),
	 (488,2,5,11,2,5,6),
	 (489,1,4,12,10,4,8),
	 (490,3,7,14,8,2,12),
	 (491,1,10,1,3,4,9),
	 (492,3,1,27,5,3,8),
	 (493,3,10,24,1,5,9),
	 (494,1,9,15,5,2,11),
	 (495,1,7,27,6,3,15),
	 (496,3,8,23,3,3,11),
	 (497,2,5,9,4,3,14),
	 (498,1,2,9,7,3,13),
	 (499,2,9,10,8,3,12),
	 (500,1,6,28,3,2,10),
	 (501,1,1,18,10,5,7),
	 (502,3,9,1,10,3,5),
	 (503,3,2,10,8,3,10),
	 (504,2,1,1,3,2,6),
	 (505,2,5,24,10,5,8),
	 (506,2,9,12,7,3,7),
	 (507,1,5,26,3,4,10),
	 (508,2,4,27,5,4,12),
	 (509,3,7,2,5,5,12),
	 (510,2,9,31,1,3,12),
	 (511,3,7,8,6,3,8),
	 (512,2,4,23,3,3,5),
	 (513,3,10,30,2,2,7),
	 (514,1,6,24,3,3,9),
	 (515,2,10,13,10,1,8),
	 (516,1,2,20,8,1,10),
	 (517,2,4,23,4,2,7),
	 (518,2,7,18,2,5,8),
	 (519,1,10,22,6,2,15),
	 (520,2,2,20,5,1,13),
	 (521,1,9,13,6,2,7),
	 (522,3,7,3,2,1,9),
	 (523,2,6,31,4,4,8),
	 (524,2,9,2,9,4,9),
	 (525,1,8,24,4,3,12),
	 (526,2,7,25,2,3,15),
	 (527,3,1,30,4,3,13),
	 (528,1,7,7,9,3,5),
	 (529,3,3,8,3,2,15),
	 (530,3,5,29,3,3,15),
	 (531,1,9,7,5,3,15),
	 (532,2,6,23,7,4,6),
	 (533,1,4,29,2,3,7),
	 (534,3,2,14,7,2,11),
	 (535,1,9,30,8,2,15),
	 (536,1,2,12,10,1,7),
	 (537,3,6,15,1,2,15),
	 (538,2,3,27,2,4,11),
	 (539,1,4,6,3,4,10),
	 (540,3,10,24,5,2,6),
	 (541,1,1,21,2,4,12),
	 (542,1,4,6,1,5,10),
	 (543,1,6,8,3,1,15),
	 (544,1,4,26,6,1,13),
	 (545,3,6,1,5,2,7),
	 (546,2,3,19,10,2,9),
	 (547,1,3,18,5,4,6),
	 (548,3,3,22,7,1,8),
	 (549,1,3,21,6,2,8),
	 (550,3,1,8,2,5,7),
	 (551,1,8,13,2,4,8),
	 (552,3,3,9,10,4,15),
	 (553,1,5,4,4,4,5),
	 (554,2,6,6,1,5,15),
	 (555,2,10,17,3,1,10),
	 (556,1,9,27,2,2,8),
	 (557,3,4,27,8,1,11),
	 (558,3,5,13,7,3,7),
	 (559,3,6,10,10,3,6),
	 (560,1,9,29,1,5,6),
	 (561,1,8,22,3,1,11),
	 (562,1,1,21,6,5,11),
	 (563,2,7,1,1,2,5),
	 (564,2,5,19,9,1,7),
	 (565,2,8,23,9,5,7),
	 (566,2,3,14,2,2,8),
	 (567,2,6,18,1,2,9),
	 (568,2,5,6,8,2,5),
	 (569,2,4,2,5,5,15),
	 (570,1,1,11,8,1,15),
	 (571,2,10,22,4,4,10),
	 (572,3,10,30,5,3,13),
	 (573,2,9,13,4,5,10),
	 (574,2,1,27,8,4,6),
	 (575,2,8,30,8,1,15),
	 (576,3,2,31,10,1,15),
	 (577,3,10,25,5,4,6),
	 (578,2,4,31,1,2,7),
	 (579,1,1,26,2,2,8),
	 (580,3,2,18,2,2,9),
	 (581,1,9,1,4,1,11),
	 (582,2,10,20,6,4,15),
	 (583,1,2,26,7,2,12),
	 (584,2,10,16,8,1,13),
	 (585,2,8,21,7,5,14),
	 (586,3,6,27,5,5,9),
	 (587,2,3,12,2,3,11),
	 (588,2,5,13,10,1,14),
	 (589,1,9,20,1,4,11),
	 (590,2,4,3,4,2,6),
	 (591,3,2,18,3,3,9),
	 (592,3,6,4,10,5,8),
	 (593,2,2,4,10,3,15),
	 (594,1,4,13,8,4,9),
	 (595,1,2,5,6,4,7),
	 (596,3,9,31,5,2,9),
	 (597,1,7,10,8,1,5),
	 (598,1,6,23,1,3,10),
	 (599,2,6,8,3,4,5),
	 (600,1,3,28,9,2,6),
	 (601,2,3,10,7,1,13),
	 (602,1,7,22,7,1,6),
	 (603,3,5,18,10,4,13),
	 (604,1,6,1,6,2,12),
	 (605,1,10,23,8,4,10),
	 (606,2,10,17,1,3,11),
	 (607,2,9,11,3,4,6),
	 (608,2,9,29,10,4,12),
	 (609,2,8,1,7,3,15),
	 (610,3,5,2,3,1,5),
	 (611,2,5,23,4,1,5),
	 (612,2,5,28,6,2,5),
	 (613,1,3,1,7,2,8),
	 (614,1,4,22,6,2,11),
	 (615,3,4,20,1,3,11),
	 (616,1,9,7,2,3,7),
	 (617,1,10,3,2,1,11),
	 (618,3,4,29,3,5,14),
	 (619,1,1,16,4,1,12),
	 (620,3,1,9,6,5,11),
	 (621,3,1,4,3,4,11),
	 (622,2,9,9,7,2,13),
	 (623,3,2,21,3,5,10),
	 (624,1,5,29,8,4,10),
	 (625,3,9,5,10,5,14),
	 (626,1,4,19,10,1,6),
	 (627,2,3,6,2,3,6),
	 (628,2,5,4,9,4,13),
	 (629,3,2,11,3,5,12),
	 (630,1,6,29,2,3,14),
	 (631,3,3,12,6,1,13),
	 (632,2,8,27,1,3,11),
	 (633,3,9,3,9,5,8),
	 (634,1,9,21,8,3,5),
	 (635,1,6,18,8,4,12),
	 (636,1,9,6,2,3,15),
	 (637,3,8,30,8,5,5),
	 (638,3,7,20,7,2,11),
	 (639,1,4,17,4,2,9),
	 (640,2,7,10,8,4,5),
	 (641,1,2,26,4,2,12),
	 (642,3,4,5,10,3,7),
	 (643,3,7,27,1,3,7),
	 (644,1,8,10,7,5,15),
	 (645,3,3,11,2,3,5),
	 (646,1,6,29,3,5,8),
	 (647,3,5,24,6,3,6),
	 (648,2,6,21,4,2,12),
	 (649,2,9,16,7,4,11),
	 (650,3,10,3,2,4,9),
	 (651,3,1,13,7,1,14),
	 (652,2,2,23,8,3,14),
	 (653,2,6,10,6,1,14),
	 (654,1,1,24,3,4,14),
	 (655,3,10,20,10,1,14),
	 (656,1,10,4,7,2,10),
	 (657,1,6,20,5,5,9),
	 (658,2,2,8,1,1,11),
	 (659,2,2,16,5,4,13),
	 (660,3,10,26,3,5,14),
	 (661,1,5,28,8,1,9),
	 (662,1,9,30,3,4,6),
	 (663,2,2,12,8,5,15),
	 (664,1,3,13,6,2,10),
	 (665,1,5,19,5,1,6),
	 (666,3,2,2,7,5,10),
	 (667,2,6,8,4,3,6),
	 (668,1,5,29,5,5,8),
	 (669,3,9,5,5,4,10),
	 (670,2,7,20,9,4,13),
	 (671,2,10,29,8,1,11),
	 (672,3,8,25,10,2,9),
	 (673,3,1,11,1,5,7),
	 (674,2,5,11,6,4,7),
	 (675,1,6,15,5,1,12),
	 (676,2,3,7,7,3,14),
	 (677,1,2,18,4,4,5),
	 (678,3,5,7,5,5,15),
	 (679,2,5,2,9,1,7),
	 (680,1,4,8,9,5,13),
	 (681,1,7,13,9,5,15),
	 (682,2,3,16,4,2,10),
	 (683,3,1,23,10,1,13),
	 (684,3,3,19,1,4,14),
	 (685,3,6,21,6,2,7),
	 (686,2,3,16,5,5,10),
	 (687,3,3,6,7,4,8),
	 (688,2,3,2,2,5,9),
	 (689,2,1,9,1,5,6),
	 (690,2,7,20,4,2,13),
	 (691,2,4,5,8,5,12),
	 (692,3,9,25,1,1,11),
	 (693,1,10,9,9,1,8),
	 (694,1,8,23,4,3,10),
	 (695,1,7,12,6,4,14),
	 (696,3,7,18,1,4,8),
	 (697,2,8,8,8,3,5),
	 (698,3,7,8,6,1,7),
	 (699,1,1,31,6,1,6),
	 (700,3,1,10,4,2,10),
	 (701,1,4,31,3,5,12),
	 (702,3,5,8,9,5,6),
	 (703,3,3,5,1,4,7),
	 (704,2,1,6,3,4,13),
	 (705,1,4,23,7,2,5),
	 (706,2,6,25,4,3,12),
	 (707,2,9,1,5,5,10),
	 (708,3,5,13,10,1,6),
	 (709,1,6,24,6,2,10),
	 (710,3,10,10,8,3,10),
	 (711,3,2,12,4,2,11),
	 (712,2,9,25,5,5,5),
	 (713,3,8,26,6,2,7),
	 (714,1,1,16,3,2,8),
	 (715,1,8,10,1,2,11),
	 (716,1,5,22,5,1,11),
	 (717,2,3,21,8,4,13),
	 (718,1,2,10,9,2,12),
	 (719,3,7,29,10,3,9),
	 (720,2,2,4,9,1,5),
	 (721,3,7,25,5,3,6),
	 (722,2,6,30,3,4,8),
	 (723,1,10,15,8,1,6),
	 (724,2,2,29,9,2,13),
	 (725,3,1,28,9,5,7),
	 (726,3,4,2,9,2,6),
	 (727,1,1,22,8,4,15),
	 (728,1,9,23,4,5,8),
	 (729,2,9,2,1,3,11),
	 (730,3,10,8,7,3,9),
	 (731,3,8,4,10,5,9),
	 (732,3,8,15,3,2,13),
	 (733,3,5,29,2,3,12),
	 (734,2,7,3,9,4,10),
	 (735,2,6,15,9,2,14),
	 (736,3,4,21,1,5,13),
	 (737,1,3,17,10,2,5),
	 (738,1,9,3,4,1,15),
	 (739,3,10,11,2,5,11),
	 (740,3,9,13,5,1,6),
	 (741,3,1,27,7,2,7),
	 (742,3,3,22,3,2,12),
	 (743,3,1,7,9,1,12),
	 (744,1,10,5,5,2,15),
	 (745,1,5,26,1,5,11),
	 (746,3,3,28,5,2,14),
	 (747,3,6,9,6,3,6),
	 (748,1,8,8,7,3,12),
	 (749,1,5,14,6,2,8),
	 (750,2,2,4,10,2,6),
	 (751,2,4,29,10,1,12),
	 (752,1,10,10,7,1,7),
	 (753,2,1,3,3,4,15),
	 (754,2,10,20,7,2,14),
	 (755,3,3,11,9,2,6),
	 (756,2,8,5,7,5,10),
	 (757,3,9,26,5,2,10),
	 (758,3,8,31,8,2,7),
	 (759,3,2,15,9,3,15),
	 (760,1,7,21,6,1,5),
	 (761,2,4,17,5,2,8),
	 (762,1,3,7,2,1,12),
	 (763,3,5,2,9,1,12),
	 (764,3,1,15,5,5,10),
	 (765,3,9,28,8,1,13),
	 (766,2,3,14,2,3,11),
	 (767,2,7,30,9,3,13),
	 (768,3,7,31,2,2,8),
	 (769,3,8,16,9,5,5),
	 (770,3,10,10,3,2,15),
	 (771,2,10,3,9,2,14),
	 (772,2,3,4,7,3,13),
	 (773,3,1,10,1,3,11),
	 (774,3,2,3,7,1,5),
	 (775,2,4,4,7,2,11),
	 (776,1,4,9,6,5,6),
	 (777,2,2,21,7,4,5),
	 (778,3,6,13,6,4,5),
	 (779,3,2,30,2,2,10),
	 (780,1,8,2,7,3,9),
	 (781,1,9,20,5,2,10),
	 (782,2,2,23,5,4,7),
	 (783,3,9,24,5,1,9),
	 (784,1,7,7,6,3,8),
	 (785,3,10,5,3,3,15),
	 (786,2,9,13,2,3,13),
	 (787,3,8,2,4,5,15),
	 (788,1,3,10,8,2,15),
	 (789,2,5,17,3,4,8),
	 (790,2,3,1,3,5,7),
	 (791,3,10,19,5,5,8),
	 (792,1,9,12,10,2,13),
	 (793,3,5,24,1,1,14),
	 (794,2,7,8,2,3,13),
	 (795,1,6,7,10,3,8),
	 (796,3,10,7,6,2,14),
	 (797,1,8,6,10,5,8),
	 (798,1,5,4,2,3,15),
	 (799,1,10,4,6,5,9),
	 (800,1,1,21,3,3,10),
	 (801,1,6,14,2,1,12),
	 (802,3,2,27,9,5,5),
	 (803,1,6,28,2,5,13),
	 (804,3,3,17,4,2,13),
	 (805,2,9,1,4,1,14),
	 (806,2,3,10,4,2,6),
	 (807,2,9,17,1,4,7),
	 (808,1,9,10,10,5,13),
	 (809,2,9,25,6,3,12),
	 (810,2,1,26,6,5,11),
	 (811,1,3,13,9,5,14),
	 (812,1,2,5,8,5,13),
	 (813,2,3,18,10,4,10),
	 (814,3,9,20,4,3,10),
	 (815,2,2,21,7,3,7),
	 (816,2,1,18,3,2,5),
	 (817,1,3,18,8,4,7),
	 (818,2,1,18,8,3,9),
	 (819,3,1,16,2,1,14),
	 (820,2,8,22,2,4,15),
	 (821,3,1,8,7,2,15),
	 (822,2,4,20,9,2,13),
	 (823,2,2,7,2,2,13),
	 (824,3,2,25,10,2,11),
	 (825,3,2,9,1,4,8),
	 (826,2,10,17,9,1,8),
	 (827,1,5,11,8,2,10),
	 (828,2,7,2,6,2,5),
	 (829,2,10,12,10,4,6),
	 (830,1,10,25,6,5,9),
	 (831,2,2,14,9,4,13),
	 (832,1,7,10,3,2,15),
	 (833,2,1,15,3,5,12),
	 (834,3,8,2,6,2,7),
	 (835,1,6,30,3,5,10),
	 (836,1,7,10,2,5,8),
	 (837,1,7,29,4,1,7),
	 (838,2,4,4,4,4,6),
	 (839,3,1,9,6,3,10),
	 (840,2,9,7,1,3,6),
	 (841,1,2,9,7,2,12),
	 (842,3,1,18,6,5,6),
	 (843,2,5,18,7,4,12),
	 (844,1,7,8,10,3,12),
	 (845,3,7,30,3,4,9),
	 (846,2,9,12,1,5,11),
	 (847,2,6,1,9,5,10),
	 (848,3,7,22,8,4,13),
	 (849,3,7,16,6,5,13),
	 (850,2,8,26,1,1,11),
	 (851,3,3,12,6,5,5),
	 (852,2,8,31,7,3,14),
	 (853,3,5,14,6,2,5),
	 (854,2,4,3,5,2,5),
	 (855,2,9,24,5,2,12),
	 (856,2,4,3,8,1,13),
	 (857,2,5,6,1,4,6),
	 (858,1,2,16,7,1,8),
	 (859,3,8,23,4,3,9),
	 (860,1,6,10,4,4,5),
	 (861,1,2,13,6,5,8),
	 (862,2,4,1,9,2,11),
	 (863,3,9,5,8,4,10),
	 (864,3,3,9,1,4,10),
	 (865,1,5,26,5,1,13),
	 (866,3,8,20,5,3,8),
	 (867,3,6,11,4,2,9),
	 (868,2,5,31,6,5,9),
	 (869,3,4,26,6,1,5),
	 (870,2,6,20,8,4,10),
	 (871,3,2,8,6,4,9),
	 (872,1,9,18,6,5,10),
	 (873,1,2,19,5,2,14),
	 (874,1,5,7,2,1,5),
	 (875,1,10,3,5,1,14),
	 (876,1,9,15,5,2,8),
	 (877,1,5,16,3,3,6),
	 (878,3,5,10,9,3,7),
	 (879,2,6,10,8,5,5),
	 (880,3,2,12,7,3,10),
	 (881,2,1,12,1,5,8),
	 (882,1,10,12,4,4,13),
	 (883,2,4,18,4,3,11),
	 (884,2,9,23,1,1,11),
	 (885,1,9,27,6,4,5),
	 (886,2,5,24,7,4,13),
	 (887,2,2,3,1,5,14),
	 (888,3,2,11,10,4,9),
	 (889,2,2,9,5,3,8),
	 (890,3,8,30,2,2,12),
	 (891,2,5,14,2,1,7),
	 (892,3,1,7,6,4,12),
	 (893,3,4,19,4,2,14),
	 (894,3,1,11,5,2,11),
	 (895,1,10,19,1,3,15),
	 (896,2,7,22,1,5,10),
	 (897,3,4,24,6,4,9),
	 (898,3,3,23,4,5,13),
	 (899,1,10,1,9,2,14),
	 (900,2,8,29,8,4,6),
	 (901,1,4,4,6,3,6),
	 (902,1,7,29,2,5,6),
	 (903,1,8,5,10,5,9),
	 (904,3,9,19,4,2,5),
	 (905,3,1,12,6,4,6),
	 (906,3,7,19,9,5,9),
	 (907,1,5,12,9,4,14),
	 (908,1,10,18,9,5,13),
	 (909,1,10,24,1,1,10),
	 (910,2,4,9,1,4,6),
	 (911,3,1,27,3,5,5),
	 (912,3,2,24,9,5,15),
	 (913,3,9,12,9,3,12),
	 (914,2,8,17,8,3,8),
	 (915,1,2,31,4,5,9),
	 (916,1,6,24,8,4,5),
	 (917,3,3,3,7,5,8),
	 (918,3,5,30,2,3,7),
	 (919,1,9,16,2,1,10),
	 (920,3,1,20,2,3,9),
	 (921,3,4,29,4,3,5),
	 (922,3,1,17,9,1,10),
	 (923,3,1,16,1,3,15),
	 (924,3,6,25,4,2,9),
	 (925,3,1,14,8,1,7),
	 (926,1,4,8,5,2,5),
	 (927,3,7,21,6,4,15),
	 (928,1,1,26,5,4,11),
	 (929,3,10,24,4,3,12),
	 (930,3,6,22,10,3,8),
	 (931,3,4,6,3,5,6),
	 (932,3,2,17,8,4,11),
	 (933,1,5,25,9,2,8),
	 (934,2,6,21,8,1,12),
	 (935,1,6,15,7,5,8),
	 (936,1,8,18,5,2,11),
	 (937,2,5,13,10,5,5),
	 (938,3,6,11,10,3,10),
	 (939,2,1,30,1,1,14),
	 (940,3,8,27,1,5,6),
	 (941,3,5,1,10,5,11),
	 (942,3,4,22,3,3,13),
	 (943,2,4,15,7,2,6),
	 (944,2,5,30,9,3,7),
	 (945,3,4,2,5,4,5),
	 (946,2,3,3,6,3,10),
	 (947,2,9,10,9,1,15),
	 (948,3,4,27,2,1,11),
	 (949,2,4,17,9,4,14),
	 (950,3,3,2,1,3,10),
	 (951,1,5,28,1,5,7),
	 (952,3,2,5,9,4,13),
	 (953,2,9,5,4,2,9),
	 (954,1,10,2,2,3,6),
	 (955,1,8,15,4,4,10),
	 (956,3,8,17,1,5,12),
	 (957,3,8,28,3,3,11),
	 (958,3,7,11,4,2,6),
	 (959,2,10,3,4,1,10),
	 (960,3,3,4,1,5,15),
	 (961,3,2,20,5,4,11),
	 (962,1,1,25,10,2,11),
	 (963,2,6,17,6,1,10),
	 (964,3,6,23,1,2,9),
	 (965,1,1,23,5,1,15),
	 (966,3,2,17,9,2,8),
	 (967,2,3,28,3,1,9),
	 (968,2,6,11,5,1,13),
	 (969,1,1,9,3,4,8),
	 (970,1,3,16,1,1,13),
	 (971,2,9,14,4,3,9),
	 (972,3,9,27,3,5,10),
	 (973,3,4,29,5,1,11),
	 (974,1,9,31,3,4,12),
	 (975,3,10,12,5,3,5),
	 (976,3,4,22,5,5,13),
	 (977,2,1,20,3,4,8),
	 (978,3,2,20,8,4,14),
	 (979,2,4,6,1,5,13),
	 (980,2,8,5,7,1,12),
	 (981,3,3,15,10,2,13),
	 (982,1,4,9,9,1,9),
	 (983,1,4,19,6,5,7),
	 (984,3,4,17,4,2,11),
	 (985,2,3,4,10,3,13),
	 (986,3,8,4,7,3,7),
	 (987,1,4,21,3,1,11),
	 (988,1,5,21,8,5,15),
	 (989,2,5,6,9,2,9),
	 (990,1,6,8,6,4,11),
	 (991,3,1,26,2,3,7),
	 (992,1,4,5,5,2,12),
	 (993,3,5,3,3,2,6),
	 (994,1,1,15,1,3,10),
	 (995,3,3,29,1,3,11),
	 (996,1,6,7,2,4,8),
	 (997,3,1,17,1,1,12),
	 (998,3,9,11,5,4,12),
	 (999,1,7,30,6,2,9),
	 (1000,1,5,16,3,5,8);