kauansatc / banco-de-dados-abp

1 stars 0 forks source link

População das tabelas #7

Open tamiriel opened 10 months ago

tamiriel commented 10 months ago

Popular as tabelas conforme revisão do modelo físico

tamiriel commented 10 months ago

SCRIPT INVÁLIDO CONFORME NOVA REVISÃO DE DDL

INSERT INTO [dbo].[cliente] ([codigo_cliente] ,[data_cadastro] ,[nome_cliente] ,[porcentagem_beneficio]) VALUES ('12345678901','2023-11-01','João Silva ',15), ('23456789012','2023-11-02','Maria Santos ',20), ('34567890123','2023-11-03','Pedro Oliveira ',5 ), ('45678901234','2023-11-04','Ana Costa ',5 ), ('56789012345','2023-11-05','Luís Souza ',10), ('67890123456','2023-11-01','Ana Clara Souza ',15), ('78901234567','2023-11-01','Bruno Henrique Silva ',15), ('89012345678','2023-11-02','Carlos Eduardo Santos ',20), ('90123456789','2023-11-03','Daniela Cristina Lima ',5 ), ('12834567890','2023-11-01','Eduardo José Alves ',15), ('13579246801','2023-11-02','Fernanda Maria Oliveira ',5 ), ('24680135792','2023-11-01','Gabriel Luiz Costa ',5 ), ('35792468013','2023-11-02','Helena Beatriz Rocha ',10), ('46801357924','2023-11-03','Igor Rafael Dias ',15), ('57924680135','2023-11-01','Juliana Aparecida Ribeiro ',20), ('68013579246','2023-11-02','Kaique Vinicius Araujo ',5 ), ('79246801357','2023-11-03','Larissa Gabriela Martins ',10), ('80135792468','2023-11-04','Matheus Felipe Gomes ',15), ('92468013579','2023-11-05','Nicole Isabela Barbosa ',20), ('13578924680','2023-11-01','Otávio Lucas Carvalho ',5 ), ('14725836901','2023-11-02','Paula Fernanda Cardoso ',10), ('25836914702','2023-11-01','Rafael Guilherme Nunes ',15), ('36914725803','2023-11-02','Sabrina Vitória Ferreira ',5 ), ('47125836904','2023-11-03','Tiago Henrique Moraes ',5 ), ('58236914705','2023-11-04','Vanessa Carolina Campos ',10), ('69314725806','2023-11-05','Wesley Gabriel Rodrigues ',15), ('71425836907','2023-11-03','Yasmin Luana Almeida ',20), ('82536914708','2023-11-04','Arthur Miguel Pires ',5 ), ('93614725809','2023-11-05','Bianca Letícia Faria ',10), ('41257836910','2023-11-01','Caio Felipe Correia ',15), ('15926374801','2023-11-02','Débora Raquel Teixeira ',20), ('26274815902','2023-11-03','Enzo Gabriel Andrade ',5 ), ('37481592603','2023-11-01','Gabriela Sofia Reis ',10), ('48159263704','2023-11-02','Hugo Leonardo Melo ',15), ('59263748105','2023-11-03','Isabela Alice Moreira ',20), ('63748159206','2023-11-04','João Pedro Fonseca ',5 ), ('74815926307','2023-11-05','Lívia Maria Duarte ',10), ('81592637408','2023-11-01','Marcos Vinicius Freitas ',15), ('92637481509','2023-11-02','Natalia Amanda Marques ',20), ('39748159210','2023-11-03','Pedro Henrique Vieira ',5 ), ('16273849501','2023-11-04','Rafaela Isadora Monteiro ',10), ('27384951602','2023-11-05','Samuel Lucas Batista ',15), ('38495162703','2023-11-01','Thaís Gabriela Lopes ',5 ), ('49516273804','2023-11-02','Victor Hugo Mendes ',5 ), ('51627384905','2023-11-03','Amanda Beatriz Gonçalves ',10), ('62738495106','2023-11-04','Bernardo Gabriel Cunha ',15), ('73849516207','2023-11-05','Camila Eduarda Franco ',15), ('84951627308','2023-11-01','Diego Rafael Leite ',20), ('95162738409','2023-11-02','Emilly Sophia Guimarães ',5 ), ('61738496510','2023-11-03','Felipe Gustavo Nogueira ',15), ('17642589301','2023-11-04','Giovanna Laura Figueiredo ',20), ('28459317602','2023-11-01','Isaac Gabriel Sousa ',5 ), ('42589328403','2023-11-02','Júlia Maria Machado ',10), ('59317642504','2023-11-03','Leonardo Gabriel Pinto ',15), ('89328459305','2023-11-04','Maria Eduarda Ribeiro ',10), ('17642589306','2023-11-05','Nicolas Gabriel Oliveira ',15), ('28459317607','2023-11-01','Renata Vitória Silva ',5 ), ('42589328408','2023-11-02','Thiago Miguel Barbosa ',15), ('59317642509','2023-11-01','Vitoria Luiza Santos ',20), ('89328459310','2023-11-02','Alexsandro Gabriel Souza ',5 ), ('19027364501','2023-11-03','Beatriz Helena Lima ',10), ('27364519002','2023-11-04','Cauã Gabriel Alves ',15), ('64519027303','2023-11-01','Danilo Gabriel Coelho ',20), ('19027364504','2023-11-02','Evelyn Sophia Costa ',15), ('27364519005','2023-11-01','Gabriel Henrique Pereira ',20), ('64519027306','2023-11-02','Isadora Maria Carvalho ',5 ), ('19027364507','2023-11-03','João Lucas Almeida ',10), ('27364519008','2023-11-04','Laura Beatriz Gomes ',15), ('64519027309','2023-11-05','Matheus Gabriel Rocha ',15), ('19027364510','2023-11-01','Pietra Sophia Santos ',15), ('10325476901','2023-11-02','Ryan Gabriel Araujo ',20), ('25476910302','2023-11-03','Sarah Sophia Silva ',5 ), ('76910325403','2023-11-04','Vinicius Gabriel Ferreira ',10), ('10325476904','2023-11-05','Alice Maria Fernandes ',15), ('25476910305','2023-11-01','Breno Gabriel Farias ',15), ('76910325406','2023-11-02','Clara Maria Silva ',20), ('10325476907','2023-11-03','Davi Lucas Lima ',5 ), ('25476910308','2023-11-04','Esther Sophia Oliveira ',15), ('76910325409','2023-11-05','Guilherme Henrique Sousa ',20), ('10325476910','2023-11-01','Isabella Maria Santos ',5 ), ('10987654301','2023-11-02','João Miguel Costa ',10), ('98765430102','2023-11-03','Lorena Maria Alves ',15), ('76543010903','2023-11-04','Miguel Gabriel Dias ',20), ('54301098704','2023-11-05','Rafaela Maria Nunes ',5 ), ('30109876505','2023-11-01','Samuel Gabriel Rodrigues ',10), ('98776543006','2023-11-02','Sophia Maria Ribeiro ',15), ('87654301007','2023-11-03','Yuri Gabriel Souza ',20), ('65430109808','2023-11-04','Ana Julia Santos ',5 ), ('43010987609','2023-11-05','Bruno Gabriel Lima ',10), ('11098765410','2023-11-01','Cecilia Maria Oliveira ',15), ('11098865410','2023-11-02','Enzo Miguel Costa ',20), ('21098765410','2023-11-01','Gabriela Maria Silva ',5 ), ('65142704311','2023-11-02','Henrique Gabriel Almeida ',10), ('14409523492','2023-11-03','Isabelly Maria Araujo ',15), ('80046090089','2023-11-04','João Vitor Ferreira ',15), ('14582656686','2023-11-05','Luiza Maria Gomes ',20), ('21151922328','2023-11-01','Nathan Gabriel Martins ',5 ), ('27725578988','2023-11-02','Rebeca Maria Cardoso ',15), ('34299235648','2023-11-03','Thomas Gabriel Faria ',20), ('48728923074','2023-11-04','Yasmin Maria Souza ',5 ) GO

tamiriel commented 10 months ago

INSERT INTO menu (descricao, preco, nome) VALUES ('Tapioca salgada de queijo', 6.5, 'Tapioca de Queijo'), ('Tapioca salgada de presunto', 6.5, 'Tapioca de Presunto'), ('Tapioca salgada de presunto e queijo', 6.5, 'Tapioca de Presunto e Queijo'), ('Omelete de queijo', 4, 'Omelete com queijo'), ('Omelete de baicon', 6.5, 'Omelete com baicon'), ('Omelete de presunto', 5, 'Omelete com presunto'), ('Croissant de frango', 7, 'Croissant de frango'), ('Croissant de chocolate', 7, 'Croissant de chocolate'), ('Torrada com manteiga', 2.5, 'Torrada com manteiga'), ('Torrada com geleia', 2.5, 'Torrada com geleia'), ('Torrada com requeijão', 2.5, 'Torrada com requeijão'), ('Pão de queijo unidade', 2, 'Pão de queijo'), ('Pão de queijo porção com 6 ', 10, 'Pão de queijo'), ('Café expresso', 5, 'Café expresso'), ('Café com leite', 4, 'Café com leite'), ('Cappuccino', 6, 'Cappuccino'), ('Chocolate quente', 6, 'Chocolate quente'), ('Suco natural de laranja', 3.5, 'Suco de laranja'), ('Suco natural de limão', 3.5, 'Suco de limão'), ('Suco natural de abacaxi', 3.5, 'Suco de abacaxi'), ('Bolo de cenoura - Venda por fatia', 8, 'Bolo de cenoura'), ('Bolo de chocolate - Venda por fatia', 8, 'Bolo de chocolate'), ('Bolo de fubá - Venda por fatia', 8, 'Bolo de fubá'), ('Bolo de limão - Venda por fatia', 8, 'Bolo de limão')

tamiriel commented 10 months ago

@Virtuosinh0 popular as tabelas produto, receita_item_menu, e pedido_menu

Virtuosinh0 commented 10 months ago

Faltou dados da tabela pedido para popular pedido_menu

INSERT INTO dbo.produto (nome, estoque) VALUES ('Água', 100), ('Açúcar', 35.5), ('Café', 18), ('Leite', 20), ('Leite Ninho', 4), ('Farinha de Trigo', 20.75), ('Chocolate em Pó', 15.25), ('Leite Condensado', 25), ('Manteiga', 30.8), ('Ovo', 67), ('Fermento', 1.5), ('Corante Azul', 2), ('Corante Laranja', 1), ('Chocolate em barra', 18.25), ('Avelãs', 22), ('Creme de Leite', 10), ('Castanhas', 19), ('Chantili', 5), ('Tapioca', 10), ('Queijo', 5.8), ('Presunto', 4), ('Limão', 12), ('Laranja', 8), ('Abacaxi', 3), ('Cenoura', 11), ('Torrada', 29), ('Geleia', 9), ('Requeijão', 2), ('Manteiga', 4), ('Bacon', 4), ('Essência de Baunilha', 14.5), ('Frango Desfiado', 10); GO

INSERT INTO receita_item_menu (cod_item_menu, cod_produto, quantidade_produto) VALUES (1, 19, 0.2), (1, 20, 0.2), (2, 19, 0.2), (2, 21, 0.1), (3, 19, 0.2), (3, 20, 0.15), (3, 21, 0.1), (4, 10, 2), (4, 20, 0.25), (5, 10, 2), (5, 30, 0.15), (6, 10, 2), (6, 21, 0.10), (7, 6, 0.5), (7, 32, 0.1), (7, 11, 0.05), (8, 6, 0.5), (8, 11, 0.05), (8, 14, 0.2), (9, 26, 1), (9, 29, 0.05), (10, 26, 1), (10, 27, 0.05), (11, 26, 1), (11, 28, 0.05), (12, 6, 0.5), (12, 11, 0.05), (12, 20, 0.25), (12, 10, 1), (13, 6, 0.5), (13, 11, 0.05), (13, 20, 0.25), (13, 10, 1), (14, 3, 0.08), (14, 1, 0.5), (15, 3, 0.08), (15, 1, 0.4), (15, 4, 0.1), (16, 3, 0.08), (16, 1, 0.4), (16, 5, 0.02), (16, 7, 0.02), (17, 4, 0.4), (17, 7, 0.1), (18, 1, 0.5), (18, 23, 1), (19, 1, 0.5), (19, 22, 0.5), (20, 1, 0.5), (20, 24, 0.25), (21, 6, 0.5), (21, 11, 0.05), (21, 10, 2), (21, 25, 0.5), (22, 6, 0.5), (22, 11, 0.05), (22, 10, 2), (22, 7, 0.5), (23, 6, 0.5), (23, 11, 0.05), (23, 10, 2), (24, 6, 0.5), (24, 11, 0.05), (24, 10, 2), (24, 22, 2); GO

tamiriel commented 10 months ago

INSERT INTO [dbo].[cliente] ([cpf] ,[nome]) VALUES ('12345678901','João Silva'), ('23456789012','Maria Santos'), ('34567890123','Pedro Oliveira'), ('45678901234','Ana Costa'), ('56789012345','Luís Souza'), ('67890123456','Ana Clara Souza'), ('78901234567','Bruno Henrique Silva'), ('89012345678','Carlos Eduardo Santos '), ('90123456789','Daniela Cristina Lima '), ('12834567890','Eduardo José Alves '), ('13579246801','Fernanda Maria Oliveira '), ('24680135792','Gabriel Luiz Costa '), ('35792468013','Helena Beatriz Rocha '), ('46801357924','Igor Rafael Dias '), ('57924680135','Juliana Aparecida Ribeiro '), ('68013579246','Kaique Vinicius Araujo '), ('79246801357','Larissa Gabriela Martins '), ('80135792468','Matheus Felipe Gomes '), ('92468013579','Nicole Isabela Barbosa '), ('13578924680','Otávio Lucas Carvalho '), ('14725836901','Paula Fernanda Cardoso '), ('25836914702','Rafael Guilherme Nunes '), ('36914725803','Sabrina Vitória Ferreira '), ('47125836904','Tiago Henrique Moraes '), ('58236914705','Vanessa Carolina Campos '), ('69314725806','Wesley Gabriel Rodrigues '), ('71425836907','Yasmin Luana Almeida '), ('82536914708','Arthur Miguel Pires '), ('93614725809','Bianca Letícia Faria '), ('41257836910','Caio Felipe Correia '), ('15926374801','Débora Raquel Teixeira '), ('26274815902','Enzo Gabriel Andrade ' ), ('37481592603','Gabriela Sofia Reis '), ('48159263704','Hugo Leonardo Melo '), ('59263748105','Isabela Alice Moreira '), ('63748159206','João Pedro Fonseca '), ('74815926307','Lívia Maria Duarte '), ('81592637408','Marcos Vinicius Freitas '), ('92637481509','Natalia Amanda Marques '), ('39748159210','Pedro Henrique Vieira ' ), ('16273849501','Rafaela Isadora Monteiro '), ('27384951602','Samuel Lucas Batista ' ), ('38495162703','Thaís Gabriela Lopes ' ), ('49516273804','Victor Hugo Mendes ' ), ('51627384905','Amanda Beatriz Gonçalves '), ('62738495106','Bernardo Gabriel Cunha '), ('73849516207','Camila Eduarda Franco ' ), ('84951627308','Diego Rafael Leite ' ), ('95162738409','Emilly Sophia Guimarães '), ('61738496510','Felipe Gustavo Nogueira '), ('17642589301','Giovanna Laura Figueiredo '), ('28459317602','Isaac Gabriel Sousa ' ), ('42589328403','Júlia Maria Machado ' ), ('59317642504','Leonardo Gabriel Pinto '), ('89328459305','Maria Eduarda Ribeiro ' ), ('17642589306','Nicolas Gabriel Oliveira '), ('28459317607','Renata Vitória Silva ' ), ('42589328408','Thiago Miguel Barbosa ' ), ('59317642509','Vitoria Luiza Santos ' ), ('89328459310','Alexsandro Gabriel Souza '), ('19027364501','Beatriz Helena Lima ' ), ('27364519002','Cauã Gabriel Alves ' ), ('64519027303','Danilo Gabriel Coelho ' ), ('19027364504','Evelyn Sophia Costa ' ), ('27364519005','Gabriel Henrique Pereira '), ('64519027306','Isadora Maria Carvalho '), ('19027364507','João Lucas Almeida ' ), ('27364519008','Laura Beatriz Gomes ' ), ('64519027309','Matheus Gabriel Rocha ' ), ('19027364510','Pietra Sophia Santos ' ), ('10325476901','Ryan Gabriel Araujo ' ), ('25476910302','Sarah Sophia Silva ' ), ('76910325403','Vinicius Gabriel Ferreira '), ('10325476904','Alice Maria Fernandes ' ), ('25476910305','Breno Gabriel Farias ' ), ('76910325406','Clara Maria Silva ' ), ('10325476907','Davi Lucas Lima ' ), ('25476910308','Esther Sophia Oliveira '), ('76910325409','Guilherme Henrique Sousa '), ('10325476910','Isabella Maria Santos ' ), ('10987654301','João Miguel Costa ' ), ('98765430102','Lorena Maria Alves ' ), ('76543010903','Miguel Gabriel Dias ' ), ('54301098704','Rafaela Maria Nunes ' ), ('30109876505','Samuel Gabriel Rodrigues '), ('98776543006','Sophia Maria Ribeiro ' ), ('87654301007','Yuri Gabriel Souza ' ), ('65430109808','Ana Julia Santos ' ), ('43010987609','Bruno Gabriel Lima ' ), ('11098765410','Cecilia Maria Oliveira '), ('11098865410','Enzo Miguel Costa ' ), ('21098765410','Gabriela Maria Silva ' ), ('65142704311','Henrique Gabriel Almeida '), ('14409523492','Isabelly Maria Araujo ' ), ('80046090089','João Vitor Ferreira ' ), ('14582656686','Luiza Maria Gomes ' ), ('21151922328','Nathan Gabriel Martins '), ('27725578988','Rebeca Maria Cardoso ' ), ('34299235648','Thomas Gabriel Faria ' ), ('48728923074','Yasmin Maria Souza ' ) GO

LucasMeller13 commented 10 months ago

INSERT INTO pedido (hora_pedido, preco_total, cpf) VALUES ('2023-04-06 10:48:31', 19.09, '12345678901'), ('2023-22-02 11:39:26', 54.06, '79246801357'), ('2023-27-07 15:13:51', 54.46, '92468013579'), ('2023-13-10 16:38:59', 33.28, '26274815902'), ('2023-18-01 09:08:29', 22.68, '26274815902'), ('2023-13-01 15:48:59', 73.43, '59263748105'), ('2023-02-06 17:24:16', 51.76, '81592637408'), ('2023-03-06 09:08:44', 46.77, '62738495106'), ('2023-22-10 17:01:44', 61.42, '17642589306'), ('2023-12-11 11:53:49', 25.99, '89328459310'), ('2023-20-10 11:02:24', 72.97, '79246801357'), ('2023-19-06 11:01:15', 14.48, '19027364507'), ('2023-07-10 10:37:18', 17.49, '30109876505'); go

LucasMeller13 commented 10 months ago

INSERT INTO pagamento (cod_pedido, hora_pagamento, forma_pagamento) VALUES (1,'2023-04-06 10:58:31','c'), (2,'2023-22-02 11:44:26','d'), (3,'2023-27-07 15:40:51','c'), (4,'2023-13-10 17:18:59','d'), (5,'2023-18-01 09:48:29','d'), (6,'2023-13-01 16:18:59','d'), (7,'2023-02-06 17:54:16','c'), (8,'2023-03-06 09:12:44','c'), (9,'2023-22-10 17:10:44','d'), (10,'2023-12-11 12:03:49','c'), (11,'2023-20-10 11:29:24','c'), (12,'2023-19-06 11:13:15','c'), (13,'2023-07-10 10:55:18','d'); go

tamiriel commented 10 months ago

INSERT INTO [dbo].[pedido] ([hora_pedido] ,[preco_total] ,[cpf]) VALUES ('2015-02-19 08:04:40.530', 3.00 ,'21098765410'), ('2015-02-19 08:05:00.843', 8.00 ,'65142704311'), ('2018-04-04 09:49:29.873', 3.00 ,'76543010903'), ('2018-04-04 09:49:35.930', 8.00 ,'54301098704'), ('2018-04-04 09:49:42.493', 17.00 ,'30109876505'), ('2018-04-04 09:49:52.277', 12.00 ,'98776543006'), ('2018-04-04 09:50:02.697', 3.00 ,'87654301007'), ('2018-04-04 09:50:10.433', 8.00 ,'65430109808'), ('2018-04-04 10:12:51.683', 7.50 ,'43010987609'), ('2018-04-04 14:45:20.557', 6.50 ,'10987654301'), ('2018-04-04 15:10:00.110', 4.50 ,'98765430102'), ('2018-08-03 10:44:19.537', 11.00 ,'84951627308'), ('2018-08-03 10:44:19.537', 11.00 ,'54301098704'), ('2018-08-03 10:44:19.537', 3.00 ,'14409523492'), ('2018-08-03 10:44:19.537', 3.00 ,'25476910308'), ('2018-09-22 09:51:34.630', 17.00 ,'64519027309'), ('2018-12-03 16:00:32.923', 11.00 ,'28459317602'), ('2018-12-03 16:00:32.923', 4.50 ,'65430109808'), ('2018-12-03 16:00:32.923', 11.00 ,'27725578988'), ('2018-12-05 12:51:52.897', 11.00 ,'17642589301'), ('2018-12-05 12:51:52.897', 6.50 ,'87654301007'), ('2018-12-05 12:51:52.897', 3.00 ,'21151922328'), ('2019-01-30 08:31:57.117', 3.00 ,'38495162703'), ('2019-01-30 08:31:57.117', 3.00 ,'76910325409'), ('2019-01-30 08:31:57.117', 6.50 ,'25476910302'), ('2019-03-08 14:43:57.133', 7.50 ,'10325476910'), ('2019-05-06 08:48:13.177', 8.00 ,'76910325409'), ('2019-05-20 16:30:57.027', 6.50 ,'14409523492'), ('2019-06-28 08:23:16.370', 12.00 ,'56789012345'), ('2019-10-28 09:07:17.507', 11.00 ,'42589328403'), ('2019-10-28 09:07:17.507', 17.00 ,'43010987609'), ('2019-10-28 09:07:17.507', 11.00 ,'34299235648'), ('2020-01-31 15:38:07.330', 17.00 ,'14409523492'), ('2020-02-14 07:37:18.170', 6.50 ,'56789012345'), ('2020-03-09 14:30:39.587', 6.50 ,'14409523492'), ('2020-04-20 08:35:52.163', 7.50 ,'65142704311'), ('2020-04-23 10:41:47.563', 12.00 ,'12345678901'), ('2020-04-23 10:45:29.623', 12.00 ,'57924680135'), ('2020-04-23 10:55:32.447', 6.50 ,'11098765410'), ('2020-04-23 10:57:01.127', 4.50 ,'67890123456'), ('2020-04-23 10:58:21.387', 12.00 ,'45678901234'), ('2020-04-23 11:03:54.017', 3.00 ,'13578924680'), ('2020-04-23 11:06:15.267', 3.00 ,'36914725803'), ('2020-04-23 11:07:42.180', 6.50 ,'68013579246'), ('2020-04-23 11:12:15.197', 3.00 ,'78901234567'), ('2020-04-23 11:15:48.767', 8.00 ,'89012345678'), ('2020-04-23 11:19:44.163', 12.00 ,'92468013579'), ('2020-04-23 11:20:20.653', 17.00 ,'80135792468'), ('2020-04-23 14:46:56.053', 4.50 ,'80046090089'), ('2020-04-23 14:47:47.827', 3.00 ,'89328459310'), ('2020-04-23 14:48:39.283', 8.00 ,'21151922328'), ('2020-04-23 14:49:36.963', 4.50 ,'80046090089'), ('2020-04-23 14:51:24.100', 3.00 ,'48728923074'), ('2020-04-23 14:59:14.933', 7.50 ,'25476910302'), ('2020-04-23 15:29:26.917', 3.00 ,'67890123456'), ('2020-04-24 08:53:38.940', 4.50 ,'10325476904'), ('2020-05-06 15:51:23.377', 3.00 ,'76910325409'), ('2020-05-21 09:49:20.040', 11.00 ,'95162738409'), ('2020-05-21 09:49:20.040', 6.50 ,'30109876505'), ('2020-05-21 09:49:20.040', 3.00 ,'80046090089'), ('2020-05-21 09:49:20.040', 8.00 ,'25476910305'), ('2020-05-25 15:13:47.197', 10.00 ,'71425836907'), ('2020-05-25 15:14:05.573', 14.50 ,'12345678901'), ('2020-05-25 15:14:21.560', 10.00 ,'41257836910'), ('2020-05-25 15:14:49.970', 10.00 ,'82536914708'), ('2020-05-25 15:15:00.453', 10.00 ,'93614725809'), ('2020-05-25 15:15:07.267', 17.00 ,'78901234567'), ('2020-05-25 15:15:14.127', 11.00 ,'12345678901'), ('2020-05-25 15:15:20.410', 12.00 ,'89012345678'), ('2020-05-25 15:15:28.800', 11.00 ,'12345678901'), ('2020-05-25 15:15:43.303', 6.50 ,'12345678901'), ('2020-05-25 15:15:49.523', 10.00 ,'47125836904'), ('2020-05-25 15:15:55.553', 10.00 ,'58236914705'), ('2020-06-16 10:36:45.320', 11.00 ,'63748159206'), ('2020-06-16 10:36:45.320', 6.50 ,'25476910302'), ('2020-06-16 10:36:45.320', 12.00 ,'34299235648'), ('2020-06-16 14:13:00.400', 11.00 ,'59263748105'), ('2020-06-16 14:13:00.400', 12.00 ,'10325476901'), ('2020-06-16 14:13:00.400', 4.50 ,'25476910305'), ('2020-06-16 14:18:03.130', 11.00 ,'15926374801'), ('2020-06-16 14:18:03.130', 3.00 ,'19027364507'), ('2020-06-16 14:18:03.130', 4.50 ,'64519027306'), ('2020-06-16 14:18:40.610', 17.00 ,'36914725803'), ('2020-06-16 14:18:40.610', 17.00 ,'59317642509'), ('2020-06-16 14:18:40.610', 12.00 ,'25476910308'), ('2020-06-16 14:37:21.183', 8.00 ,'71425836907'), ('2020-06-16 14:37:21.183', 6.50 ,'64519027303'), ('2020-06-16 14:37:21.183', 3.00 ,'27364519002'), ('2020-06-16 14:38:26.970', 11.00 ,'37481592603'), ('2020-06-16 14:38:26.970', 8.00 ,'64519027309'), ('2020-06-16 14:38:26.970', 8.00 ,'10325476907'), ('2020-06-16 14:38:34.567', 12.00 ,'47125836904'), ('2020-06-16 14:38:34.567', 12.00 ,'89328459310'), ('2020-06-16 14:38:34.567', 17.00 ,'27725578988'), ('2020-06-16 14:38:41.990', 11.00 ,'26274815902'), ('2020-06-16 14:38:41.990', 3.00 ,'27364519008'), ('2020-06-16 14:38:41.990', 7.50 ,'11098865410'), ('2020-06-16 14:38:58.257', 3.00 ,'58236914705'), ('2020-06-16 14:38:58.257', 6.50 ,'19027364501'), ('2020-06-16 14:38:58.257', 8.00 ,'48728923074'), ('2020-06-24 10:08:42.717', 11.00 ,'41257836910'), ('2020-06-24 10:08:42.717', 12.00 ,'64519027306'), ('2020-06-24 10:08:42.717', 8.00 ,'21098765410'), ('2020-06-29 15:32:28.097', 11.00 ,'48159263704'), ('2020-06-29 15:32:28.097', 3.00 ,'19027364510'), ('2020-06-29 15:32:28.097', 3.00 ,'76910325406'), ('2020-08-04 01:29:35.220', 4.50 ,'11098865410'), ('2020-08-21 07:56:52.830', 12.00 ,'27384951602'), ('2020-08-21 07:56:52.830', 8.00 ,'25476910308'), ('2020-08-21 07:56:52.830', 12.00 ,'19027364510'), ('2020-08-21 07:57:04.230', 11.00 ,'61738496510'), ('2020-08-21 07:57:04.230', 12.00 ,'98776543006'), ('2020-08-21 07:57:04.230', 8.00 ,'14582656686'), ('2020-08-21 07:57:04.230', 3.00 ,'48728923074'), ('2020-10-21 17:00:39.560', 3.00 ,'14582656686'), ('2020-10-23 15:43:23.947', 6.50 ,'92468013579'), ('2020-12-09 13:51:04.317', 3.00 ,'49516273804'), ('2020-12-09 13:51:04.317', 11.00 ,'10325476910'), ('2020-12-09 13:51:04.317', 4.50 ,'76910325403'), ('2020-12-11 09:10:30.333', 6.50 ,'74815926307'), ('2020-12-11 09:10:30.333', 4.50 ,'76910325403'), ('2020-12-11 09:10:30.333', 17.00 ,'42589328408'), ('2021-02-09 15:31:55.170', 11.00 ,'80135792468'), ('2021-07-15 11:28:38.653', 12.00 ,'13578924680'), ('2021-08-05 15:31:05.710', 10.00 ,'35792468013'), ('2021-11-12 17:48:34.200', 4.50 ,'27725578988'), ('2021-11-19 11:25:31.467', 8.00 ,'13579246801'), ('2021-11-22 15:10:05.340', 3.00 ,'25476910305'), ('2021-12-06 11:00:13.273', 6.50 ,'92637481509'), ('2021-12-06 11:00:13.273', 12.00 ,'25476910305'), ('2021-12-06 11:00:13.273', 12.00 ,'59317642509'), ('2021-12-06 11:00:20.337', 4.50 ,'39748159210'), ('2021-12-06 11:00:20.337', 3.00 ,'76910325406'), ('2021-12-06 11:00:20.337', 12.00 ,'34299235648'), ('2021-12-06 11:00:26.980', 3.00 ,'90123456789'), ('2021-12-06 11:00:32.777', 3.00 ,'12834567890'), ('2022-02-18 09:56:32.187', 3.00 ,'90123456789'), ('2022-03-03 16:45:23.273', 3.00 ,'62738495106'), ('2022-03-03 16:45:23.273', 11.00 ,'98765430102'), ('2022-03-03 16:45:23.273', 12.00 ,'10325476907'), ('2022-04-04 11:54:52.950', 11.00 ,'46801357924'), ('2022-04-05 17:23:43.410', 17.00 ,'16273849501'), ('2022-04-05 17:23:43.410', 3.00 ,'10325476907'), ('2022-04-05 17:23:43.410', 6.50 ,'76910325403'), ('2022-05-11 08:12:59.443', 4.50 ,'54301098704'), ('2022-05-16 09:43:04.760', 6.50 ,'89328459305'), ('2022-05-16 09:43:04.760', 3.00 ,'11098865410'), ('2022-05-16 09:43:12.823', 12.00 ,'17642589306'), ('2022-05-16 09:43:12.823', 3.00 ,'21098765410'), ('2022-05-25 06:45:22.537', 3.00 ,'30109876505'), ('2022-05-27 08:56:10.047', 8.00 ,'98776543006'), ('2022-05-30 10:24:56.200', 10.00 ,'13579246801'), ('2022-06-28 08:29:17.450', 11.00 ,'57924680135'), ('2022-06-30 15:17:06.367', 11.00 ,'73849516207'), ('2022-06-30 15:17:06.367', 11.00 ,'76543010903'), ('2022-06-30 15:17:06.367', 8.00 ,'65142704311'), ('2022-06-30 15:17:06.367', 3.00 ,'10325476904'), ('2022-07-06 10:15:16.013', 12.00 ,'65430109808'), ('2022-07-20 15:32:29.640', 6.50 ,'98765430102'), ('2022-07-26 08:30:55.887', 4.50 ,'34567890123'), ('2022-07-26 08:31:12.187', 17.00 ,'45678901234'), ('2022-08-15 08:23:38.137', 17.00 ,'10325476907'), ('2022-09-20 08:27:51.320', 4.50 ,'25836914702'), ('2022-09-20 08:27:51.320', 4.50 ,'42589328408'), ('2022-09-20 08:27:51.320', 3.00 ,'43010987609'), ('2022-10-03 14:34:15.590', 6.50 ,'21151922328'), ('2022-10-12 16:13:18.613', 8.00 ,'27364519008'), ('2022-10-20 13:48:35.190', 7.50 ,'14582656686'), ('2022-10-24 09:22:55.840', 3.00 ,'43010987609'), ('2022-11-03 10:28:11.773', 3.00 ,'10325476910'), ('2022-11-24 09:44:15.420', 12.00 ,'19027364501'), ('2022-11-28 15:54:17.520', 7.50 ,'98765430102'), ('2022-12-03 10:23:01.950', 7.50 ,'19027364504'), ('2022-12-05 17:07:11.343', 3.00 ,'24680135792'), ('2022-12-09 11:08:51.327', 11.00 ,'35792468013'), ('2022-12-09 11:09:25.610', 3.00 ,'82536914708'), ('2022-12-09 11:09:25.610', 4.50 ,'19027364504'), ('2022-12-09 11:09:25.610', 17.00 ,'87654301007'), ('2023-01-20 14:59:52.110', 8.00 ,'10325476901'), ('2023-01-31 15:30:13.290', 10.00 ,'69314725806'), ('2023-02-17 14:24:02.763', 8.00 ,'51627384905'), ('2023-02-17 14:24:02.763', 11.00 ,'10987654301'), ('2023-02-17 14:24:02.763', 17.00 ,'76910325406'), ('2023-02-28 09:57:22.950', 6.50 ,'34567890123'), ('2023-02-28 09:57:48.170', 3.00 ,'14725836901'), ('2023-02-28 09:59:03.633', 10.00 ,'12834567890'), ('2023-02-28 09:59:31.760', 6.50 ,'23456789012'), ('2023-02-28 09:59:50.653', 11.00 ,'59317642504'), ('2023-02-28 09:59:50.653', 12.00 ,'11098765410'), ('2023-02-28 09:59:50.653', 11.00 ,'48728923074'), ('2023-02-28 10:00:19.907', 11.00 ,'23456789012'), ('2023-02-28 10:00:40.067', 3.00 ,'69314725806'), ('2023-02-28 10:00:40.067', 12.00 ,'27364519002'), ('2023-02-28 10:00:40.067', 4.50 ,'79246801357'), ('2023-02-28 10:00:46.910', 6.50 ,'14725836901'), ('2023-02-28 10:00:46.910', 6.50 ,'28459317607'), ('2023-02-28 10:00:46.910', 8.00 ,'10325476910'), ('2023-02-28 10:00:56.770', 10.00 ,'24680135792'), ('2023-02-28 10:01:13.680', 12.00 ,'81592637408'), ('2023-02-28 10:01:13.680', 17.00 ,'10325476904'), ('2023-02-28 10:01:13.680', 8.00 ,'11098765410'), ('2023-03-01 11:31:36.530', 11.00 ,'68013579246'), ('2023-03-06 11:56:51.760', 11.00 ,'79246801357'), ('2023-03-16 10:44:16.520', 12.00 ,'87654301007'), ('2023-03-20 07:09:04.167', 8.00 ,'11098765410'), ('2023-03-20 12:46:07.517', 3.00 ,'19027364507'), ('2023-03-28 15:48:27.653', 8.00 ,'80046090089'), ('2023-03-29 16:58:32.170', 6.50 ,'46801357924'), ('2023-03-30 11:05:59.710', 8.00 ,'25836914702'), ('2023-04-12 17:04:29.397', 11.00 ,'93614725809'), ('2023-04-12 17:04:29.397', 17.00 ,'27364519005'), ('2023-04-12 17:04:29.397', 17.00 ,'27725578988'), ('2023-04-19 10:39:43.827', 6.50 ,'27364519005'), ('2023-05-23 11:43:19.080', 8.00 ,'11098865410'), ('2023-05-23 23:48:10.150', 8.00 ,'10987654301'), ('2023-06-02 13:34:56.463', 3.00 ,'14582656686'), ('2023-06-06 08:11:02.960', 8.00 ,'30109876505'), ('2023-06-25 13:26:35.230', 8.00 ,'64519027303'), ('2023-06-30 09:48:05.533', 8.00 ,'76910325406'), ('2023-07-13 09:26:54.790', 7.50 ,'65142704311'), ('2023-07-13 11:21:57.157', 8.00 ,'21098765410'), ('2023-07-15 04:04:29.980', 3.00 ,'34299235648'), ('2023-07-19 22:10:00.283', 6.50 ,'76543010903'), ('2023-07-20 06:45:55.600', 7.50 ,'10987654301'), ('2023-07-20 06:46:55.713', 17.00 ,'25476910308'), ('2023-07-20 10:45:29.180', 12.00 ,'76910325409'), ('2023-07-21 08:28:52.403', 3.00 ,'54301098704'), ('2023-07-24 14:16:32.040', 8.00 ,'21151922328'), ('2023-07-26 18:07:11.537', 6.50 ,'10325476904'), ('2023-07-31 06:39:31.043', 3.00 ,'65430109808'), ('2023-07-31 06:39:43.500', 17.00 ,'98776543006'), ('2023-09-07 10:45:07.700', 4.50 ,'76543010903') GO

tamiriel commented 10 months ago

INSERT INTO [dbo].[pedido_menu] ([cod_pedido] ,[cod_item_menu] ,[quantidade]) VALUES (1, 1, 1), (2, 1, 2), (3, 3, 3), (4, 4, 1), (5, 5, 2), (6, 5, 3), (7, 5, 1), (8, 4, 2), (9, 5, 3), (10, 6, 1), (11, 7, 2), (12, 8, 3), (13, 9, 1), (14, 10, 2), (15, 11, 3), (16, 12, 1), (17, 13, 2), (18, 6, 3), (19, 7, 1), (20, 8, 2), (21, 9, 3), (22, 10, 1), (23, 11, 2), (24, 12, 3), (25, 13, 1), (26, 14, 2), (27, 15, 3), (28, 16, 1), (29, 17, 2), (30, 18, 3), (31, 19, 1), (32, 20, 2), (33, 21, 3), (34, 22, 1), (35, 23, 2), (36, 24, 3), (37, 15, 1), (38, 16, 2), (39, 17, 3), (40, 4, 1), (41, 5, 2), (42, 6, 3), (43, 7, 1), (44, 8, 2), (45, 9, 3), (46, 10, 1), (47, 4, 2), (48, 5, 3), (49, 6, 1), (50, 7, 2), (51, 8, 3), (52, 9, 1), (53, 10, 2), (54, 11, 3), (55, 12, 1), (56, 13, 2), (57, 18, 3), (58, 19, 1), (59, 20, 2), (60, 21, 3), (61, 22, 1), (62, 23, 2), (63, 24, 3), (64, 1, 1), (65, 2, 2), (66, 3, 3), (67, 4, 1), (68, 5, 2), (69, 6, 3), (70, 4, 1), (71, 5, 2), (72, 6, 3), (73, 7, 1), (74, 8, 2), (75, 9, 3), (76, 10, 1), (77, 11, 2), (78, 12, 3), (79, 13, 1), (80, 17, 2), (81, 18, 3), (82, 19, 1), (83, 20, 2), (84, 21, 3), (85, 22, 1), (86, 23, 2), (87, 24, 3), (88, 1, 1), (89, 2, 2), (90, 3, 3), (91, 4, 1), (92, 4, 2), (93, 5, 3), (94, 6, 1), (95, 7, 2), (96, 8, 3), (97, 9, 1), (98, 10, 2), (99, 11,3), (100, 12,1), (101, 13,2), (102, 15,3), (103, 16,1), (104, 17,2), (105, 18,3), (106, 19,1), (107, 20,2), (108, 21,3), (109, 22,1), (110, 23,2), (111, 24,3), (112, 1, 1), (113, 4, 2), (114, 5, 3), (115, 6, 1), (116, 7, 2), (117, 8, 3), (118, 9, 1), (119, 10,2), (120, 11,3), (121, 12,1), (122, 13,2), (123, 12,3), (124, 13,1), (125, 14,2), (126, 15,3), (127, 16,1), (128, 17,2), (129, 18,3), (130, 19,1), (131, 20,2), (132, 4, 3), (133, 5, 1), (134, 6, 2), (135, 7, 3), (136, 8, 1), (137, 9, 2), (138, 10,3), (139, 11,1), (140, 12,2), (141, 13,3), (142, 7, 1), (143, 8, 2), (144, 9, 3), (145, 10,1), (146, 11,2), (147, 12,3), (148, 13,1), (149, 14,2), (150, 15,3), (151, 16,1), (152, 17,2), (153, 18,3), (154, 19,1), (155, 20,2), (156, 21,3), (157, 22,1), (158, 23,2), (159, 24,3), (160, 11,1), (161, 12,2), (162, 13,3), (163, 7, 1), (164, 8, 2), (165, 9, 3), (166, 10,1), (167, 11,2), (168, 12,3), (169,13, 1), (170,11, 2), (171,12, 3), (172,13, 1), (173,14, 2), (174,15, 3), (175,16, 1), (176,17, 2), (177,18, 3), (178,19, 1), (179,20, 2), (180,21, 3), (181,22, 1), (182,23, 2), (183,24, 3), (184,1, 1), (185,2, 2), (186,3, 3), (187,4, 1), (188,11, 2), (189,12, 3), (190,13, 1), (191,7, 2), (192,8, 3), (193,9, 1), (194,10, 2), (195,11, 3), (196,12, 1), (197,13, 2), (198,15, 3), (199,16, 1), (200,17, 2), (201,18, 3), (202,19, 1), (203,20, 2), (204,21, 3), (205,22, 1), (206,23, 2), (207,24, 3), (208,1, 1), (209,10, 2), (210,11, 3), (211,12, 1), (212,13, 2), (213,15, 3), (214,16, 1), (215,17, 2), (216,18, 3), (217,19, 1), (218,8, 2), (219,9, 3), (220,10, 1), (221,11, 2), (222,12, 3), (223,13, 1), (224,14, 2), (225,15, 3), (226,10, 1), (227,11, 2), (228,12, 3), (229,13, 1), (230,15, 2), (231,16, 3), (232,17, 1), (233,18, 2)
GO

tamiriel commented 10 months ago

('2015-19-02 08:04:40.530', 3.00 ,'21098765410'), ('2015-19-02 08:05:00.843', 8.00 ,'65142704311'), ('2018-04-04 09:49:29.873', 3.00 ,'76543010903'), ('2018-04-04 09:49:35.930', 8.00 ,'54301098704'), ('2018-04-04 09:49:42.493', 17.00 ,'30109876505'), ('2018-04-04 09:49:52.277', 12.00 ,'98776543006'), ('2018-04-04 09:50:02.697', 3.00 ,'87654301007'), ('2018-04-04 09:50:10.433', 8.00 ,'65430109808'), ('2018-04-04 10:12:51.683', 7.50 ,'43010987609'), ('2018-04-04 14:45:20.557', 6.50 ,'10987654301'), ('2018-04-04 15:10:00.110', 4.50 ,'98765430102'), ('2018-03-08 10:44:19.537', 11.00 ,'84951627308'), ('2018-03-08 10:44:19.537', 11.00 ,'54301098704'), ('2018-03-08 10:44:19.537', 3.00 ,'14409523492'), ('2018-03-08 10:44:19.537', 3.00 ,'25476910308'), ('2018-22-09 09:51:34.630', 17.00 ,'64519027309'), ('2018-03-12 16:00:32.923', 11.00 ,'28459317602'), ('2018-03-12 16:00:32.923', 4.50 ,'65430109808'), ('2018-03-12 16:00:32.923', 11.00 ,'27725578988'), ('2018-05-12 12:51:52.897', 11.00 ,'17642589301'), ('2018-05-12 12:51:52.897', 6.50 ,'87654301007'), ('2018-05-12 12:51:52.897', 3.00 ,'21151922328'), ('2019-30-01 08:31:57.117', 3.00 ,'38495162703'), ('2019-30-01 08:31:57.117', 3.00 ,'76910325409'), ('2019-30-01 08:31:57.117', 6.50 ,'25476910302'), ('2019-08-03 14:43:57.133', 7.50 ,'10325476910'), ('2019-06-05 08:48:13.177', 8.00 ,'76910325409'), ('2019-20-05 16:30:57.027', 6.50 ,'14409523492'), ('2019-28-06 08:23:16.370', 12.00 ,'56789012345'), ('2019-28-10 09:07:17.507', 11.00 ,'42589328403'), ('2019-28-10 09:07:17.507', 17.00 ,'43010987609'), ('2019-28-10 09:07:17.507', 11.00 ,'34299235648'), ('2020-31-01 15:38:07.330', 17.00 ,'14409523492'), ('2020-14-02 07:37:18.170', 6.50 ,'56789012345'), ('2020-09-03 14:30:39.587', 6.50 ,'14409523492'), ('2020-20-04 08:35:52.163', 7.50 ,'65142704311'), ('2020-23-04 10:41:47.563', 12.00 ,'12345678901'), ('2020-23-04 10:45:29.623', 12.00 ,'57924680135'), ('2020-23-04 10:55:32.447', 6.50 ,'11098765410'), ('2020-23-04 10:57:01.127', 4.50 ,'67890123456'), ('2020-23-04 10:58:21.387', 12.00 ,'45678901234'), ('2020-23-04 11:03:54.017', 3.00 ,'13578924680'), ('2020-23-04 11:06:15.267', 3.00 ,'36914725803'), ('2020-23-04 11:07:42.180', 6.50 ,'68013579246'), ('2020-23-04 11:12:15.197', 3.00 ,'78901234567'), ('2020-23-04 11:15:48.767', 8.00 ,'89012345678'), ('2020-23-04 11:19:44.163', 12.00 ,'92468013579'), ('2020-23-04 11:20:20.653', 17.00 ,'80135792468'), ('2020-23-04 14:46:56.053', 4.50 ,'80046090089'), ('2020-23-04 14:47:47.827', 3.00 ,'89328459310'), ('2020-23-04 14:48:39.283', 8.00 ,'21151922328'), ('2020-23-04 14:49:36.963', 4.50 ,'80046090089'), ('2020-23-04 14:51:24.100', 3.00 ,'48728923074'), ('2020-23-04 14:59:14.933', 7.50 ,'25476910302'), ('2020-23-04 15:29:26.917', 3.00 ,'67890123456'), ('2020-24-04 08:53:38.940', 4.50 ,'10325476904'), ('2020-06-05 15:51:23.377', 3.00 ,'76910325409'), ('2020-21-05 09:49:20.040', 11.00 ,'95162738409'), ('2020-21-05 09:49:20.040', 6.50 ,'30109876505'), ('2020-21-05 09:49:20.040', 3.00 ,'80046090089'), ('2020-21-05 09:49:20.040', 8.00 ,'25476910305'), ('2020-25-05 15:13:47.197', 10.00 ,'71425836907'), ('2020-25-05 15:14:05.573', 14.50 ,'12345678901'), ('2020-25-05 15:14:21.560', 10.00 ,'41257836910'), ('2020-25-05 15:14:49.970', 10.00 ,'82536914708'), ('2020-25-05 15:15:00.453', 10.00 ,'93614725809'), ('2020-25-05 15:15:07.267', 17.00 ,'78901234567'), ('2020-25-05 15:15:14.127', 11.00 ,'12345678901'), ('2020-25-05 15:15:20.410', 12.00 ,'89012345678'), ('2020-25-05 15:15:28.800', 11.00 ,'12345678901'), ('2020-25-05 15:15:43.303', 6.50 ,'12345678901'), ('2020-25-05 15:15:49.523', 10.00 ,'47125836904'), ('2020-25-05 15:15:55.553', 10.00 ,'58236914705'), ('2020-16-06 10:36:45.320', 11.00 ,'63748159206'), ('2020-16-06 10:36:45.320', 6.50 ,'25476910302'), ('2020-16-06 10:36:45.320', 12.00 ,'34299235648'), ('2020-16-06 14:13:00.400', 11.00 ,'59263748105'), ('2020-16-06 14:13:00.400', 12.00 ,'10325476901'), ('2020-16-06 14:13:00.400', 4.50 ,'25476910305'), ('2020-16-06 14:18:03.130', 11.00 ,'15926374801'), ('2020-16-06 14:18:03.130', 3.00 ,'19027364507'), ('2020-16-06 14:18:03.130', 4.50 ,'64519027306'), ('2020-16-06 14:18:40.610', 17.00 ,'36914725803'), ('2020-16-06 14:18:40.610', 17.00 ,'59317642509'), ('2020-16-06 14:18:40.610', 12.00 ,'25476910308'), ('2020-16-06 14:37:21.183', 8.00 ,'71425836907'), ('2020-16-06 14:37:21.183', 6.50 ,'64519027303'), ('2020-16-06 14:37:21.183', 3.00 ,'27364519002'), ('2020-16-06 14:38:26.970', 11.00 ,'37481592603'), ('2020-16-06 14:38:26.970', 8.00 ,'64519027309'), ('2020-16-06 14:38:26.970', 8.00 ,'10325476907'), ('2020-16-06 14:38:34.567', 12.00 ,'47125836904'), ('2020-16-06 14:38:34.567', 12.00 ,'89328459310'), ('2020-16-06 14:38:34.567', 17.00 ,'27725578988'), ('2020-16-06 14:38:41.990', 11.00 ,'26274815902'), ('2020-16-06 14:38:41.990', 3.00 ,'27364519008'), ('2020-16-06 14:38:41.990', 7.50 ,'11098865410'), ('2020-16-06 14:38:58.257', 3.00 ,'58236914705'), ('2020-16-06 14:38:58.257', 6.50 ,'19027364501'), ('2020-16-06 14:38:58.257', 8.00 ,'48728923074'), ('2020-24-06 10:08:42.717', 11.00 ,'41257836910'), ('2020-24-06 10:08:42.717', 12.00 ,'64519027306'), ('2020-24-06 10:08:42.717', 8.00 ,'21098765410'), ('2020-29-06 15:32:28.097', 11.00 ,'48159263704'), ('2020-29-06 15:32:28.097', 3.00 ,'19027364510'), ('2020-29-06 15:32:28.097', 3.00 ,'76910325406'), ('2020-04-08 01:29:35.220', 4.50 ,'11098865410'), ('2020-21-08 07:56:52.830', 12.00 ,'27384951602'), ('2020-21-08 07:56:52.830', 8.00 ,'25476910308'), ('2020-21-08 07:56:52.830', 12.00 ,'19027364510'), ('2020-21-08 07:57:04.230', 11.00 ,'61738496510'), ('2020-21-08 07:57:04.230', 12.00 ,'98776543006'), ('2020-21-08 07:57:04.230', 8.00 ,'14582656686'), ('2020-21-08 07:57:04.230', 3.00 ,'48728923074'), ('2020-21-10 17:00:39.560', 3.00 ,'14582656686'), ('2020-23-10 15:43:23.947', 6.50 ,'92468013579'), ('2020-09-12 13:51:04.317', 3.00 ,'49516273804'), ('2020-09-12 13:51:04.317', 11.00 ,'10325476910'), ('2020-09-12 13:51:04.317', 4.50 ,'76910325403'), ('2020-11-12 09:10:30.333', 6.50 ,'74815926307'), ('2020-11-12 09:10:30.333', 4.50 ,'76910325403'), ('2020-11-12 09:10:30.333', 17.00 ,'42589328408'), ('2021-09-02 15:31:55.170', 11.00 ,'80135792468'), ('2021-15-07 11:28:38.653', 12.00 ,'13578924680'), ('2021-05-08 15:31:05.710', 10.00 ,'35792468013'), ('2021-12-11 17:48:34.200', 4.50 ,'27725578988'), ('2021-19-11 11:25:31.467', 8.00 ,'13579246801'), ('2021-22-11 15:10:05.340', 3.00 ,'25476910305'), ('2021-06-12 11:00:13.273', 6.50 ,'92637481509'), ('2021-06-12 11:00:13.273', 12.00 ,'25476910305'), ('2021-06-12 11:00:13.273', 12.00 ,'59317642509'), ('2021-06-12 11:00:20.337', 4.50 ,'39748159210'), ('2021-06-12 11:00:20.337', 3.00 ,'76910325406'), ('2021-06-12 11:00:20.337', 12.00 ,'34299235648'), ('2021-06-12 11:00:26.980', 3.00 ,'90123456789'), ('2021-06-12 11:00:32.777', 3.00 ,'12834567890'), ('2022-18-02 09:56:32.187', 3.00 ,'90123456789'), ('2022-03-03 16:45:23.273', 3.00 ,'62738495106'), ('2022-03-03 16:45:23.273', 11.00 ,'98765430102'), ('2022-03-03 16:45:23.273', 12.00 ,'10325476907'), ('2022-04-04 11:54:52.950', 11.00 ,'46801357924'), ('2022-05-04 17:23:43.410', 17.00 ,'16273849501'), ('2022-05-04 17:23:43.410', 3.00 ,'10325476907'), ('2022-05-04 17:23:43.410', 6.50 ,'76910325403'), ('2022-11-05 08:12:59.443', 4.50 ,'54301098704'), ('2022-16-05 09:43:04.760', 6.50 ,'89328459305'), ('2022-16-05 09:43:04.760', 3.00 ,'11098865410'), ('2022-16-05 09:43:12.823', 12.00 ,'17642589306'), ('2022-16-05 09:43:12.823', 3.00 ,'21098765410'), ('2022-25-05 06:45:22.537', 3.00 ,'30109876505'), ('2022-27-05 08:56:10.047', 8.00 ,'98776543006'), ('2022-30-05 10:24:56.200', 10.00 ,'13579246801'), ('2022-28-06 08:29:17.450', 11.00 ,'57924680135'), ('2022-30-06 15:17:06.367', 11.00 ,'73849516207'), ('2022-30-06 15:17:06.367', 11.00 ,'76543010903'), ('2022-30-06 15:17:06.367', 8.00 ,'65142704311'), ('2022-30-06 15:17:06.367', 3.00 ,'10325476904'), ('2022-06-07 10:15:16.013', 12.00 ,'65430109808'), ('2022-20-07 15:32:29.640', 6.50 ,'98765430102'), ('2022-26-07 08:30:55.887', 4.50 ,'34567890123'), ('2022-26-07 08:31:12.187', 17.00 ,'45678901234'), ('2022-15-08 08:23:38.137', 17.00 ,'10325476907'), ('2022-20-09 08:27:51.320', 4.50 ,'25836914702'), ('2022-20-09 08:27:51.320', 4.50 ,'42589328408'), ('2022-20-09 08:27:51.320', 3.00 ,'43010987609'), ('2022-03-10 14:34:15.590', 6.50 ,'21151922328'), ('2022-12-10 16:13:18.613', 8.00 ,'27364519008'), ('2022-20-10 13:48:35.190', 7.50 ,'14582656686'), ('2022-24-10 09:22:55.840', 3.00 ,'43010987609'), ('2022-03-11 10:28:11.773', 3.00 ,'10325476910'), ('2022-24-11 09:44:15.420', 12.00 ,'19027364501'), ('2022-28-11 15:54:17.520', 7.50 ,'98765430102'), ('2022-03-12 10:23:01.950', 7.50 ,'19027364504'), ('2022-05-12 17:07:11.343', 3.00 ,'24680135792'), ('2022-09-12 11:08:51.327', 11.00 ,'35792468013'), ('2022-09-12 11:09:25.610', 3.00 ,'82536914708'), ('2022-09-12 11:09:25.610', 4.50 ,'19027364504'), ('2022-09-12 11:09:25.610', 17.00 ,'87654301007'), ('2023-20-01 14:59:52.110', 8.00 ,'10325476901'), ('2023-31-01 15:30:13.290', 10.00 ,'69314725806'), ('2023-17-02 14:24:02.763', 8.00 ,'51627384905'), ('2023-17-02 14:24:02.763', 11.00 ,'10987654301'), ('2023-17-02 14:24:02.763', 17.00 ,'76910325406'), ('2023-28-02 09:57:22.950', 6.50 ,'34567890123'), ('2023-28-02 09:57:48.170', 3.00 ,'14725836901'), ('2023-28-02 09:59:03.633', 10.00 ,'12834567890'), ('2023-28-02 09:59:31.760', 6.50 ,'23456789012'), ('2023-28-02 09:59:50.653', 11.00 ,'59317642504'), ('2023-28-02 09:59:50.653', 12.00 ,'11098765410'), ('2023-28-02 09:59:50.653', 11.00 ,'48728923074'), ('2023-28-02 10:00:19.907', 11.00 ,'23456789012'), ('2023-28-02 10:00:40.067', 3.00 ,'69314725806'), ('2023-28-02 10:00:40.067', 12.00 ,'27364519002'), ('2023-28-02 10:00:40.067', 4.50 ,'79246801357'), ('2023-28-02 10:00:46.910', 6.50 ,'14725836901'), ('2023-28-02 10:00:46.910', 6.50 ,'28459317607'), ('2023-28-02 10:00:46.910', 8.00 ,'10325476910'), ('2023-28-02 10:00:56.770', 10.00 ,'24680135792'), ('2023-28-02 10:01:13.680', 12.00 ,'81592637408'), ('2023-28-02 10:01:13.680', 17.00 ,'10325476904'), ('2023-28-02 10:01:13.680', 8.00 ,'11098765410'), ('2023-01-03 11:31:36.530', 11.00 ,'68013579246'), ('2023-06-03 11:56:51.760', 11.00 ,'79246801357'), ('2023-16-03 10:44:16.520', 12.00 ,'87654301007'), ('2023-20-03 07:09:04.167', 8.00 ,'11098765410'), ('2023-20-03 12:46:07.517', 3.00 ,'19027364507'), ('2023-28-03 15:48:27.653', 8.00 ,'80046090089'), ('2023-29-03 16:58:32.170', 6.50 ,'46801357924'), ('2023-30-03 11:05:59.710', 8.00 ,'25836914702'), ('2023-12-04 17:04:29.397', 11.00 ,'93614725809'), ('2023-12-04 17:04:29.397', 17.00 ,'27364519005'), ('2023-12-04 17:04:29.397', 17.00 ,'27725578988'), ('2023-19-04 10:39:43.827', 6.50 ,'27364519005'), ('2023-23-05 11:43:19.080', 8.00 ,'11098865410'), ('2023-23-05 23:48:10.150', 8.00 ,'10987654301'), ('2023-02-06 13:34:56.463', 3.00 ,'14582656686'), ('2023-06-06 08:11:02.960', 8.00 ,'30109876505'), ('2023-25-06 13:26:35.230', 8.00 ,'64519027303'), ('2023-30-06 09:48:05.533', 8.00 ,'76910325406'), ('2023-13-07 09:26:54.790', 7.50 ,'65142704311'), ('2023-13-07 11:21:57.157', 8.00 ,'21098765410'), ('2023-15-07 04:04:29.980', 3.00 ,'34299235648'), ('2023-19-07 22:10:00.283', 6.50 ,'76543010903'), ('2023-20-07 06:45:55.600', 7.50 ,'10987654301'), ('2023-20-07 06:46:55.713', 17.00 ,'25476910308'), ('2023-20-07 10:45:29.180', 12.00 ,'76910325409'), ('2023-21-07 08:28:52.403', 3.00 ,'54301098704'), ('2023-24-07 14:16:32.040', 8.00 ,'21151922328'), ('2023-26-07 18:07:11.537', 6.50 ,'10325476904'), ('2023-31-07 06:39:31.043', 3.00 ,'65430109808'), ('2023-31-07 06:39:43.500', 17.00 ,'98776543006'), ('2023-07-09 10:45:07.700', 4.50 ,'76543010903')

tamiriel commented 10 months ago

INSERT INTO [dbo].[avaliacao] ([cod_avaliacao] ,[hora_avaliacao] ,[valor_pontuacao] ,[comentario] ,[cod_pagamento]) VALUES (1,'2015-19-02 08:04:40.530', 10, NULL,1), (2,'2018-05-12 12:51:52.897', 7, NULL,20), (3,'2018-05-12 12:51:52.897', 8, NULL,21), (4,'2020-23-04 14:47:47.827', 5, 'da pra melhorar',50), (5,'2020-23-04 15:29:26.917', 6, NULL,55), (6,'2020-21-05 09:49:20.040', 4, 'péssimo atendimento',60), (7,'2020-25-05 15:15:00.453', 9, NULL,66), (8,'2020-25-05 15:15:28.800', 10, NULL,70), (9,'2020-25-05 15:15:49.523', 10, 'muito bom',72), (10,'2020-16-06 14:18:03.130', 9, NULL,80), (11,'2020-24-06 10:08:42.717', 8, NULL,101), (12,'2015-19-02 08:04:40.530', 9, NULL,102), (13,'2020-24-06 10:08:42.717', 10, 'Comida ótima',110), (14,'2020-24-06 10:08:42.717', 10, NULL,150), (15,'2020-29-06 15:32:28.097', 10, NULL,180), (16,'2020-29-06 15:32:28.097', 9, NULL,190), (17,'2020-29-06 15:32:28.097', 10, 'ótimo atendimento, e a comida estava ótima',196), (18,'2020-04-08 01:29:35.220', 8, NULL,207), (19,'2020-21-08 07:56:52.830', 9, NULL,225), (20,'2020-21-08 07:56:52.830', 10, NULL,233) GO

tamiriel commented 10 months ago

INSERT INTO [dbo].[pagamento] ([cod_pedido] ,[hora_pagamento] ,[forma_pagamento]) VALUES (1, '2015-19-02 08:04:40.530' , 'C'), (2, '2015-19-02 08:05:00.843' , 'C'), (3, '2018-04-04 09:49:29.873' , 'C'), (4, '2018-04-04 09:49:35.930' , 'C'), (5, '2018-04-04 09:49:42.493' , 'C'), (6, '2018-04-04 09:49:52.277' , 'C'), (7, '2018-04-04 09:50:02.697' , 'C'), (8, '2018-04-04 09:50:10.433' , 'C'), (9, '2018-04-04 10:12:51.683' , 'C'), (10, '2018-04-04 14:45:20.557', 'C'), (11, '2018-04-04 15:10:00.110', 'C'), (12, '2018-03-08 10:44:19.537', 'C'), (13, '2018-03-08 10:44:19.537', 'C'), (14, '2018-03-08 10:44:19.537', 'C'), (15, '2018-03-08 10:44:19.537', 'C'), (16, '2018-22-09 09:51:34.630', 'C'), (17, '2018-03-12 16:00:32.923', 'C'), (18, '2018-03-12 16:00:32.923', 'C'), (19, '2018-03-12 16:00:32.923', 'C'), (20, '2018-05-12 12:51:52.897', 'C'), (21, '2018-05-12 12:51:52.897', 'C'), (22, '2018-05-12 12:51:52.897', 'D'), (23, '2019-30-01 08:31:57.117', 'D'), (24, '2019-30-01 08:31:57.117', 'D'), (25, '2019-30-01 08:31:57.117', 'D'), (26, '2019-08-03 14:43:57.133', 'D'), (27, '2019-06-05 08:48:13.177', 'D'), (28, '2019-20-05 16:30:57.027', 'D'), (29, '2019-28-06 08:23:16.370', 'D'), (30, '2019-28-10 09:07:17.507', 'D'), (31, '2019-28-10 09:07:17.507', 'D'), (32, '2019-28-10 09:07:17.507', 'D'), (33, '2020-31-01 15:38:07.330', 'D'), (34, '2020-14-02 07:37:18.170', 'D'), (35, '2020-09-03 14:30:39.587', 'D'), (36, '2020-20-04 08:35:52.163', 'D'), (37, '2020-23-04 10:41:47.563', 'D'), (38, '2020-23-04 10:45:29.623', 'D'), (39, '2020-23-04 10:55:32.447', 'D'), (40, '2020-23-04 10:57:01.127', 'D'), (41, '2020-23-04 10:58:21.387', 'D'), (42, '2020-23-04 11:03:54.017', 'D'), (43, '2020-23-04 11:06:15.267', 'D'), (44, '2020-23-04 11:07:42.180', 'C'), (45, '2020-23-04 11:12:15.197', 'C'), (46, '2020-23-04 11:15:48.767', 'C'), (47, '2020-23-04 11:19:44.163', 'C'), (48, '2020-23-04 11:20:20.653', 'C'), (49, '2020-23-04 14:46:56.053', 'C'), (50, '2020-23-04 14:47:47.827', 'C'), (51, '2020-23-04 14:48:39.283', 'C'), (52, '2020-23-04 14:49:36.963', 'C'), (53, '2020-23-04 14:51:24.100', 'C'), (54, '2020-23-04 14:59:14.933', 'C'), (55, '2020-23-04 15:29:26.917', 'C'), (56, '2020-24-04 08:53:38.940', 'C'), (57, '2020-06-05 15:51:23.377', 'C'), (58, '2020-21-05 09:49:20.040', 'C'), (59, '2020-21-05 09:49:20.040', 'C'), (60, '2020-21-05 09:49:20.040', 'C'), (61, '2020-21-05 09:49:20.040', 'C'), (62, '2020-25-05 15:13:47.197', 'C'), (63, '2020-25-05 15:14:05.573', 'D'), (64, '2020-25-05 15:14:21.560', 'D'), (65, '2020-25-05 15:14:49.970', 'D'), (66, '2020-25-05 15:15:00.453', 'D'), (67, '2020-25-05 15:15:07.267', 'D'), (68, '2020-25-05 15:15:14.127', 'D'), (69, '2020-25-05 15:15:20.410', 'D'), (70, '2020-25-05 15:15:28.800', 'D'), (71, '2020-25-05 15:15:43.303', 'D'), (72, '2020-25-05 15:15:49.523', 'D'), (73, '2020-25-05 15:15:55.553', 'D'), (74, '2020-16-06 10:36:45.320', 'D'), (75, '2020-16-06 10:36:45.320', 'D'), (76, '2020-16-06 10:36:45.320', 'C'), (77, '2020-16-06 14:13:00.400', 'C'), (78, '2020-16-06 14:13:00.400', 'D'), (79, '2020-16-06 14:13:00.400', 'C'), (80, '2020-16-06 14:18:03.130', 'C'), (81, '2020-16-06 14:18:03.130', 'D'), (82, '2020-16-06 14:18:03.130', 'C'), (83, '2020-16-06 14:18:40.610', 'C'), (84, '2020-16-06 14:18:40.610', 'D'), (85, '2020-16-06 14:18:40.610', 'C'), (86, '2020-16-06 14:37:21.183', 'C'), (87, '2020-16-06 14:37:21.183', 'D'), (88, '2020-16-06 14:37:21.183', 'C'), (89, '2020-16-06 14:38:26.970', 'C'), (90, '2020-16-06 14:38:26.970', 'D'), (91, '2020-16-06 14:38:26.970', 'C'), (92, '2020-16-06 14:38:34.567', 'C'), (93, '2020-16-06 14:38:34.567', 'D'), (94, '2020-16-06 14:38:34.567', 'C'), (95, '2020-16-06 14:38:41.990', 'C'), (96, '2020-16-06 14:38:41.990', 'D'), (97, '2020-16-06 14:38:41.990', 'C'), (98, '2020-16-06 14:38:58.257', 'C'), (99, '2020-16-06 14:38:58.257', 'D'), (100,'2020-16-06 14:38:58.257', 'C'), (101,'2020-24-06 10:08:42.717', 'C'), (102,'2020-24-06 10:08:42.717', 'D'), (103,'2020-24-06 10:08:42.717', 'C'), (104,'2020-29-06 15:32:28.097', 'C'), (105,'2020-29-06 15:32:28.097', 'D'), (106,'2020-29-06 15:32:28.097', 'C'), (107,'2020-04-08 01:29:35.220', 'C'), (108,'2020-21-08 07:56:52.830', 'D'), (109,'2020-21-08 07:56:52.830', 'C'), (110,'2020-21-08 07:56:52.830', 'C'), (111,'2020-21-08 07:57:04.230', 'D'), (112,'2020-21-08 07:57:04.230', 'D'), (113,'2020-21-08 07:57:04.230', 'D'), (114,'2020-21-08 07:57:04.230', 'D'), (115,'2020-21-10 17:00:39.560', 'D'), (116,'2020-23-10 15:43:23.947', 'D'), (117,'2020-09-12 13:51:04.317', 'D'), (118,'2020-09-12 13:51:04.317', 'D'), (119,'2020-09-12 13:51:04.317', 'D'), (120,'2020-11-12 09:10:30.333', 'D'), (121,'2020-11-12 09:10:30.333', 'D'), (122,'2020-11-12 09:10:30.333', 'C'), (123,'2021-09-02 15:31:55.170', 'C'), (124,'2021-15-07 11:28:38.653', 'C'), (125,'2021-05-08 15:31:05.710', 'C'), (126,'2021-12-11 17:48:34.200', 'C'), (127,'2021-19-11 11:25:31.467', 'C'), (128,'2021-22-11 15:10:05.340', 'C'), (129,'2021-06-12 11:00:13.273', 'C'), (130,'2021-06-12 11:00:13.273', 'C'), (131,'2021-06-12 11:00:13.273', 'C'), (132,'2021-06-12 11:00:20.337', 'D'), (133,'2021-06-12 11:00:20.337', 'C'), (134,'2021-06-12 11:00:20.337', 'C'), (135,'2021-06-12 11:00:26.980', 'D'), (136,'2021-06-12 11:00:32.777', 'C'), (137,'2022-18-02 09:56:32.187', 'C'), (138,'2022-03-03 16:45:23.273', 'D'), (139,'2022-03-03 16:45:23.273', 'C'), (140,'2022-03-03 16:45:23.273', 'C'), (141,'2022-04-04 11:54:52.950', 'D'), (142,'2022-05-04 17:23:43.410', 'C'), (143,'2022-05-04 17:23:43.410', 'C'), (144,'2022-05-04 17:23:43.410', 'D'), (145,'2022-11-05 08:12:59.443', 'C'), (146,'2022-16-05 09:43:04.760', 'C'), (147,'2022-16-05 09:43:04.760', 'D'), (148,'2022-16-05 09:43:12.823', 'C'), (149,'2022-16-05 09:43:12.823', 'C'), (150,'2022-25-05 06:45:22.537', 'D'), (151,'2022-27-05 08:56:10.047', 'C'), (152,'2022-30-05 10:24:56.200', 'C'), (153,'2022-28-06 08:29:17.450', 'D'), (154,'2022-30-06 15:17:06.367', 'C'), (155,'2022-30-06 15:17:06.367', 'C'), (156,'2022-30-06 15:17:06.367', 'C'), (157,'2022-30-06 15:17:06.367', 'C'), (158,'2022-06-07 10:15:16.013', 'D'), (159,'2022-20-07 15:32:29.640', 'D'), (160,'2022-26-07 08:30:55.887', 'C'), (161,'2022-26-07 08:31:12.187', 'C'), (162,'2022-15-08 08:23:38.137', 'C'), (163,'2022-20-09 08:27:51.320', 'C'), (164,'2022-20-09 08:27:51.320', 'C'), (165,'2022-20-09 08:27:51.320', 'D'), (166,'2022-03-10 14:34:15.590', 'D'), (167,'2022-12-10 16:13:18.613', 'D'), (168,'2022-20-10 13:48:35.190', 'D'), (169,'2022-24-10 09:22:55.840', 'D'), (170,'2022-03-11 10:28:11.773', 'D'), (171,'2022-24-11 09:44:15.420', 'D'), (172,'2022-28-11 15:54:17.520', 'D'), (173,'2022-03-12 10:23:01.950', 'D'), (174,'2022-05-12 17:07:11.343', 'D'), (175,'2022-09-12 11:08:51.327', 'D'), (176,'2022-09-12 11:09:25.610', 'D'), (177,'2022-09-12 11:09:25.610', 'D'), (178,'2022-09-12 11:09:25.610', 'D'), (179,'2023-20-01 14:59:52.110', 'D'), (180,'2023-31-01 15:30:13.290', 'C'), (181,'2023-17-02 14:24:02.763', 'C'), (182,'2023-17-02 14:24:02.763', 'C'), (183,'2023-17-02 14:24:02.763', 'C'), (184,'2023-28-02 09:57:22.950', 'C'), (185,'2023-28-02 09:57:48.170', 'C'), (186,'2023-28-02 09:59:03.633', 'C'), (187,'2023-28-02 09:59:31.760', 'C'), (188,'2023-28-02 09:59:50.653', 'C'), (189,'2023-28-02 09:59:50.653', 'C'), (190,'2023-28-02 09:59:50.653', 'D'), (191,'2023-28-02 10:00:19.907', 'D'), (192,'2023-28-02 10:00:40.067', 'D'), (193,'2023-28-02 10:00:40.067', 'D'), (194,'2023-28-02 10:00:40.067', 'D'), (195,'2023-28-02 10:00:46.910', 'C'), (196,'2023-28-02 10:00:46.910', 'C'), (197,'2023-28-02 10:00:46.910', 'D'), (198,'2023-28-02 10:00:56.770', 'C'), (199,'2023-28-02 10:01:13.680', 'C'), (200,'2023-28-02 10:01:13.680', 'C'), (201,'2023-28-02 10:01:13.680', 'D'), (202,'2023-01-03 11:31:36.530', 'C'), (203,'2023-06-03 11:56:51.760', 'D'), (204,'2023-16-03 10:44:16.520', 'D'), (205,'2023-20-03 07:09:04.167', 'C'), (206,'2023-20-03 12:46:07.517', 'C'), (207,'2023-28-03 15:48:27.653', 'D'), (208,'2023-29-03 16:58:32.170', 'D'), (209,'2023-30-03 11:05:59.710', 'D'), (210,'2023-12-04 17:04:29.397', 'C'), (211,'2023-12-04 17:04:29.397', 'C'), (212,'2023-12-04 17:04:29.397', 'D'), (213,'2023-19-04 10:39:43.827', 'C'), (214,'2023-23-05 11:43:19.080', 'C'), (215,'2023-23-05 23:48:10.150', 'C'), (216,'2023-02-06 13:34:56.463', 'C'), (217,'2023-06-06 08:11:02.960', 'D'), (218,'2023-25-06 13:26:35.230', 'C'), (219,'2023-30-06 09:48:05.533', 'C'), (220,'2023-13-07 09:26:54.790', 'C'), (221,'2023-13-07 11:21:57.157', 'D'), (222,'2023-15-07 04:04:29.980', 'C'), (223,'2023-19-07 22:10:00.283', 'C'), (224,'2023-20-07 06:45:55.600', 'C'), (225,'2023-20-07 06:46:55.713', 'D'), (226,'2023-20-07 10:45:29.180', 'C'), (227,'2023-21-07 08:28:52.403', 'C'), (228,'2023-24-07 14:16:32.040', 'D'), (229,'2023-26-07 18:07:11.537', 'C'), (230,'2023-31-07 06:39:31.043', 'C'), (231,'2023-31-07 06:39:43.500', 'D'), (232,'2023-07-09 10:45:07.700', 'C'), (233,'2023-07-09 10:45:07.700', 'C')