MariaDB [tienda]> show tables;
+------------------+
| Tables_in_tienda |
+------------------+
| cliente          |
| vendedor         |
| venta            |
+------------------+
3 rows in set (0.001 sec)

MariaDB [tienda]> describe cliente;
+-------------+-------------+------+-----+---------+-------+
| Field       | Type        | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| IdCliente   | int(10)     | NO   |     | NULL    |       |
| Nombre      | varchar(30) | NO   |     | NULL    |       |
| CupoCredito | float       | NO   |     | NULL    |       |
+-------------+-------------+------+-----+---------+-------+
3 rows in set (0.004 sec)

MariaDB [tienda]> describe vendedor;
+--------------------+-------------+------+-----+---------+-------+
| Field              | Type        | Null | Key | Default | Extra |
+--------------------+-------------+------+-----+---------+-------+
| IdVendedor         | float       | NO   |     | NULL    |       |
| Nombre             | varchar(40) | NO   |     | NULL    |       |
| PorcentajeComision | float       | NO   |     | NULL    |       |
| Zona               | varchar(15) | NO   |     | NULL    |       |
+--------------------+-------------+------+-----+---------+-------+
4 rows in set (0.004 sec)

MariaDB [tienda]> describe venta;
+------------+---------+------+-----+---------+----------------+
| Field      | Type    | Null | Key | Default | Extra          |
+------------+---------+------+-----+---------+----------------+
| IdVenta    | int(11) | NO   | PRI | NULL    | auto_increment |
| IdCliente  | int(11) | YES  |     | NULL    |                |
| MontoVenta | float   | YES  |     | NULL    |                |
| FechaVenta | date    | YES  |     | NULL    |                |
+------------+---------+------+-----+---------+----------------+
4 rows in set (0.004 sec)

MariaDB [tienda]> select * from cliente;
+-----------+----------------+-------------+
| IdCliente | Nombre         | CupoCredito |
+-----------+----------------+-------------+
|     85963 | Ana Palencia   |      900000 |
|     25147 | Teresa Suarez  |     1200000 |
|     36259 | Shamir Beltran |      700000 |
+-----------+----------------+-------------+
3 rows in set (0.001 sec)

MariaDB [tienda]> select * from vendedor;
+------------+------------------+--------------------+--------+
| IdVendedor | Nombre           | PorcentajeComision | Zona   |
+------------+------------------+--------------------+--------+
|          1 | Franklin COlimba |                0.5 | Norte  |
|          2 | Camilo Lleras    |                0.6 | Centro |
|          3 | Sergio Agudelo   |                0.6 | Centro |
|          4 | Lina Ocampo      |                0.5 | Sur    |
+------------+------------------+--------------------+--------+
4 rows in set (0.000 sec)

MariaDB [tienda]> select * from venta;
+---------+-----------+------------+------------+
| IdVenta | IdCliente | MontoVenta | FechaVenta |
+---------+-----------+------------+------------+
|       1 |         1 |       1000 | 2023-08-26 |
|       2 |     85963 |     100000 | 2023-08-26 |
+---------+-----------+------------+------------+
2 rows in set (0.000 sec)

MariaDB [tienda]> show triggers;
+----------------------------+--------+-------+----------------------------------------------------------------------------------------------------------+--------+------------------------+-----------------------------------------------------+----------------+----------------------+----------------------+--------------------+
| Trigger                    | Event  | Table | Statement                                                                                                | Timing | Created                | sql_mode                                            | Definer        | character_set_client | collation_connection | Database Collation |
+----------------------------+--------+-------+----------------------------------------------------------------------------------------------------------+--------+------------------------+-----------------------------------------------------+----------------+----------------------+----------------------+--------------------+
| actualizar_credito_cliente | INSERT | venta | BEGIN
UPDATE Cliente SET CupoCredito = CupoCredito - NEW.MontoVenta WHERE IdCliente = NEW.IdCliente;
END | AFTER  | 2023-08-26 13:42:28.04 | NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION | root@localhost | cp850                | cp850_general_ci     | utf8mb4_general_ci |
+----------------------------+--------+-------+----------------------------------------------------------------------------------------------------------+--------+------------------------+-----------------------------------------------------+----------------+----------------------+----------------------+--------------------+
1 row in set (0.005 sec)

MariaDB [tienda]> INSERT INTO Venta (IdCliente, MontoVenta, FechaVenta) VALUES (36259, 600000, '2023-08-26');
Query OK, 1 row affected (0.073 sec)

MariaDB [tienda]> select * from venta;
+---------+-----------+------------+------------+
| IdVenta | IdCliente | MontoVenta | FechaVenta |
+---------+-----------+------------+------------+
|       1 |         1 |       1000 | 2023-08-26 |
|       2 |     85963 |     100000 | 2023-08-26 |
|       3 |     36259 |     600000 | 2023-08-26 |
+---------+-----------+------------+------------+
3 rows in set (0.001 sec)

MariaDB [tienda]> select * from cliente;
+-----------+----------------+-------------+
| IdCliente | Nombre         | CupoCredito |
+-----------+----------------+-------------+
|     85963 | Ana Palencia   |      900000 |
|     25147 | Teresa Suarez  |     1200000 |
|     36259 | Shamir Beltran |      100000 |
+-----------+----------------+-------------+
3 rows in set (0.000 sec)

MariaDB [tienda]> DELIMITER //
MariaDB [tienda]> CREATE TRIGGER calcular_comision
    -> AFTER INSERT ON Venta
    -> FOR EACH ROW
    -> BEGIN
    -> DECLARE comision FLOAT;
    -> SELECT PorcentajeComision INTO comision FROM Vendedor WHERE IdVendedor = NEW.IdVendedor;
    -> UPDATE Vendedor SET ComisionTotal = ComisionTotal + (NEW.MontoVenta * comision) WHERE IdVendedor = NEW.IdVendedor;
    -> END;
    -> //
ERROR 1054 (42S22): Unknown column 'IdVendedor' in 'NEW'