日付同士の差を求める 1 MySQL編（paizaランク C 相当）
問題にチャレンジして、ユーザー同士で解答を教え合ったり、コードを公開してみよう！
ポスト
下記の問題をプログラミングしてみよう！
TIMESTAMPDIFF関数の中を埋めて、2000年1月1日と2025年1月1日の日数の差を表示してください。
ヒント
・
TIMESTAMPDIFF(単位, '日付1', '日付2'):日付1から日付2までの経過時間を単位の単位で計算する・経過時間を日数で求めたい場合は、単位に
DAY を指定する
- 入力例1
-
CREATE TABLE ordered(
ordered_id INTEGER PRIMARY KEY,
datetime DATETIME NOT NULL,
bill INTEGER NOT NULL
);
INSERT INTO ordered VALUES (1, '2021-12-17 9:31', 200), (2, '2021-12-17 9:46', 250), (3, '2021-12-17 10:9', 1050), (4, '2021-12-17 10:19', 1510), (5, '2021-12-17 10:20', 500), (6, '2021-12-17 10:26', 600), (7, '2021-12-17 10:35', 350), (8, '2021-12-17 10:35', 1050), (9, '2021-12-17 10:40', 700), (10, '2021-12-17 10:46', 1100), (11, '2021-12-17 10:48', 300), (12, '2021-12-17 10:55', 800), (13, '2021-12-17 10:56', 250), (14, '2021-12-17 10:59', 1150), (15, '2021-12-17 10:59', 1410), (16, '2021-12-17 11:1', 1250), (17, '2021-12-17 11:3', 500), (18, '2021-12-17 11:3', 500), (19, '2021-12-17 11:10', 1600), (20, '2021-12-17 11:11', 800), (21, '2021-12-17 11:17', 500), (22, '2021-12-17 11:19', 1500), (23, '2021-12-17 11:21', 1400), (24, '2021-12-17 11:21', 1550), (25, '2021-12-17 11:22', 550), (26, '2021-12-17 11:29', 950), (27, '2021-12-17 11:30', 1500), (28, '2021-12-17 11:31', 900), (29, '2021-12-17 11:35', 550), (30, '2021-12-17 11:37', 780), (31, '2021-12-17 11:38', 450), (32, '2021-12-17 11:39', 1160), (33, '2021-12-17 11:45', 800), (34, '2021-12-17 11:46', 450), (35, '2021-12-17 11:50', 1130), (36, '2021-12-17 11:50', 960), (37, '2021-12-17 11:51', 900), (38, '2021-12-17 11:53', 600), (39, '2021-12-17 11:53', 1700), (40, '2021-12-17 11:54', 600), (41, '2021-12-17 11:58', 660), (42, '2021-12-17 11:59', 500), (43, '2021-12-17 12:1', 500), (44, '2021-12-17 12:4', 1450), (45, '2021-12-17 12:5', 750), (46, '2021-12-17 12:6', 750), (47, '2021-12-17 12:9', 1000), (48, '2021-12-17 12:9', 150), (49, '2021-12-17 12:9', 800), (50, '2021-12-17 12:10', 1450), (51, '2021-12-17 12:13', 1000), (52, '2021-12-17 12:13', 1450), (53, '2021-12-17 12:17', 1450), (54, '2021-12-17 12:17', 1750), (55, '2021-12-17 12:22', 600), (56, '2021-12-17 12:22', 1300), (57, '2021-12-17 12:23', 1000), (58, '2021-12-17 12:26', 600), (59, '2021-12-17 12:31', 800), (60, '2021-12-17 12:31', 330), (61, '2021-12-17 12:32', 850), (62, '2021-12-17 12:32', 1000), (63, '2021-12-17 12:33', 300), (64, '2021-12-17 12:40', 1360), (65, '2021-12-17 12:41', 1100), (66, '2021-12-17 12:41', 800), (67, '2021-12-17 12:42', 1300), (68, '2021-12-17 12:43', 500), (69, '2021-12-17 12:43', 700), (70, '2021-12-17 12:46', 650), (71, '2021-12-17 12:47', 1080), (72, '2021-12-17 12:51', 1150), (73, '2021-12-17 12:54', 950), (74, '2021-12-17 12:55', 1100), (75, '2021-12-17 12:57', 400), (76, '2021-12-17 13:0', 1100), (77, '2021-12-17 13:2', 1310), (78, '2021-12-17 13:2', 600), (79, '2021-12-17 13:3', 1250), (80, '2021-12-17 13:3', 200), (81, '2021-12-17 13:4', 400), (82, '2021-12-17 13:12', 1030), (83, '2021-12-17 13:12', 700), (84, '2021-12-17 13:13', 800), (85, '2021-12-17 13:23', 1050), (86, '2021-12-17 13:26', 950), (87, '2021-12-17 13:28', 1250), (88, '2021-12-17 13:29', 930), (89, '2021-12-17 13:30', 950), (90, '2021-12-17 13:37', 1150), (91, '2021-12-17 13:37', 1310), (92, '2021-12-17 13:41', 500), (93, '2021-12-17 13:44', 250), (94, '2021-12-17 13:50', 1350), (95, '2021-12-17 13:53', 400), (96, '2021-12-17 13:53', 1430), (97, '2021-12-17 13:55', 450), (98, '2021-12-17 13:56', 1150), (99, '2021-12-17 14:0', 1310), (100, '2021-12-17 14:8', 1150), (101, '2021-12-17 14:11', 250), (102, '2021-12-17 14:13', 1050), (103, '2021-12-17 14:14', 1300), (104, '2021-12-17 14:15', 1160), (105, '2021-12-17 14:17', 250), (106, '2021-12-17 14:18', 650), (107, '2021-12-17 14:20', 1000), (108, '2021-12-17 14:21', 1250), (109, '2021-12-17 14:22', 950), (110, '2021-12-17 14:24', 1100), (111, '2021-12-17 14:24', 500), (112, '2021-12-17 14:27', 1360), (113, '2021-12-17 14:30', 630), (114, '2021-12-17 14:30', 1350), (115, '2021-12-17 14:30', 1100), (116, '2021-12-17 14:31', 1180), (117, '2021-12-17 14:33', 500), (118, '2021-12-17 14:34', 1500), (119, '2021-12-17 14:39', 1050), (120, '2021-12-17 14:41', 1350), (121, '2021-12-17 14:45', 1100), (122, '2021-12-17 14:45', 1150), (123, '2021-12-17 14:47', 700), (124, '2021-12-17 14:52', 1450), (125, '2021-12-17 14:53', 500), (126, '2021-12-17 15:1', 1000), (127, '2021-12-17 15:5', 250), (128, '2021-12-17 15:5', 1350), (129, '2021-12-17 15:8', 600), (130, '2021-12-17 15:9', 800), (131, '2021-12-17 15:10', 1210), (132, '2021-12-17 15:10', 1260), (133, '2021-12-17 15:14', 650), (134, '2021-12-17 15:14', 1410), (135, '2021-12-17 15:14', 700), (136, '2021-12-17 15:18', 1130), (137, '2021-12-17 15:18', 900), (138, '2021-12-17 15:20', 1360), (139, '2021-12-17 15:21', 950), (140, '2021-12-17 15:23', 650), (141, '2021-12-17 15:25', 1300), (142, '2021-12-17 15:25', 1250), (143, '2021-12-17 15:26', 500), (144, '2021-12-17 15:27', 950), (145, '2021-12-17 15:29', 1150), (146, '2021-12-17 15:32', 850), (147, '2021-12-17 15:33', 1050), (148, '2021-12-17 15:33', 1700), (149, '2021-12-17 15:37', 500), (150, '2021-12-17 15:37', 400), (151, '2021-12-17 15:40', 1350), (152, '2021-12-17 15:42', 330), (153, '2021-12-17 15:43', 800), (154, '2021-12-17 15:43', 300), (155, '2021-12-17 15:45', 400), (156, '2021-12-17 15:49', 1160), (157, '2021-12-17 15:49', 1000), (158, '2021-12-17 15:53', 350), (159, '2021-12-17 15:54', 500), (160, '2021-12-17 15:55', 250), (161, '2021-12-17 15:58', 950), (162, '2021-12-17 16:0', 650), (163, '2021-12-17 16:1', 550), (164, '2021-12-17 16:2', 630), (165, '2021-12-17 16:3', 250), (166, '2021-12-17 16:5', 1250), (167, '2021-12-17 16:6', 1060), (168, '2021-12-17 16:8', 700), (169, '2021-12-17 16:8', 1650), (170, '2021-12-17 16:9', 1030), (171, '2021-12-17 16:10', 1350), (172, '2021-12-17 16:14', 1400), (173, '2021-12-17 16:15', 750), (174, '2021-12-17 16:15', 1260), (175, '2021-12-17 16:16', 2100), (176, '2021-12-17 16:17', 150), (177, '2021-12-17 16:19', 980), (178, '2021-12-17 16:20', 600), (179, '2021-12-17 16:20', 300), (180, '2021-12-17 16:23', 1100), (181, '2021-12-17 16:23', 1000), (182, '2021-12-17 16:24', 1400), (183, '2021-12-17 16:24', 500), (184, '2021-12-17 16:25', 600), (185, '2021-12-17 16:27', 800), (186, '2021-12-17 16:30', 1510), (187, '2021-12-17 16:30', 500), (188, '2021-12-17 16:31', 850), (189, '2021-12-17 16:32', 910), (190, '2021-12-17 16:33', 1150), (191, '2021-12-17 16:34', 980), (192, '2021-12-17 16:35', 1700), (193, '2021-12-17 16:36', 880), (194, '2021-12-17 16:39', 200), (195, '2021-12-17 16:40', 250), (196, '2021-12-17 16:40', 1380), (197, '2021-12-17 16:43', 1050), (198, '2021-12-17 16:43', 150), (199, '2021-12-17 16:44', 900), (200, '2021-12-17 16:44', 1000), (201, '2021-12-17 16:45', 960), (202, '2021-12-17 16:47', 1000), (203, '2021-12-17 16:49', 300), (204, '2021-12-17 16:49', 1300), (205, '2021-12-17 16:49', 1350), (206, '2021-12-17 16:50', 1100), (207, '2021-12-17 16:51', 330), (208, '2021-12-17 16:54', 400), (209, '2021-12-17 16:56', 1160), (210, '2021-12-17 16:58', 700), (211, '2021-12-17 16:59', 1100), (212, '2021-12-17 17:0', 300), (213, '2021-12-17 17:0', 1050), (214, '2021-12-17 17:0', 850), (215, '2021-12-17 17:1', 900), (216, '2021-12-17 17:2', 900), (217, '2021-12-17 17:3', 1150), (218, '2021-12-17 17:6', 250), (219, '2021-12-17 17:7', 500), (220, '2021-12-17 17:7', 1100), (221, '2021-12-17 17:7', 300), (222, '2021-12-17 17:8', 500), (223, '2021-12-17 17:10', 500), (224, '2021-12-17 17:10', 400), (225, '2021-12-17 17:11', 700), (226, '2021-12-17 17:11', 1000), (227, '2021-12-17 17:12', 830), (228, '2021-12-17 17:14', 1800), (229, '2021-12-17 17:15', 1700), (230, '2021-12-17 17:16', 250), (231, '2021-12-17 17:16', 1100), (232, '2021-12-17 17:16', 1100), (233, '2021-12-17 17:17', 1500), (234, '2021-12-17 17:18', 1500), (235, '2021-12-17 17:20', 250), (236, '2021-12-17 17:20', 700), (237, '2021-12-17 17:21', 1750), (238, '2021-12-17 17:22', 1660), (239, '2021-12-17 17:22', 800), (240, '2021-12-17 17:23', 860), (241, '2021-12-17 17:24', 1100), (242, '2021-12-17 17:24', 1330), (243, '2021-12-17 17:24', 1300), (244, '2021-12-17 17:24', 900), (245, '2021-12-17 17:25', 1350), (246, '2021-12-17 17:25', 200), (247, '2021-12-17 17:27', 730), (248, '2021-12-17 17:27', 950), (249, '2021-12-17 17:29', 1100), (250, '2021-12-17 17:29', 750), (251, '2021-12-17 17:31', 800), (252, '2021-12-17 17:33', 1550), (253, '2021-12-17 17:33', 500), (254, '2021-12-17 17:34', 930), (255, '2021-12-17 17:34', 500), (256, '2021-12-17 17:35', 1100), (257, '2021-12-17 17:36', 400), (258, '2021-12-17 17:36', 1000), (259, '2021-12-17 17:36', 1150), (260, '2021-12-17 17:37', 1000), (261, '2021-12-17 17:37', 600), (262, '2021-12-17 17:38', 300), (263, '2021-12-17 17:39', 1150), (264, '2021-12-17 17:39', 1310), (265, '2021-12-17 17:40', 600), (266, '2021-12-17 17:40', 250), (267, '2021-12-17 17:40', 910), (268, '2021-12-17 17:41', 500), (269, '2021-12-17 17:42', 450), (270, '2021-12-17 17:44', 700), (271, '2021-12-17 17:44', 1000), (272, '2021-12-17 17:45', 1410), (273, '2021-12-17 17:46', 1050), (274, '2021-12-17 17:48', 500), (275, '2021-12-17 17:48', 630), (276, '2021-12-17 17:49', 150), (277, '2021-12-17 17:49', 500), (278, '2021-12-17 17:51', 1200), (279, '2021-12-17 17:51', 950), (280, '2021-12-17 17:54', 850), (281, '2021-12-17 17:54', 880), (282, '2021-12-17 17:54', 1100), (283, '2021-12-17 17:55', 250), (284, '2021-12-17 17:56', 500), (285, '2021-12-17 17:58', 1410), (286, '2021-12-17 17:58', 1000), (287, '2021-12-17 17:59', 580), (288, '2021-12-17 17:59', 250), (289, '2021-12-17 18:0', 1150), (290, '2021-12-17 18:1', 250), (291, '2021-12-17 18:1', 850), (292, '2021-12-17 18:1', 250), (293, '2021-12-17 18:1', 1300), (294, '2021-12-17 18:2', 750), (295, '2021-12-17 18:3', 1100), (296, '2021-12-17 18:4', 400), (297, '2021-12-17 18:5', 550), (298, '2021-12-17 18:7', 450), (299, '2021-12-17 18:8', 1460), (300, '2021-12-17 18:8', 1700), (301, '2021-12-17 18:8', 1310), (302, '2021-12-17 18:8', 1700), (303, '2021-12-17 18:9', 1150), (304, '2021-12-17 18:9', 700), (305, '2021-12-17 18:9', 450), (306, '2021-12-17 18:11', 1200), (307, '2021-12-17 18:13', 1600), (308, '2021-12-17 18:13', 650), (309, '2021-12-17 18:13', 330), (310, '2021-12-17 18:13', 1500), (311, '2021-12-17 18:15', 900), (312, '2021-12-17 18:15', 950), (313, '2021-12-17 18:16', 500), (314, '2021-12-17 18:18', 250), (315, '2021-12-17 18:21', 150), (316, '2021-12-17 18:23', 730), (317, '2021-12-17 18:23', 700), (318, '2021-12-17 18:25', 600), (319, '2021-12-17 18:25', 150), (320, '2021-12-17 18:25', 1500), (321, '2021-12-17 18:26', 1550), (322, '2021-12-17 18:27', 800), (323, '2021-12-17 18:27', 1050), (324, '2021-12-17 18:28', 1200), (325, '2021-12-17 18:28', 350), (326, '2021-12-17 18:28', 1550), (327, '2021-12-17 18:29', 1500), (328, '2021-12-17 18:30', 1000), (329, '2021-12-17 18:30', 1530), (330, '2021-12-17 18:30', 850), (331, '2021-12-17 18:31', 650), (332, '2021-12-17 18:31', 150), (333, '2021-12-17 18:31', 700), (334, '2021-12-17 18:32', 850), (335, '2021-12-17 18:32', 500), (336, '2021-12-17 18:34', 1100), (337, '2021-12-17 18:35', 1250), (338, '2021-12-17 18:36', 150), (339, '2021-12-17 18:37', 1350), (340, '2021-12-17 18:37', 780), (341, '2021-12-17 18:38', 1600), (342, '2021-12-17 18:38', 750), (343, '2021-12-17 18:39', 850), (344, '2021-12-17 18:39', 1000), (345, '2021-12-17 18:40', 1530), (346, '2021-12-17 18:41', 400), (347, '2021-12-17 18:41', 1260), (348, '2021-12-17 18:42', 900), (349, '2021-12-17 18:43', 1450), (350, '2021-12-17 18:43', 1160), (351, '2021-12-17 18:44', 1110), (352, '2021-12-17 18:44', 850), (353, '2021-12-17 18:47', 1400), (354, '2021-12-17 18:50', 500), (355, '2021-12-17 18:50', 650), (356, '2021-12-17 18:51', 330), (357, '2021-12-17 18:51', 1150), (358, '2021-12-17 18:52', 800), (359, '2021-12-17 18:54', 300), (360, '2021-12-17 18:54', 1060), (361, '2021-12-17 18:55', 300), (362, '2021-12-17 18:55', 400), (363, '2021-12-17 18:56', 1300), (364, '2021-12-17 18:57', 850), (365, '2021-12-17 18:57', 330), (366, '2021-12-17 18:58', 800), (367, '2021-12-17 18:59', 600), (368, '2021-12-17 18:59', 1650), (369, '2021-12-17 18:59', 500), (370, '2021-12-17 18:59', 300), (371, '2021-12-17 18:59', 1100), (372, '2021-12-17 19:0', 1750), (373, '2021-12-17 19:1', 350), (374, '2021-12-17 19:1', 1150), (375, '2021-12-17 19:2', 1260), (376, '2021-12-17 19:3', 1250), (377, '2021-12-17 19:4', 1250), (378, '2021-12-17 19:6', 1500), (379, '2021-12-17 19:7', 750), (380, '2021-12-17 19:7', 1050), (381, '2021-12-17 19:8', 250), (382, '2021-12-17 19:9', 500), (383, '2021-12-17 19:10', 750), (384, '2021-12-17 19:10', 1630), (385, '2021-12-17 19:12', 1330), (386, '2021-12-17 19:13', 330), (387, '2021-12-17 19:13', 1750), (388, '2021-12-17 19:16', 1460), (389, '2021-12-17 19:22', 150), (390, '2021-12-17 19:24', 400), (391, '2021-12-17 19:25', 850), (392, '2021-12-17 19:26', 1190), (393, '2021-12-17 19:27', 980), (394, '2021-12-17 19:27', 1350), (395, '2021-12-17 19:29', 1150), (396, '2021-12-17 19:30', 1080), (397, '2021-12-17 19:32', 1160), (398, '2021-12-17 19:33', 1350), (399, '2021-12-17 19:34', 300), (400, '2021-12-17 19:36', 1000), (401, '2021-12-17 19:38', 1000), (402, '2021-12-17 19:40', 500), (403, '2021-12-17 19:42', 850), (404, '2021-12-17 19:42', 800), (405, '2021-12-17 19:42', 650), (406, '2021-12-17 19:43', 1000), (407, '2021-12-17 19:43', 700), (408, '2021-12-17 19:43', 650), (409, '2021-12-17 19:45', 500), (410, '2021-12-17 19:48', 1150), (411, '2021-12-17 19:49', 1300), (412, '2021-12-17 19:50', 1100), (413, '2021-12-17 19:50', 850), (414, '2021-12-17 19:52', 300), (415, '2021-12-17 19:54', 1700), (416, '2021-12-17 19:54', 750), (417, '2021-12-17 19:55', 750), (418, '2021-12-17 19:55', 1300), (419, '2021-12-17 19:55', 150), (420, '2021-12-17 20:2', 250), (421, '2021-12-17 20:3', 330), (422, '2021-12-17 20:4', 850), (423, '2021-12-17 20:7', 1500), (424, '2021-12-17 20:8', 700), (425, '2021-12-17 20:9', 500), (426, '2021-12-17 20:12', 1150), (427, '2021-12-17 20:13', 700), (428, '2021-12-17 20:14', 600), (429, '2021-12-17 20:15', 500), (430, '2021-12-17 20:16', 1350), (431, '2021-12-17 20:19', 400), (432, '2021-12-17 20:20', 1100), (433, '2021-12-17 20:24', 500), (434, '2021-12-17 20:24', 600), (435, '2021-12-17 20:27', 500), (436, '2021-12-17 20:27', 150), (437, '2021-12-17 20:31', 350), (438, '2021-12-17 20:36', 1000), (439, '2021-12-17 20:39', 500), (440, '2021-12-17 20:56', 1630);
CREATE TABLE ordered_menu(
ordered_id INTEGER NOT NULL,
menu_id INTEGER NOT NULL,
num INTEGER NOT NULL,
sum INTEGER NOT NULL,
PRIMARY KEY(ordered_id,menu_id)
);
INSERT INTO ordered_menu VALUES (1, 14, 1, 200), (2, 21, 1, 250), (3, 8, 1, 350), (3, 14, 2, 400), (3, 15, 2, 300), (4, 9, 2, 660), (4, 20, 2, 500), (4, 22, 1, 350), (5, 20, 2, 500), (6, 12, 2, 600), (7, 7, 1, 350), (8, 23, 3, 750), (8, 27, 1, 300), (9, 15, 2, 300), (9, 18, 1, 150), (9, 24, 1, 250), (10, 1, 2, 400), (10, 7, 2, 700), (11, 3, 1, 300), (12, 3, 1, 300), (12, 20, 2, 500), (13, 24, 1, 250), (14, 7, 2, 700), (14, 15, 1, 150), (14, 19, 2, 300), (15, 9, 2, 660), (15, 20, 2, 500), (15, 24, 1, 250), (16, 13, 2, 1000), (16, 24, 1, 250), (17, 21, 2, 500), (18, 5, 2, 500), (19, 7, 2, 700), (19, 16, 2, 300), (19, 27, 2, 600), (20, 3, 1, 300), (20, 23, 2, 500), (21, 20, 2, 500), (22, 17, 2, 500), (22, 21, 2, 500), (22, 23, 2, 500), (23, 7, 4, 1400), (24, 5, 2, 500), (24, 7, 2, 700), (24, 22, 1, 350), (25, 12, 1, 300), (25, 24, 1, 250), (26, 10, 2, 300), (26, 15, 1, 150), (26, 26, 2, 500), (27, 6, 2, 700), (27, 13, 1, 500), (27, 18, 2, 300), (28, 1, 2, 400), (28, 5, 1, 250), (28, 21, 1, 250), (29, 16, 1, 150), (29, 19, 1, 150), (29, 25, 1, 250), (30, 9, 1, 330), (30, 10, 2, 300), (30, 18, 1, 150), (31, 18, 3, 450), (32, 8, 1, 350), (32, 9, 2, 660), (32, 10, 1, 150), (33, 11, 1, 250), (33, 18, 2, 300), (33, 25, 1, 250), (34, 11, 1, 250), (34, 14, 1, 200), (35, 5, 2, 500), (35, 9, 1, 330), (35, 27, 1, 300), (36, 4, 2, 660), (36, 15, 1, 150), (36, 19, 1, 150), (37, 1, 2, 400), (37, 24, 2, 500), (38, 12, 2, 600), (39, 2, 2, 500), (39, 8, 2, 700), (39, 24, 2, 500), (40, 27, 2, 600), (41, 9, 2, 660), (42, 2, 2, 500), (43, 3, 1, 300), (43, 14, 1, 200), (44, 13, 1, 500), (44, 22, 1, 350), (44, 27, 2, 600), (45, 14, 2, 400), (45, 22, 1, 350), (46, 16, 2, 300), (46, 18, 2, 300), (46, 19, 1, 150), (47, 13, 2, 1000), (48, 15, 1, 150), (49, 13, 1, 500), (49, 18, 1, 150), (49, 19, 1, 150), (50, 3, 2, 600), (50, 6, 1, 350), (50, 17, 2, 500), (51, 19, 2, 300), (51, 22, 2, 700), (52, 2, 2, 500), (52, 6, 2, 700), (52, 25, 1, 250), (53, 2, 1, 250), (53, 6, 2, 700), (53, 25, 2, 500), (54, 8, 1, 350), (54, 22, 4, 1400), (55, 27, 2, 600), (56, 20, 2, 500), (56, 23, 2, 500), (56, 27, 1, 300), (57, 5, 2, 500), (57, 14, 1, 200), (57, 18, 2, 300), (58, 3, 2, 600), (59, 18, 2, 300), (59, 23, 1, 250), (59, 24, 1, 250), (60, 9, 1, 330), (61, 26, 1, 250), (61, 27, 2, 600), (62, 5, 2, 500), (62, 20, 2, 500), (63, 10, 2, 300), (64, 4, 2, 660), (64, 8, 2, 700), (65, 10, 4, 600), (65, 17, 2, 500), (66, 5, 2, 500), (66, 10, 2, 300), (67, 13, 1, 500), (67, 16, 2, 300), (67, 21, 2, 500), (68, 5, 2, 500), (69, 22, 2, 700), (70, 2, 1, 250), (70, 16, 1, 150), (70, 25, 1, 250), (71, 4, 1, 330), (71, 12, 2, 600), (71, 19, 1, 150), (72, 15, 1, 150), (72, 19, 2, 300), (72, 22, 2, 700), (73, 5, 1, 250), (73, 7, 1, 350), (73, 8, 1, 350), (74, 8, 1, 350), (74, 13, 1, 500), (74, 21, 1, 250), (75, 14, 2, 400), (76, 3, 2, 600), (76, 6, 1, 350), (76, 16, 1, 150), (77, 4, 2, 660), (77, 10, 2, 300), (77, 22, 1, 350), (78, 12, 2, 600), (79, 19, 1, 150), (79, 20, 2, 500), (79, 27, 2, 600), (80, 14, 1, 200), (81, 1, 2, 400), (82, 4, 1, 330), (82, 8, 2, 700), (83, 22, 2, 700), (84, 17, 2, 500), (84, 27, 1, 300), (85, 5, 2, 500), (85, 10, 2, 300), (85, 11, 1, 250), (86, 14, 1, 200), (86, 24, 2, 500), (86, 25, 1, 250), (87, 5, 1, 250), (87, 6, 2, 700), (87, 19, 2, 300), (88, 4, 1, 330), (88, 15, 2, 300), (88, 18, 2, 300), (89, 13, 1, 500), (89, 18, 2, 300), (89, 19, 1, 150), (90, 13, 1, 500), (90, 19, 1, 150), (90, 21, 2, 500), (91, 1, 2, 400), (91, 9, 2, 660), (91, 21, 1, 250), (92, 11, 2, 500), (93, 26, 1, 250), (94, 3, 2, 600), (94, 11, 1, 250), (94, 26, 2, 500), (95, 1, 2, 400), (96, 4, 1, 330), (96, 8, 2, 700), (96, 14, 2, 400), (97, 15, 1, 150), (97, 27, 1, 300), (98, 1, 2, 400), (98, 23, 3, 750), (99, 1, 2, 400), (99, 9, 2, 660), (99, 20, 1, 250), (100, 7, 1, 350), (100, 13, 1, 500), (100, 27, 1, 300), (101, 5, 1, 250), (102, 20, 1, 250), (102, 23, 2, 500), (102, 27, 1, 300), (103, 6, 2, 700), (103, 18, 2, 300), (103, 27, 1, 300), (104, 8, 1, 350), (104, 9, 2, 660), (104, 10, 1, 150), (105, 24, 1, 250), (106, 15, 1, 150), (106, 25, 2, 500), (107, 7, 2, 700), (107, 18, 1, 150), (107, 19, 1, 150), (108, 6, 2, 700), (108, 8, 1, 350), (108, 14, 1, 200), (109, 7, 2, 700), (109, 21, 1, 250), (110, 7, 2, 700), (110, 10, 1, 150), (110, 20, 1, 250), (111, 23, 2, 500), (112, 4, 2, 660), (112, 6, 2, 700), (113, 3, 1, 300), (113, 4, 1, 330), (114, 8, 1, 350), (114, 13, 2, 1000), (115, 5, 1, 250), (115, 8, 1, 350), (115, 17, 2, 500), (116, 4, 1, 330), (116, 7, 2, 700), (116, 19, 1, 150), (117, 13, 1, 500), (118, 13, 3, 1500), (119, 15, 2, 300), (119, 23, 2, 500), (119, 25, 1, 250), (120, 7, 2, 700), (120, 8, 1, 350), (120, 18, 2, 300), (121, 2, 1, 250), (121, 6, 1, 350), (121, 25, 2, 500), (122, 8, 1, 350), (122, 13, 1, 500), (122, 15, 2, 300), (123, 13, 1, 500), (123, 14, 1, 200), (124, 6, 2, 700), (124, 11, 2, 500), (124, 24, 1, 250), (125, 1, 1, 200), (125, 10, 2, 300), (126, 13, 2, 1000), (127, 21, 1, 250), (128, 19, 1, 150), (128, 27, 4, 1200), (129, 12, 2, 600), (130, 20, 2, 500), (130, 27, 1, 300), (131, 4, 2, 660), (131, 19, 2, 300), (131, 24, 1, 250), (132, 4, 2, 660), (132, 7, 1, 350), (132, 23, 1, 250), (133, 19, 1, 150), (133, 26, 2, 500), (134, 9, 2, 660), (134, 17, 2, 500), (134, 21, 1, 250), (135, 8, 2, 700), (136, 9, 1, 330), (136, 10, 2, 300), (136, 17, 2, 500), (137, 12, 2, 600), (137, 16, 1, 150), (137, 19, 1, 150), (138, 4, 2, 660), (138, 6, 2, 700), (139, 21, 1, 250), (139, 22, 2, 700), (140, 1, 1, 200), (140, 14, 1, 200), (140, 24, 1, 250), (141, 10, 2, 300), (141, 13, 2, 1000), (142, 7, 2, 700), (142, 12, 1, 300), (142, 20, 1, 250), (143, 17, 2, 500), (144, 6, 1, 350), (144, 8, 1, 350), (144, 25, 1, 250), (145, 1, 2, 400), (145, 2, 2, 500), (145, 5, 1, 250), (146, 6, 1, 350), (146, 14, 1, 200), (146, 18, 2, 300), (147, 5, 2, 500), (147, 19, 2, 300), (147, 24, 1, 250), (148, 7, 2, 700), (148, 23, 4, 1000), (149, 24, 2, 500), (150, 14, 2, 400), (151, 2, 2, 500), (151, 8, 1, 350), (151, 17, 2, 500), (152, 9, 1, 330), (153, 2, 2, 500), (153, 27, 1, 300), (154, 3, 1, 300), (155, 14, 2, 400), (156, 4, 2, 660), (156, 17, 1, 250), (156, 21, 1, 250), (157, 14, 1, 200), (157, 16, 2, 300), (157, 17, 2, 500), (158, 7, 1, 350), (159, 23, 2, 500), (160, 17, 1, 250), (161, 10, 1, 150), (161, 11, 2, 500), (161, 12, 1, 300), (162, 1, 1, 200), (162, 16, 1, 150), (162, 18, 2, 300), (163, 10, 1, 150), (163, 15, 1, 150), (163, 23, 1, 250), (164, 4, 1, 330), (164, 10, 2, 300), (165, 5, 1, 250), (166, 13, 1, 500), (166, 21, 3, 750), (167, 2, 1, 250), (167, 9, 2, 660), (167, 16, 1, 150), (168, 6, 2, 700), (169, 7, 1, 350), (169, 13, 2, 1000), (169, 27, 1, 300), (170, 8, 1, 350), (170, 9, 1, 330), (170, 22, 1, 350), (171, 3, 2, 600), (171, 24, 1, 250), (171, 25, 2, 500), (172, 8, 2, 700), (172, 14, 2, 400), (172, 27, 1, 300), (173, 20, 3, 750), (174, 4, 2, 660), (174, 15, 2, 300), (174, 16, 2, 300), (175, 12, 2, 600), (175, 13, 2, 1000), (175, 24, 2, 500), (176, 15, 1, 150), (177, 4, 1, 330), (177, 5, 2, 500), (177, 15, 1, 150), (178, 1, 1, 200), (178, 2, 1, 250), (178, 18, 1, 150), (179, 15, 2, 300), (180, 5, 1, 250), (180, 20, 2, 500), (180, 22, 1, 350), (181, 2, 2, 500), (181, 14, 1, 200), (181, 19, 2, 300), (182, 12, 2, 600), (182, 15, 2, 300), (182, 20, 2, 500), (183, 2, 2, 500), (184, 18, 2, 300), (184, 19, 2, 300), (185, 12, 1, 300), (185, 14, 1, 200), (185, 15, 2, 300), (186, 4, 2, 660), (186, 6, 2, 700), (186, 19, 1, 150), (187, 5, 2, 500), (188, 22, 1, 350), (188, 24, 2, 500), (189, 9, 2, 660), (189, 11, 1, 250), (190, 2, 2, 500), (190, 14, 2, 400), (190, 17, 1, 250), (191, 1, 2, 400), (191, 4, 1, 330), (191, 11, 1, 250), (192, 5, 2, 500), (192, 22, 2, 700), (192, 25, 2, 500), (193, 5, 1, 250), (193, 9, 1, 330), (193, 16, 2, 300), (194, 1, 1, 200), (195, 25, 1, 250), (196, 9, 1, 330), (196, 22, 3, 1050), (197, 11, 1, 250), (197, 19, 2, 300), (197, 25, 2, 500), (198, 16, 1, 150), (199, 19, 2, 300), (199, 20, 1, 250), (199, 22, 1, 350), (200, 3, 1, 300), (200, 8, 2, 700), (201, 4, 2, 660), (201, 27, 1, 300), (202, 5, 1, 250), (202, 17, 1, 250), (202, 23, 2, 500), (203, 16, 2, 300), (204, 18, 2, 300), (204, 20, 2, 500), (204, 21, 2, 500), (205, 8, 1, 350), (205, 17, 2, 500), (205, 25, 2, 500), (206, 3, 2, 600), (206, 11, 1, 250), (206, 24, 1, 250), (207, 9, 1, 330), (208, 15, 1, 150), (208, 21, 1, 250), (209, 5, 2, 500), (209, 9, 2, 660), (210, 14, 2, 400), (210, 16, 2, 300), (211, 3, 2, 600), (211, 8, 1, 350), (211, 19, 1, 150), (212, 15, 2, 300), (213, 11, 1, 250), (213, 12, 1, 300), (213, 17, 2, 500), (214, 15, 4, 600), (214, 26, 1, 250), (215, 6, 1, 350), (215, 15, 2, 300), (215, 23, 1, 250), (216, 15, 1, 150), (216, 20, 1, 250), (216, 24, 2, 500), (217, 2, 2, 500), (217, 19, 2, 300), (217, 22, 1, 350), (218, 26, 1, 250), (219, 21, 2, 500), (220, 21, 2, 500), (220, 27, 2, 600), (221, 27, 1, 300), (222, 23, 2, 500), (223, 2, 2, 500), (224, 19, 1, 150), (224, 23, 1, 250), (225, 7, 2, 700), (226, 13, 2, 1000), (227, 2, 2, 500), (227, 9, 1, 330), (228, 8, 2, 700), (228, 12, 2, 600), (228, 24, 2, 500), (229, 8, 2, 700), (229, 13, 1, 500), (229, 21, 2, 500), (230, 5, 1, 250), (231, 5, 1, 250), (231, 8, 2, 700), (231, 10, 1, 150), (232, 6, 1, 350), (232, 11, 2, 500), (232, 20, 1, 250), (233, 3, 2, 600), (233, 12, 2, 600), (233, 15, 2, 300), (234, 7, 2, 700), (234, 17, 2, 500), (234, 27, 1, 300), (235, 23, 1, 250), (236, 1, 1, 200), (236, 15, 1, 150), (236, 22, 1, 350), (237, 13, 3, 1500), (237, 26, 1, 250), (238, 5, 2, 500), (238, 9, 2, 660), (238, 17, 2, 500), (239, 16, 2, 300), (239, 25, 2, 500), (240, 1, 1, 200), (240, 9, 2, 660), (241, 26, 2, 500), (241, 27, 2, 600), (242, 9, 1, 330), (242, 13, 2, 1000), (243, 7, 2, 700), (243, 18, 2, 300), (243, 19, 2, 300), (244, 12, 1, 300), (244, 19, 2, 300), (244, 27, 1, 300), (245, 6, 1, 350), (245, 8, 2, 700), (245, 10, 2, 300), (246, 14, 1, 200), (247, 9, 1, 330), (247, 10, 1, 150), (247, 23, 1, 250), (248, 14, 1, 200), (248, 20, 1, 250), (248, 26, 2, 500), (249, 7, 1, 350), (249, 13, 1, 500), (249, 25, 1, 250), (250, 17, 2, 500), (250, 21, 1, 250), (251, 3, 1, 300), (251, 13, 1, 500), (252, 3, 2, 600), (252, 7, 2, 700), (252, 24, 1, 250), (253, 25, 2, 500), (254, 9, 1, 330), (254, 12, 1, 300), (254, 15, 2, 300), (255, 26, 2, 500), (256, 8, 2, 700), (256, 16, 1, 150), (256, 26, 1, 250), (257, 14, 2, 400), (258, 17, 2, 500), (258, 25, 2, 500), (259, 2, 2, 500), (259, 15, 1, 150), (259, 25, 2, 500), (260, 2, 1, 250), (260, 5, 2, 500), (260, 11, 1, 250), (261, 3, 1, 300), (261, 27, 1, 300), (262, 3, 1, 300), (263, 2, 2, 500), (263, 13, 1, 500), (263, 18, 1, 150), (264, 9, 2, 660), (264, 13, 1, 500), (264, 18, 1, 150), (265, 15, 4, 600), (266, 11, 1, 250), (267, 5, 1, 250), (267, 9, 2, 660), (268, 5, 2, 500), (269, 15, 1, 150), (269, 27, 1, 300), (270, 22, 2, 700), (271, 13, 2, 1000), (272, 9, 2, 660), (272, 13, 1, 500), (272, 21, 1, 250), (273, 8, 1, 350), (273, 22, 2, 700), (274, 17, 2, 500), (275, 9, 1, 330), (275, 18, 2, 300), (276, 18, 1, 150), (277, 24, 2, 500), (278, 1, 1, 200), (278, 7, 2, 700), (278, 10, 2, 300), (279, 3, 1, 300), (279, 11, 2, 500), (279, 15, 1, 150), (280, 2, 1, 250), (280, 6, 1, 350), (280, 24, 1, 250), (281, 4, 1, 330), (281, 25, 1, 250), (281, 27, 1, 300), (282, 22, 1, 350), (282, 23, 2, 500), (282, 25, 1, 250), (283, 23, 1, 250), (284, 5, 2, 500), (285, 9, 2, 660), (285, 21, 1, 250), (285, 24, 2, 500), (286, 6, 1, 350), (286, 11, 2, 500), (286, 16, 1, 150), (287, 9, 1, 330), (287, 11, 1, 250), (288, 23, 1, 250), (289, 1, 2, 400), (289, 11, 1, 250), (289, 21, 2, 500), (290, 20, 1, 250), (291, 13, 1, 500), (291, 14, 1, 200), (291, 19, 1, 150), (292, 21, 1, 250), (293, 6, 2, 700), (293, 7, 1, 350), (293, 20, 1, 250), (294, 1, 2, 400), (294, 6, 1, 350), (295, 6, 2, 700), (295, 16, 1, 150), (295, 25, 1, 250), (296, 14, 2, 400), (297, 3, 1, 300), (297, 17, 1, 250), (298, 15, 1, 150), (298, 16, 2, 300), (299, 9, 2, 660), (299, 19, 2, 300), (299, 21, 2, 500), (300, 5, 2, 500), (300, 7, 2, 700), (300, 20, 2, 500), (301, 1, 2, 400), (301, 9, 2, 660), (301, 17, 1, 250), (302, 7, 4, 1400), (302, 27, 1, 300), (303, 19, 2, 300), (303, 26, 1, 250), (303, 27, 2, 600), (304, 8, 2, 700), (305, 10, 1, 150), (305, 19, 2, 300), (306, 1, 2, 400), (306, 12, 1, 300), (306, 26, 2, 500), (307, 2, 2, 500), (307, 3, 2, 600), (307, 20, 2, 500), (308, 10, 1, 150), (308, 26, 2, 500), (309, 4, 1, 330), (310, 13, 1, 500), (310, 20, 2, 500), (310, 21, 2, 500), (311, 10, 1, 150), (311, 17, 2, 500), (311, 26, 1, 250), (312, 10, 2, 300), (312, 16, 1, 150), (312, 20, 2, 500), (313, 14, 1, 200), (313, 15, 1, 150), (313, 18, 1, 150), (314, 24, 1, 250), (315, 19, 1, 150), (316, 4, 1, 330), (316, 10, 1, 150), (316, 26, 1, 250), (317, 7, 2, 700), (318, 10, 2, 300), (318, 16, 1, 150), (318, 18, 1, 150), (319, 18, 1, 150), (320, 12, 2, 600), (320, 16, 2, 300), (320, 27, 2, 600), (321, 7, 2, 700), (321, 12, 2, 600), (321, 24, 1, 250), (322, 25, 2, 500), (322, 27, 1, 300), (323, 2, 2, 500), (323, 12, 1, 300), (323, 17, 1, 250), (324, 6, 2, 700), (324, 11, 1, 250), (324, 25, 1, 250), (325, 22, 1, 350), (326, 2, 2, 500), (326, 6, 2, 700), (326, 22, 1, 350), (327, 7, 2, 700), (327, 15, 2, 300), (327, 20, 2, 500), (328, 2, 2, 500), (328, 20, 1, 250), (328, 24, 1, 250), (329, 5, 2, 500), (329, 6, 2, 700), (329, 9, 1, 330), (330, 1, 1, 200), (330, 18, 1, 150), (330, 21, 2, 500), (331, 3, 1, 300), (331, 14, 1, 200), (331, 18, 1, 150), (332, 10, 1, 150), (333, 7, 2, 700), (334, 11, 1, 250), (334, 12, 2, 600), (335, 25, 2, 500), (336, 7, 1, 350), (336, 20, 2, 500), (336, 23, 1, 250), (337, 17, 2, 500), (337, 21, 1, 250), (337, 23, 2, 500), (338, 19, 1, 150), (339, 7, 2, 700), (339, 8, 1, 350), (339, 12, 1, 300), (340, 9, 1, 330), (340, 16, 2, 300), (340, 19, 1, 150), (341, 3, 2, 600), (341, 13, 2, 1000), (342, 16, 2, 300), (342, 18, 1, 150), (342, 27, 1, 300), (343, 8, 1, 350), (343, 24, 2, 500), (344, 20, 2, 500), (344, 26, 2, 500), (345, 4, 1, 330), (345, 6, 2, 700), (345, 23, 2, 500), (346, 1, 2, 400), (347, 8, 1, 350), (347, 9, 2, 660), (347, 21, 1, 250), (348, 13, 1, 500), (348, 19, 1, 150), (348, 23, 1, 250), (349, 7, 2, 700), (349, 24, 2, 500), (349, 25, 1, 250), (350, 9, 2, 660), (350, 21, 2, 500), (351, 9, 2, 660), (351, 15, 1, 150), (351, 16, 2, 300), (352, 8, 1, 350), (352, 21, 1, 250), (352, 26, 1, 250), (353, 14, 2, 400), (353, 21, 2, 500), (353, 24, 2, 500), (354, 2, 2, 500), (355, 10, 1, 150), (355, 24, 2, 500), (356, 9, 1, 330), (357, 2, 2, 500), (357, 14, 2, 400), (357, 25, 1, 250), (358, 12, 1, 300), (358, 25, 1, 250), (358, 26, 1, 250), (359, 12, 1, 300), (360, 4, 2, 660), (360, 19, 1, 150), (360, 25, 1, 250), (361, 15, 2, 300), (362, 2, 1, 250), (362, 10, 1, 150), (363, 12, 1, 300), (363, 21, 2, 500), (363, 23, 2, 500), (364, 8, 1, 350), (364, 11, 1, 250), (364, 17, 1, 250), (365, 9, 1, 330), (366, 18, 1, 150), (366, 19, 1, 150), (366, 26, 2, 500), (367, 27, 2, 600), (368, 5, 1, 250), (368, 6, 2, 700), (368, 22, 2, 700), (369, 11, 2, 500), (370, 19, 2, 300), (371, 3, 2, 600), (371, 24, 2, 500), (372, 2, 1, 250), (372, 13, 2, 1000), (372, 23, 2, 500), (373, 8, 1, 350), (374, 5, 2, 500), (374, 10, 1, 150), (374, 24, 2, 500), (375, 3, 1, 300), (375, 4, 2, 660), (375, 12, 1, 300), (376, 5, 1, 250), (376, 7, 2, 700), (376, 18, 2, 300), (377, 2, 2, 500), (377, 20, 1, 250), (377, 21, 2, 500), (378, 20, 4, 1000), (378, 24, 2, 500), (379, 5, 2, 500), (379, 24, 1, 250), (380, 2, 1, 250), (380, 18, 2, 300), (380, 23, 2, 500), (381, 24, 1, 250), (382, 11, 2, 500), (383, 20, 1, 250), (383, 21, 2, 500), (384, 7, 2, 700), (384, 9, 1, 330), (384, 12, 2, 600), (385, 4, 1, 330), (385, 7, 2, 700), (385, 16, 2, 300), (386, 9, 1, 330), (387, 6, 2, 700), (387, 7, 2, 700), (387, 8, 1, 350), (388, 4, 2, 660), (388, 15, 2, 300), (388, 20, 2, 500), (389, 19, 1, 150), (390, 14, 2, 400), (391, 5, 1, 250), (391, 19, 2, 300), (391, 27, 1, 300), (392, 4, 1, 330), (392, 9, 2, 660), (392, 14, 1, 200), (393, 9, 1, 330), (393, 14, 2, 400), (393, 23, 1, 250), (394, 12, 2, 600), (394, 23, 1, 250), (394, 26, 2, 500), (395, 7, 2, 700), (395, 16, 2, 300), (395, 18, 1, 150), (396, 2, 2, 500), (396, 4, 1, 330), (396, 5, 1, 250), (397, 4, 2, 660), (397, 21, 2, 500), (398, 13, 1, 500), (398, 24, 1, 250), (398, 27, 2, 600), (399, 19, 2, 300), (400, 17, 2, 500), (400, 20, 2, 500), (401, 20, 2, 500), (401, 24, 1, 250), (401, 26, 1, 250), (402, 25, 2, 500), (403, 2, 1, 250), (403, 12, 1, 300), (403, 19, 2, 300), (404, 19, 2, 300), (404, 25, 2, 500), (405, 16, 1, 150), (405, 26, 2, 500), (406, 3, 2, 600), (406, 16, 1, 150), (406, 17, 1, 250), (407, 7, 2, 700), (408, 16, 1, 150), (408, 24, 2, 500), (409, 24, 2, 500), (410, 12, 2, 600), (410, 14, 1, 200), (410, 22, 1, 350), (411, 10, 2, 300), (411, 13, 2, 1000), (412, 11, 1, 250), (412, 20, 1, 250), (412, 27, 2, 600), (413, 2, 1, 250), (413, 8, 1, 350), (413, 26, 1, 250), (414, 10, 2, 300), (415, 7, 2, 700), (415, 8, 2, 700), (415, 10, 2, 300), (416, 3, 1, 300), (416, 14, 1, 200), (416, 26, 1, 250), (417, 2, 1, 250), (417, 11, 1, 250), (417, 24, 1, 250), (418, 3, 2, 600), (418, 7, 2, 700), (419, 15, 1, 150), (420, 20, 1, 250), (421, 4, 1, 330), (422, 17, 1, 250), (422, 27, 2, 600), (423, 2, 2, 500), (423, 8, 2, 700), (423, 12, 1, 300), (424, 10, 1, 150), (424, 15, 2, 300), (424, 26, 1, 250), (425, 11, 2, 500), (426, 1, 2, 400), (426, 13, 1, 500), (426, 17, 1, 250), (427, 8, 2, 700), (428, 27, 2, 600), (429, 26, 2, 500), (430, 7, 2, 700), (430, 22, 1, 350), (430, 27, 1, 300), (431, 10, 1, 150), (431, 25, 1, 250), (432, 5, 2, 500), (432, 10, 2, 300), (432, 27, 1, 300), (433, 5, 2, 500), (434, 12, 2, 600), (435, 26, 2, 500), (436, 19, 1, 150), (437, 8, 1, 350), (438, 7, 1, 350), (438, 13, 1, 500), (438, 16, 1, 150), (439, 5, 2, 500), (440, 7, 2, 700), (440, 9, 1, 330), (440, 27, 2, 600);
CREATE TABLE customer(
customer_id INTEGER PRIMARY KEY,
name VARCHAR(31) NOT NULL,
name_yomi VARCHAR(31) NOT NULL,
join_date DATE NOT NULL,
residence VARCHAR(31)
);
INSERT INTO customer VALUES (1, '日比野弦希', 'ヒビノゲンキ', '2021-01-03', NULL), (2, '谷口正之', 'タニグチマサユキ', '2021-01-04', '鳥取県'), (3, '石塚伽羅', 'イシヅカキャラ', '2021-01-13', '高知県'), (4, '保坂陽真', 'ホサカハルマ', '2021-01-18', '奈良県'), (5, '大下真潤', 'オオシタマヒロ', '2021-01-19', '新潟県'), (6, '目黒雛乃', 'メグロヒナノ', '2021-01-19', '京都府'), (7, '大矢悠太', 'オオヤユウタ', '2021-01-20', '東京都'), (8, '久保莉子', 'クボリコ', '2021-01-30', NULL), (9, '栗原浬月', 'クリハラリツキ', '2021-02-01', '新潟県'), (10, '村山芹佳', 'ムラヤマセリカ', '2021-02-01', NULL), (11, '富山冬舞', 'トミヤマトウマ', '2021-02-05', '富山県'), (12, '篠原純恋', 'シノハラスミレ', '2021-02-05', '宮崎県'), (13, '真野春汰', 'マノシュンタ', '2021-02-05', '東京都'), (14, '野島慶', 'ノジマケイ', '2021-02-07', NULL), (15, '田所璃羽', 'タドコロアキハ', '2021-02-07', '岐阜県'), (16, '藤野柚菜', 'フジノユナ', '2021-02-10', '千葉県'), (17, '竹村蒼羽', 'タケムラアオバ', '2021-02-10', '宮崎県'), (18, '浜本達雄', 'ハマモトタツオ', '2021-02-11', '鹿児島県'), (19, '高村麗', 'タカムラレイ', '2021-02-22', NULL), (20, '北原龍生', 'キタハラタツキ', '2021-02-23', '山梨県'), (21, '栗山一磨', 'クリヤマカズマ', '2021-02-26', '鳥取県'), (22, '福島礼奈', 'フクシマレイナ', '2021-03-08', '佐賀県'), (23, '海老原風花', 'エビハラフウカ', '2021-03-11', '福井県'), (24, '落合忠吉', 'オチアイチュウキチ', '2021-03-13', NULL), (25, '岡崎諒花', 'オカザキリョウカ', '2021-03-17', '奈良県'), (26, '今川創真', 'イマガワソウマ', '2021-03-17', NULL), (27, '滝本香音', 'タキモトカノン', '2021-03-18', '広島県'), (28, '小沼こはく', 'オヌマコハク', '2021-03-21', '長野県'), (29, '石本星廉', 'イシモトセレン', '2021-03-22', '大阪府'), (30, '松下梨子', 'マツシタリコ', '2021-03-23', '東京都'), (31, '中澤夏結子', 'ナカザワナユコ', '2021-03-24', '福井県'), (32, '佐々木奏斗', 'ササキカナト', '2021-03-29', '山梨県'), (33, '立石新次郎', 'タテイシシンジロウ', '2021-04-03', '千葉県'), (34, '堀越葵慎', 'ホリコシキシン', '2021-04-04', '千葉県'), (35, '江成冬星', 'エナリトウセイ', '2021-04-06', NULL), (36, '田中苺花', 'タナカイチカ', '2021-04-09', NULL), (37, '大村悠宇人', 'オオムラユウト', '2021-04-10', NULL), (38, '明石結斗', 'アカイシユイト', '2021-04-11', NULL), (39, '高嶋秀冴', 'タカシマシュウガ', '2021-04-11', '群馬県'), (40, '石村聡師', 'イシムラサトシ', '2021-04-13', '沖縄県'), (41, '小森菜緒', 'コモリナオ', '2021-04-16', '鳥取県'), (42, '永野明日乃', 'ナガノアスノ', '2021-04-16', '高知県'), (43, '矢田翔舞', 'ヤダショウマ', '2021-04-18', '岡山県'), (44, '猪俣楓芽', 'イノマタフウガ', '2021-04-18', NULL), (45, '野島一之進', 'ノジマイチノシン', '2021-04-23', '福島県'), (46, '齋藤英詩', 'サイトウエイジ', '2021-04-26', '岐阜県'), (47, '西本一咲登', 'ニシモトイサト', '2021-04-28', NULL), (48, '麻生舞桜', 'アソウマオ', '2021-05-04', '宮城県'), (49, '小栗涼楓', 'オグリスズカ', '2021-05-06', NULL), (50, '大高塁', 'オオダカルイ', '2021-05-07', '大阪府'), (51, '小泉香乃羽', 'コイズミカノハ', '2021-05-11', '東京都'), (52, '磯崎風夏', 'イソザキフウカ', '2021-05-12', '香川県'), (53, '船橋櫂晴', 'フナバシカイセイ', '2021-05-13', '沖縄県'), (54, '緒方空光', 'オカタアキラ', '2021-05-13', NULL), (55, '阿久津梓', 'アクツアズサ', '2021-05-15', NULL), (56, '保坂雅夫', 'ホサカマサオ', '2021-05-17', '宮崎県'), (57, '川原紗英', 'カワハラサエ', '2021-05-22', '高知県'), (58, '平尾伊桜里', 'ヒラオイオリ', '2021-05-25', NULL), (59, '宮島源一朗', 'ミヤジマゲンイチロウ', '2021-05-28', '岡山県'), (60, '沢田泰三', 'サワダタイゾウ', '2021-06-10', NULL), (61, '丹野昴宇', 'タンノコウ', '2021-06-11', NULL), (62, '志田友和', 'シダトモカズ', '2021-06-12', '広島県'), (63, '羽鳥こはる', 'ハトリコハル', '2021-06-14', '神奈川県'), (64, '松沢慶福', 'マツザワチカトシ', '2021-06-14', NULL), (65, '蛭田真菜', 'ヒルタマナ', '2021-07-02', '三重県'), (66, '高尾俊治', 'タカオトシハル', '2021-07-05', '北海道'), (67, '畑遥華', 'ハタケハルカ', '2021-07-08', '埼玉県'), (68, '江原朋子', 'エバラトモコ', '2021-07-12', '青森県'), (69, '小栗湊也', 'オグリソウヤ', '2021-07-14', NULL), (70, '大貫公輔', 'オオヌキコウスケ', '2021-07-15', '群馬県'), (71, '岸市都香', 'キシシヅカ', '2021-07-17', '徳島県'), (72, '塩見桜臥', 'シオミオウガ', '2021-08-02', '長崎県'), (73, '日高勇', 'ヒダカイサミ', '2021-08-04', '佐賀県'), (74, '石塚美紅', 'イシヅカミク', '2021-08-05', '岐阜県'), (75, '志田健介', 'シダケンスケ', '2021-08-07', NULL), (76, '佐藤広武', 'サトウヒロム', '2021-08-13', '東京都'), (77, '染谷朝陽', 'ソメヤアサヒ', '2021-08-14', '埼玉県'), (78, '織田諒佑', 'オダリョウスケ', '2021-08-17', '和歌山県'), (79, '矢沢魅李', 'ヤザワカイリ', '2021-08-20', '岐阜県'), (80, '富永直', 'トミナガタダシ', '2021-08-23', '三重県'), (81, '岡茉凛', 'オカマリン', '2021-08-24', '群馬県'), (82, '秋山青空', 'アキヤマセイア', '2021-08-26', '神奈川県'), (83, '稲田明日香', 'イナダアスカ', '2021-09-07', NULL), (84, '深田亜美', 'フカダアミ', '2021-09-10', NULL), (85, '吉井風海香', 'ヨシイフウカ', '2021-10-01', NULL), (86, '島崎亮大', 'シマザキアキヒロ', '2021-10-07', NULL), (87, '坪田海凪', 'ツボタミナギ', '2021-10-08', '佐賀県'), (88, '酒井郁馬', 'サカイイクマ', '2021-10-15', '三重県'), (89, '武内香菜', 'タケウチカナ', '2021-10-15', NULL), (90, '山川壱桜', 'ヤマカワイッサ', '2021-10-15', NULL), (91, '田畑紀信', 'タバタキシン', '2021-10-16', NULL), (92, '亀山理子', 'カメヤマリコ', '2021-10-16', '山梨県'), (93, '倉橋望結', 'クラハシミユ', '2021-10-16', '岩手県'), (94, '伴香月紗', 'バンカヅサ', '2021-10-18', '宮城県'), (95, '長野璃那', 'ナガノリナ', '2021-10-19', '富山県'), (96, '羽鳥冬香', 'ハトリトウカ', '2021-10-19', '宮城県'), (97, '長沢岳斗', 'ナガサワガクト', '2021-10-20', '長崎県'), (98, '岡田重雄', 'オカダシゲオ', '2021-10-29', NULL), (99, '柳瀬信行', 'ヤナセノブユキ', '2021-11-02', '富山県'), (100, '栗山希望', 'クリヤマノゾミ', '2021-11-03', '奈良県'), (101, '野島菜々花', 'ノジマナナカ', '2021-11-04', NULL), (102, '小池紗希乃', 'コイケサキノ', '2021-11-07', '佐賀県'), (103, '窪田精一', 'クボタセイイチ', '2021-11-11', '宮崎県'), (104, '奥村裕晴', 'オクムラユウセイ', '2021-11-19', '鹿児島県'), (105, '石山大周', 'イシヤマタイシュウ', '2021-11-24', NULL), (106, '平林恵茉', 'ヒラバヤシエマ', '2021-12-02', NULL), (107, '北原日和', 'キタハラヒヨリ', '2021-12-03', NULL), (108, '真田聖音', 'サナダセノン', '2021-12-10', '静岡県'), (109, '長岡寛貴', 'ナガオカヒロキ', '2021-12-14', '石川県'), (110, '永山七歌', 'ナガヤマナナカ', '2021-12-14', '鳥取県'), (111, '玉置莉生', 'タマキリオ', '2021-12-15', '埼玉県'), (112, '金城茜', 'カナシロアカネ', '2021-12-19', '広島県'), (113, '春日鈴夏', 'カスガスズカ', '2021-12-19', '岐阜県'), (114, '重松琴', 'シゲマツコト', '2021-12-26', NULL), (115, '田淵一平', 'タブチイッペイ', '2022-01-03', NULL), (116, '花岡衣紅実', 'ハナオカイクミ', '2022-01-05', '鹿児島県'), (117, '菅野五月', 'スガノサツキ', '2022-01-08', '熊本県'), (118, '松川夏希', 'マツカワナツキ', '2022-01-08', '愛媛県'), (119, '成瀬貴理人', 'ナルセキリト', '2022-01-11', NULL), (120, '沼田慶樹', 'ヌマタケイジュ', '2022-01-22', NULL), (121, '藤本天音', 'フジモトアマネ', '2022-01-31', '山形県'), (122, '森川照男', 'モリカワテルオ', '2022-02-09', '鳥取県'), (123, '米倉久遠', 'ヨネクラクオン', '2022-02-11', '群馬県'), (124, '蛭田紫月', 'ヒルタシヅキ', '2022-02-12', '長野県');
CREATE TABLE category(
category_id INTEGER PRIMARY KEY,
name varchar(31) NOT NULL
);
INSERT INTO category VALUES ('1', 'バーガー'), ('2', 'サイドメニュー'), ('3', 'デザート'), ('4', 'ドリンク');
CREATE TABLE menu(
menu_id INTEGER PRIMARY KEY,
category_id INTEGER NOT NULL,
name varchar(31) NOT NULL,
price INTEGER NOT NULL
);
INSERT INTO menu VALUES ('1', '1', 'ハンバーガー', '200'), ('2', '1', 'チーズバーガー', '250'), ('3', '1', 'チキンバーガー', '300'), ('4', '1', 'てりやきバーガー', '330'), ('5', '1', 'フィッシュバーガー', '250'), ('6', '1', 'エビバーガー', '350'), ('7', '1', 'ベーコンチーズバーガー', '350'), ('8', '1', 'ダブルチーズバーガー', '350'), ('9', '1', 'ベーコンエッグバーガー', '330'), ('10', '2', 'フライドポテトS', '150'), ('11', '2', 'フライドポテトM', '250'), ('12', '2', 'フライドポテトL', '300'), ('13', '2', 'バケツポテト', '500'), ('14', '2', 'チキンナゲット', '200'), ('15', '2', 'コーンサラダ', '150'), ('16', '2', 'ハッシュドポテト', '150'), ('17', '3', 'パンケーキ', '250'), ('18', '3', 'ソフトクリーム', '150'), ('19', '3', 'アップルパイ', '150'), ('20', '4', 'コーラ', '250'), ('21', '4', 'メロンソーダ', '250'), ('22', '4', 'クリームソーダ', '350'), ('23', '4', 'オレンジジュース', '250'), ('24', '4', 'アイスティー', '250'), ('25', '4', 'ホットティー', '250'), ('26', '4', 'コーヒー', '250'), ('27', '4', 'バニラシェイク', '300');
- 出力例1
