MariaDB [(none)]> use papeleria; Database changed MariaDB [papeleria]> show tables; +------------------------+ | Tables_in_papeleria | +------------------------+ | categorias | | consumidor | | detalles_pedido | | detalles_venta | | distribuidor | | historial_inventario | | metodos_pago | | pedidos_distribuidores | | producto | | producto_promocion | | promociones | | ventas | +------------------------+ 12 rows in set (0.001 sec) MariaDB [papeleria]> INSERT INTO Distribuidor (ID_distribuidor, Nombre, Telefono, Ciudad) VALUES -> ('DIST001', 'Suministros Escolares S.A.', '3101234567', 'Bogot '), -> ('DIST002', 'Papeles Creativos Ltda.', '3202345678', 'Medell¡n'), -> ('DIST003', 'Materiales Educativos', '3153456789', 'Cali'), -> ('DIST004', 'Arte y Oficina', '3004567890', 'Barranquilla'), -> ('DIST005', 'Librer¡a Nacional', '3185678901', 'Bucaramanga'), -> ('DIST006', 'Distribuidora Escolar', '3196789012', 'Cartagena'), -> ('DIST007', 'Papeler¡a Industrial', '3017890123', 'Pereira'), -> ('DIST008', 'Suministros Corporativos', '3028901234', 'Manizales'), -> ('DIST009', 'Materiales Did cticos', '3049012345', 'Ibagu‚'), -> ('DIST010', 'Papeles y M s', '3050123456', 'Neiva'); Query OK, 10 rows affected (0.030 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [papeleria]> INSERT INTO Producto (ID_producto, Nombre, Precio_costo, Precio_venta, Disponible) VALUES -> ('PROD001', 'Cuaderno cuadriculado', 1500, 3000, 100), -> ('PROD002', 'L piz grafito', 200, 500, 200), -> ('PROD003', 'Borrador blanco', 300, 800, 150), -> ('PROD004', 'Resma papel carta', 8000, 15000, 50), -> ('PROD005', 'Tajal piz met lico', 1000, 2500, 80), -> ('PROD006', 'Marcador permanente', 1200, 3000, 60), -> ('PROD007', 'Carpeta oficio', 2500, 5000, 40), -> ('PROD008', 'Pegante en barra', 1800, 3500, 70), -> ('PROD009', 'Regla 30 cm', 700, 1500, 90), -> ('PROD010', 'Corrector l¡quido', 2200, 4500, 30); Query OK, 10 rows affected (0.008 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [papeleria]> INSERT INTO Consumidor (ID_consumidor, Nombre, Telefono, Ciudad) VALUES -> ('CONS001', 'Mar¡a Gonz lez', '3111111111', 'Bogot '), -> ('CONS002', 'Carlos Rodr¡guez', '3222222222', 'Medell¡n'), -> ('CONS003', 'Ana Mart¡nez', '3333333333', 'Cali'), -> ('CONS004', 'Luis P‚rez', '3444444444', 'Barranquilla'), -> ('CONS005', 'Sof¡a L¢pez', '3555555555', 'Bucaramanga'), -> ('CONS006', 'Jorge Ram¡rez', '3666666666', 'Cartagena'), -> ('CONS007', 'Diana Garc¡a', '3777777777', 'Pereira'), -> ('CONS008', 'Pedro S nchez', '3888888888', 'Manizales'), -> ('CONS009', 'Laura Fern ndez', '3999999999', 'Ibagu‚'), -> ('CONS010', 'Andr‚s Torres', '3000000000', 'Neiva'); Query OK, 10 rows affected (0.005 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [papeleria]> INSERT INTO Categorias (ID_categoria, Nombre, Descripcion) VALUES -> ('CAT001', 'Papeler¡a', 'Productos b sicos de escritura'), -> ('CAT002', 'Oficina', 'Art¡culos para entorno laboral'), -> ('CAT003', 'Escolar', 'Materiales para estudiantes'), -> ('CAT004', 'Arte', 'Productos para manualidades'), -> ('CAT005', 'Organizaci¢n', 'Carpetas y archivadores'), -> ('CAT006', 'Escritura', 'L pices, bol¡grafos, marcadores'), -> ('CAT007', 'Correcci¢n', 'Correctores y borradores'), -> ('CAT008', 'Papel', 'Diferentes tipos de papel'), -> ('CAT009', 'Adhesivos', 'Pegantes y cintas'), -> ('CAT010', 'Geometr¡a', 'Reglas y compases'); Query OK, 10 rows affected (0.004 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [papeleria]> INSERT INTO Metodos_Pago (ID_metodo_pago, Nombre, Descripcion) VALUES -> ('MP001', 'Efectivo', 'Pago en billetes o monedas'), -> ('MP002', 'Tarjeta d‚bito', 'Pago con tarjeta de d‚bito'), -> ('MP003', 'Tarjeta cr‚dito', 'Pago con tarjeta de cr‚dito'), -> ('MP004', 'Transferencia', 'Transferencia bancaria'), -> ('MP005', 'Cheque', 'Pago con cheque certificado'), -> ('MP006', 'PSE', 'Pago seguro en l¡nea'), -> ('MP007', 'Nequi', 'Pago con billetera m¢vil'), -> ('MP008', 'Daviplata', 'Pago con billetera m¢vil'), -> ('MP009', 'Datafono', 'Pago con terminal punto de venta'), -> ('MP010', 'Credif cil', 'Cr‚dito directo con la papeler¡a'); Query OK, 10 rows affected (0.005 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [papeleria]> INSERT INTO Promociones (ID_promocion, Nombre, Descripcion, Descuento, Fecha_inicio, Fecha_fin) VALUES -> ('PROM001', 'Vuelta al Cole', 'Descuento en £tiles escolares', 15, '2023-01-15', '2023-02-15'), -> ('PROM002', 'D¡a del Padre', 'Ofertas especiales', 10, '2023-06-10', '2023-06-20'), -> ('PROM003', 'Black Friday', 'Grandes descuentos', 20, '2023-11-24', '2023-11-27'), -> ('PROM004', 'Cyber Monday', 'Ofertas en tecnolog¡a', 15, '2023-11-27', '2023-11-28'), -> ('PROM005', 'Navidad', 'Promoci¢n especial navide¤a', 25, '2023-12-01', '2023-12-31'), -> ('PROM006', 'A¤o Nuevo', 'Descuentos de inicio de a¤o', 10, '2024-01-01', '2024-01-15'), -> ('PROM007', 'D¡a de la Madre', 'Ofertas para mam ', 15, '2023-05-10', '2023-05-15'), -> ('PROM008', 'Semana del Estudiante', 'Descuentos para estudiantes', 30, '2023-10-01', '2023-10-07'), -> ('PROM009', 'Aniversario', 'Celebraci¢n de la tienda', 20, '2023-08-15', '2023-08-20'), -> ('PROM010', 'Liquidaci¢n', 'Liquidaci¢n de inventario', 40, '2023-12-26', '2024-01-10'); Query OK, 10 rows affected (0.004 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [papeleria]> INSERT INTO Pedidos_Distribuidores (ID_pedidodistri, Fecha, FK_distribuidor) VALUES -> ('PED001', '2023-01-10', 'DIST001'), -> ('PED002', '2023-01-15', 'DIST002'), -> ('PED003', '2023-02-05', 'DIST003'), -> ('PED004', '2023-02-20', 'DIST004'), -> ('PED005', '2023-03-01', 'DIST005'), -> ('PED006', '2023-03-15', 'DIST006'), -> ('PED007', '2023-04-02', 'DIST007'), -> ('PED008', '2023-04-18', 'DIST008'), -> ('PED009', '2023-05-05', 'DIST009'), -> ('PED010', '2023-05-20', 'DIST010'); Query OK, 10 rows affected (0.004 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [papeleria]> INSERT INTO Detalles_Pedido (ID_detallePedi, Nombre, cantidad_pedido, Precio_compra, FK_pedidodistri, FK_producto) VALUES -> ('DP001', 'Pedido cuadernos', 50, 1500, 'PED001', 'PROD001'), -> ('DP002', 'Pedido l pices', 100, 200, 'PED001', 'PROD002'), -> ('DP003', 'Pedido borradores', 30, 300, 'PED002', 'PROD003'), -> ('DP004', 'Pedido resmas', 20, 8000, 'PED003', 'PROD004'), -> ('DP005', 'Pedido tajal pices', 40, 1000, 'PED004', 'PROD005'), -> ('DP006', 'Pedido marcadores', 25, 1200, 'PED005', 'PROD006'), -> ('DP007', 'Pedido carpetas', 15, 2500, 'PED006', 'PROD007'), -> ('DP008', 'Pedido pegantes', 35, 1800, 'PED007', 'PROD008'), -> ('DP009', 'Pedido reglas', 45, 700, 'PED008', 'PROD009'), -> ('DP010', 'Pedido correctores', 20, 2200, 'PED009', 'PROD010'); Query OK, 10 rows affected (0.004 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [papeleria]> INSERT INTO Ventas (ID_venta, Fecha, FK_consumidor) VALUES -> ('VENT001', '2023-01-05', 'CONS001'), -> ('VENT002', '2023-01-12', 'CONS002'), -> ('VENT003', '2023-01-18', 'CONS003'), -> ('VENT004', '2023-02-02', 'CONS004'), -> ('VENT005', '2023-02-10', 'CONS005'), -> ('VENT006', '2023-02-15', 'CONS006'), -> ('VENT007', '2023-03-01', 'CONS007'), -> ('VENT008', '2023-03-08', 'CONS008'), -> ('VENT009', '2023-03-15', 'CONS009'), -> ('VENT010', '2023-03-22', 'CONS010'); Query OK, 10 rows affected (0.004 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [papeleria]> INSERT INTO Detalles_Venta (ID_detalleVenta, Cantidad_vendida, FK_venta, FK_producto) VALUES -> ('DV001', 2, 'VENT001', 'PROD001'), -> ('DV002', 5, 'VENT001', 'PROD002'), -> ('DV003', 1, 'VENT002', 'PROD003'), -> ('DV004', 3, 'VENT003', 'PROD004'), -> ('DV005', 2, 'VENT004', 'PROD005'), -> ('DV006', 4, 'VENT005', 'PROD006'), -> ('DV007', 1, 'VENT006', 'PROD007'), -> ('DV008', 3, 'VENT007', 'PROD008'), -> ('DV009', 2, 'VENT008', 'PROD009'), -> ('DV010', 1, 'VENT009', 'PROD010'); Query OK, 10 rows affected (0.004 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [papeleria]> INSERT INTO Producto_Promocion (ID_producto, ID_promocion, Fecha_aplicacion) VALUES -> ('PROD001', 'PROM001', '2023-01-15'), -> ('PROD002', 'PROM001', '2023-01-15'), -> ('PROD003', 'PROM002', '2023-06-10'), -> ('PROD004', 'PROM003', '2023-11-24'), -> ('PROD005', 'PROM004', '2023-11-27'), -> ('PROD006', 'PROM005', '2023-12-01'), -> ('PROD007', 'PROM006', '2024-01-01'), -> ('PROD008', 'PROM007', '2023-05-10'), -> ('PROD009', 'PROM008', '2023-10-01'), -> ('PROD010', 'PROM009', '2023-08-15'); Query OK, 10 rows affected (0.004 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [papeleria]> INSERT INTO Historial_Inventario (ID_historial, ID_producto, Fecha_cambio, Cantidad_anterior, Cantidad_nueva) VALUES -> ('HIST001', 'PROD001', '2023-01-05', 100, 98), -> ('HIST002', 'PROD002', '2023-01-05', 200, 195), -> ('HIST003', 'PROD003', '2023-01-12', 150, 149), -> ('HIST004', 'PROD004', '2023-01-18', 50, 47), -> ('HIST005', 'PROD005', '2023-02-02', 80, 78), -> ('HIST006', 'PROD006', '2023-02-10', 60, 56), -> ('HIST007', 'PROD007', '2023-02-15', 40, 39), -> ('HIST008', 'PROD008', '2023-03-01', 70, 67), -> ('HIST009', 'PROD009', '2023-03-08', 90, 88), -> ('HIST010', 'PROD010', '2023-03-15', 30, 29); Query OK, 10 rows affected (0.013 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [papeleria]> SELECT * FROM Distribuidor; +-----------------+----------------------------+------------+--------------+ | ID_distribuidor | Nombre | Telefono | Ciudad | +-----------------+----------------------------+------------+--------------+ | DIST001 | Suministros Escolares S.A. | 3101234567 | Bogot  | | DIST002 | Papeles Creativos Ltda. | 3202345678 | Medell¡n | | DIST003 | Materiales Educativos | 3153456789 | Cali | | DIST004 | Arte y Oficina | 3004567890 | Barranquilla | | DIST005 | Librer¡a Nacional | 3185678901 | Bucaramanga | | DIST006 | Distribuidora Escolar | 3196789012 | Cartagena | | DIST007 | Papeler¡a Industrial | 3017890123 | Pereira | | DIST008 | Suministros Corporativos | 3028901234 | Manizales | | DIST009 | Materiales Did cticos | 3049012345 | Ibagu‚ | | DIST010 | Papeles y M s | 3050123456 | Neiva | +-----------------+----------------------------+------------+--------------+ 10 rows in set (0.000 sec) MariaDB [papeleria]> SELECT * FROM Producto; +-------------+-----------------------+--------------+--------------+------------+ | ID_producto | Nombre | Precio_costo | Precio_venta | Disponible | +-------------+-----------------------+--------------+--------------+------------+ | PROD001 | Cuaderno cuadriculado | 1500 | 3000 | 100 | | PROD002 | L piz grafito | 200 | 500 | 200 | | PROD003 | Borrador blanco | 300 | 800 | 150 | | PROD004 | Resma papel carta | 8000 | 15000 | 50 | | PROD005 | Tajal piz met lico | 1000 | 2500 | 80 | | PROD006 | Marcador permanente | 1200 | 3000 | 60 | | PROD007 | Carpeta oficio | 2500 | 5000 | 40 | | PROD008 | Pegante en barra | 1800 | 3500 | 70 | | PROD009 | Regla 30 cm | 700 | 1500 | 90 | | PROD010 | Corrector l¡quido | 2200 | 4500 | 30 | +-------------+-----------------------+--------------+--------------+------------+ 10 rows in set (0.000 sec) MariaDB [papeleria]> SELECT * FROM Consumidor; +---------------+------------------+------------+--------------+ | ID_consumidor | Nombre | Telefono | Ciudad | +---------------+------------------+------------+--------------+ | CONS001 | Mar¡a Gonz lez | 3111111111 | Bogot  | | CONS002 | Carlos Rodr¡guez | 3222222222 | Medell¡n | | CONS003 | Ana Mart¡nez | 3333333333 | Cali | | CONS004 | Luis P‚rez | 3444444444 | Barranquilla | | CONS005 | Sof¡a L¢pez | 3555555555 | Bucaramanga | | CONS006 | Jorge Ram¡rez | 3666666666 | Cartagena | | CONS007 | Diana Garc¡a | 3777777777 | Pereira | | CONS008 | Pedro S nchez | 3888888888 | Manizales | | CONS009 | Laura Fern ndez | 3999999999 | Ibagu‚ | | CONS010 | Andr‚s Torres | 3000000000 | Neiva | +---------------+------------------+------------+--------------+ 10 rows in set (0.000 sec) MariaDB [papeleria]> SELECT * FROM Categorias; +--------------+--------------+---------------------------------+ | ID_categoria | Nombre | Descripcion | +--------------+--------------+---------------------------------+ | CAT001 | Papeler¡a | Productos b sicos de escritura | | CAT002 | Oficina | Art¡culos para entorno laboral | | CAT003 | Escolar | Materiales para estudiantes | | CAT004 | Arte | Productos para manualidades | | CAT005 | Organizaci¢n | Carpetas y archivadores | | CAT006 | Escritura | L pices, bol¡grafos, marcadores | | CAT007 | Correcci¢n | Correctores y borradores | | CAT008 | Papel | Diferentes tipos de papel | | CAT009 | Adhesivos | Pegantes y cintas | | CAT010 | Geometr¡a | Reglas y compases | +--------------+--------------+---------------------------------+ 10 rows in set (0.000 sec) MariaDB [papeleria]> SELECT * FROM Metodos_Pago; +----------------+-----------------+----------------------------------+ | ID_metodo_pago | Nombre | Descripcion | +----------------+-----------------+----------------------------------+ | MP001 | Efectivo | Pago en billetes o monedas | | MP002 | Tarjeta d‚bito | Pago con tarjeta de d‚bito | | MP003 | Tarjeta cr‚dito | Pago con tarjeta de cr‚dito | | MP004 | Transferencia | Transferencia bancaria | | MP005 | Cheque | Pago con cheque certificado | | MP006 | PSE | Pago seguro en l¡nea | | MP007 | Nequi | Pago con billetera m¢vil | | MP008 | Daviplata | Pago con billetera m¢vil | | MP009 | Datafono | Pago con terminal punto de venta | | MP010 | Credif cil | Cr‚dito directo con la papeler¡a | +----------------+-----------------+----------------------------------+ 10 rows in set (0.000 sec) MariaDB [papeleria]> SELECT * FROM Promociones; +--------------+-----------------------+-------------------------------+-----------+--------------+------------+ | ID_promocion | Nombre | Descripcion | Descuento | Fecha_inicio | Fecha_fin | +--------------+-----------------------+-------------------------------+-----------+--------------+------------+ | PROM001 | Vuelta al Cole | Descuento en £tiles escolares | 15 | 2023-01-15 | 2023-02-15 | | PROM002 | D¡a del Padre | Ofertas especiales | 10 | 2023-06-10 | 2023-06-20 | | PROM003 | Black Friday | Grandes descuentos | 20 | 2023-11-24 | 2023-11-27 | | PROM004 | Cyber Monday | Ofertas en tecnolog¡a | 15 | 2023-11-27 | 2023-11-28 | | PROM005 | Navidad | Promoci¢n especial navide¤a | 25 | 2023-12-01 | 2023-12-31 | | PROM006 | A¤o Nuevo | Descuentos de inicio de a¤o | 10 | 2024-01-01 | 2024-01-15 | | PROM007 | D¡a de la Madre | Ofertas para mam  | 15 | 2023-05-10 | 2023-05-15 | | PROM008 | Semana del Estudiante | Descuentos para estudiantes | 30 | 2023-10-01 | 2023-10-07 | | PROM009 | Aniversario | Celebraci¢n de la tienda | 20 | 2023-08-15 | 2023-08-20 | | PROM010 | Liquidaci¢n | Liquidaci¢n de inventario | 40 | 2023-12-26 | 2024-01-10 | +--------------+-----------------------+-------------------------------+-----------+--------------+------------+ 10 rows in set (0.000 sec) MariaDB [papeleria]> SELECT * FROM Pedidos_Distribuidores; +-----------------+------------+-----------------+ | ID_pedidodistri | Fecha | FK_distribuidor | +-----------------+------------+-----------------+ | PED001 | 2023-01-10 | DIST001 | | PED002 | 2023-01-15 | DIST002 | | PED003 | 2023-02-05 | DIST003 | | PED004 | 2023-02-20 | DIST004 | | PED005 | 2023-03-01 | DIST005 | | PED006 | 2023-03-15 | DIST006 | | PED007 | 2023-04-02 | DIST007 | | PED008 | 2023-04-18 | DIST008 | | PED009 | 2023-05-05 | DIST009 | | PED010 | 2023-05-20 | DIST010 | +-----------------+------------+-----------------+ 10 rows in set (0.000 sec) MariaDB [papeleria]> SELECT * FROM Detalles_Pedido; +----------------+--------------------+-----------------+---------------+-----------------+-------------+ | ID_detallePedi | Nombre | cantidad_pedido | Precio_compra | FK_pedidodistri | FK_producto | +----------------+--------------------+-----------------+---------------+-----------------+-------------+ | DP001 | Pedido cuadernos | 50 | 1500 | PED001 | PROD001 | | DP002 | Pedido l pices | 100 | 200 | PED001 | PROD002 | | DP003 | Pedido borradores | 30 | 300 | PED002 | PROD003 | | DP004 | Pedido resmas | 20 | 8000 | PED003 | PROD004 | | DP005 | Pedido tajal pices | 40 | 1000 | PED004 | PROD005 | | DP006 | Pedido marcadores | 25 | 1200 | PED005 | PROD006 | | DP007 | Pedido carpetas | 15 | 2500 | PED006 | PROD007 | | DP008 | Pedido pegantes | 35 | 1800 | PED007 | PROD008 | | DP009 | Pedido reglas | 45 | 700 | PED008 | PROD009 | | DP010 | Pedido correctores | 20 | 2200 | PED009 | PROD010 | +----------------+--------------------+-----------------+---------------+-----------------+-------------+ 10 rows in set (0.000 sec) MariaDB [papeleria]> SELECT * FROM Ventas; +----------+------------+---------------+ | ID_venta | Fecha | FK_consumidor | +----------+------------+---------------+ | VENT001 | 2023-01-05 | CONS001 | | VENT002 | 2023-01-12 | CONS002 | | VENT003 | 2023-01-18 | CONS003 | | VENT004 | 2023-02-02 | CONS004 | | VENT005 | 2023-02-10 | CONS005 | | VENT006 | 2023-02-15 | CONS006 | | VENT007 | 2023-03-01 | CONS007 | | VENT008 | 2023-03-08 | CONS008 | | VENT009 | 2023-03-15 | CONS009 | | VENT010 | 2023-03-22 | CONS010 | +----------+------------+---------------+ 10 rows in set (0.000 sec) MariaDB [papeleria]> SELECT * FROM Detalles_Venta; +-----------------+------------------+----------+-------------+ | ID_detalleVenta | Cantidad_vendida | FK_venta | FK_producto | +-----------------+------------------+----------+-------------+ | DV001 | 2 | VENT001 | PROD001 | | DV002 | 5 | VENT001 | PROD002 | | DV003 | 1 | VENT002 | PROD003 | | DV004 | 3 | VENT003 | PROD004 | | DV005 | 2 | VENT004 | PROD005 | | DV006 | 4 | VENT005 | PROD006 | | DV007 | 1 | VENT006 | PROD007 | | DV008 | 3 | VENT007 | PROD008 | | DV009 | 2 | VENT008 | PROD009 | | DV010 | 1 | VENT009 | PROD010 | +-----------------+------------------+----------+-------------+ 10 rows in set (0.000 sec) MariaDB [papeleria]> SELECT * FROM Producto_Promocion; +-------------+--------------+------------------+ | ID_producto | ID_promocion | Fecha_aplicacion | +-------------+--------------+------------------+ | PROD001 | PROM001 | 2023-01-15 | | PROD002 | PROM001 | 2023-01-15 | | PROD003 | PROM002 | 2023-06-10 | | PROD004 | PROM003 | 2023-11-24 | | PROD005 | PROM004 | 2023-11-27 | | PROD006 | PROM005 | 2023-12-01 | | PROD007 | PROM006 | 2024-01-01 | | PROD008 | PROM007 | 2023-05-10 | | PROD009 | PROM008 | 2023-10-01 | | PROD010 | PROM009 | 2023-08-15 | +-------------+--------------+------------------+ 10 rows in set (0.000 sec) MariaDB [papeleria]> SELECT * FROM Historial_Inventario; +--------------+-------------+--------------+-------------------+----------------+ | ID_historial | ID_producto | Fecha_cambio | Cantidad_anterior | Cantidad_nueva | +--------------+-------------+--------------+-------------------+----------------+ | HIST001 | PROD001 | 2023-01-05 | 100 | 98 | | HIST002 | PROD002 | 2023-01-05 | 200 | 195 | | HIST003 | PROD003 | 2023-01-12 | 150 | 149 | | HIST004 | PROD004 | 2023-01-18 | 50 | 47 | | HIST005 | PROD005 | 2023-02-02 | 80 | 78 | | HIST006 | PROD006 | 2023-02-10 | 60 | 56 | | HIST007 | PROD007 | 2023-02-15 | 40 | 39 | | HIST008 | PROD008 | 2023-03-01 | 70 | 67 | | HIST009 | PROD009 | 2023-03-08 | 90 | 88 | | HIST010 | PROD010 | 2023-03-15 | 30 | 29 | +--------------+-------------+--------------+-------------------+----------------+ 10 rows in set (0.000 sec) MariaDB [papeleria]> exit