MariaDB [(none)]> create database BDclientevendedor;
Query OK, 1 row affected (0.002 sec)

MariaDB [(none)]> use BDclientevendedor;
Database changed

MariaDB [BDclientevendedor]> create table vendedor(Idvendedor varchar(5) not null primary key,
    -> nombre varchar(60) not null, 
    -> porcentaje_de_comision float(3) not null,
    -> zona varchar(20) not null);
Query OK, 0 rows affected (0.013 sec)

MariaDB [BDclientevendedor]> create table cliente(Idcliente varchar(5) not null primary key,
    -> nombre varchar(60) not null, 
    -> cupo_credito float(8) not null);
Query OK, 0 rows affected (0.012 sec)

MariaDB [BDclientevendedor]> show tables;
+-----------------------------+
| Tables_in_bdclientevendedor |
+-----------------------------+
| cliente                     |
| vendedor                    |
+-----------------------------+
2 rows in set (0.003 sec)

MariaDB [BDclientevendedor]> insert into vendedor(idvendedor, Nombre, Porcentaje_de_comision, zona) values('001','LUIS MEZA', 0.5,'NORTE');
Query OK, 1 row affected (0.003 sec)

MariaDB [BDclientevendedor]> insert into vendedor(idvendedor, Nombre, Porcentaje_de_comision, zona) values('002','CAMILO LLERAS', 0.6,'CENTRO');
Query OK, 1 row affected (0.002 sec)

MariaDB [BDclientevendedor]> insert into vendedor(idvendedor, Nombre, Porcentaje_de_comision, zona) values('003','SERGIO AGUDELO', 0.3,'CENTRO');
Query OK, 1 row affected (0.002 sec)

MariaDB [BDclientevendedor]> insert into vendedor(idvendedor, Nombre, Porcentaje_de_comision, zona) values('004','LINA OCAMPO', 0.5,'SUR');
Query OK, 1 row affected (0.002 sec)

MariaDB [BDclientevendedor]> insert into cliente(idcliente, Nombre, cupo_credito) values('50964','OSCAR DE LEON', 500000);
Query OK, 1 row affected (0.003 sec)

MariaDB [BDclientevendedor]> insert into cliente(idcliente, Nombre, cupo_credito) values('85963','ANA PALENCIA', 1000000);
Query OK, 1 row affected (0.001 sec)

MariaDB [BDclientevendedor]> insert into cliente(idcliente, Nombre, cupo_credito) values('25147','TERESA SUAREZ', 1200000);
Query OK, 1 row affected (0.002 sec)

MariaDB [BDclientevendedor]> insert into cliente(idcliente, Nombre, cupo_credito) values('36259','SHAMIR BELTRAN', 700000);
Query OK, 1 row affected (0.002 sec)

MariaDB [BDclientevendedor]> select * from vendedor;
+------------+----------------+------------------------+--------+
| Idvendedor | nombre         | porcentaje_de_comision | zona   |
+------------+----------------+------------------------+--------+
| 001        | LUIS MEZA      |                    0.5 | NORTE  |
| 002        | CAMILO LLERAS  |                    0.6 | CENTRO |
| 003        | SERGIO AGUDELO |                    0.3 | CENTRO |
| 004        | LINA OCAMPO    |                    0.5 | SUR    |
+------------+----------------+------------------------+--------+
4 rows in set (0.000 sec)

MariaDB [BDclientevendedor]> select * from cliente;
+-----------+----------------+--------------+
| Idcliente | nombre         | cupo_credito |
+-----------+----------------+--------------+
| 25147     | TERESA SUAREZ  |      1200000 |
| 36259     | SHAMIR BELTRAN |       700000 |
| 50964     | OSCAR DE LEON  |       500000 |
| 85963     | ANA PALENCIA   |      1000000 |
+-----------+----------------+--------------+
4 rows in set (0.000 sec)

MariaDB [BDclientevendedor]> Select * from vendedor where zona = 'norte';
+------------+-----------+------------------------+-------+
| Idvendedor | nombre    | porcentaje_de_comision | zona  |
+------------+-----------+------------------------+-------+
| 001        | LUIS MEZA |                    0.5 | NORTE |
+------------+-----------+------------------------+-------+
1 row in set (0.002 sec)

MariaDB [BDclientevendedor]> Select * from vendedor where zona = 'norte' and Porcentaje_de_comision = 0.3;
Empty set (0.002 sec)

MariaDB [BDclientevendedor]> Select * from vendedor where zona = 'centro';
+------------+----------------+------------------------+--------+
| Idvendedor | nombre         | porcentaje_de_comision | zona   |
+------------+----------------+------------------------+--------+
| 002        | CAMILO LLERAS  |                    0.6 | CENTRO |
| 003        | SERGIO AGUDELO |                    0.3 | CENTRO |
+------------+----------------+------------------------+--------+
2 rows in set (0.000 sec)

MariaDB [BDclientevendedor]> Select * from vendedor where zona = 'centro' and porcentaje_de_comision <= 0.5;
+------------+----------------+------------------------+--------+
| Idvendedor | nombre         | porcentaje_de_comision | zona   |
+------------+----------------+------------------------+--------+
| 003        | SERGIO AGUDELO |                    0.3 | CENTRO |
+------------+----------------+------------------------+--------+
1 row in set (0.000 sec)

MariaDB [BDclientevendedor]> Select * from cliente where cupo_credito > 500000 and cupo_credito < 1000000;
+-----------+----------------+--------------+
| Idcliente | nombre         | cupo_credito |
+-----------+----------------+--------------+
| 36259     | SHAMIR BELTRAN |       700000 |
+-----------+----------------+--------------+
1 row in set (0.001 sec)

MariaDB [BDclientevendedor]> Select * from cliente where nombre like 'a%' and nombre like '%a';
+-----------+--------------+--------------+
| Idcliente | nombre       | cupo_credito |
+-----------+--------------+--------------+
| 85963     | ANA PALENCIA |      1000000 |
+-----------+--------------+--------------+
1 row in set (0.001 sec)

MariaDB [BDclientevendedor]> Select * from cliente where nombre like '%a%';
+-----------+----------------+--------------+
| Idcliente | nombre         | cupo_credito |
+-----------+----------------+--------------+
| 25147     | TERESA SUAREZ  |      1200000 |
| 36259     | SHAMIR BELTRAN |       700000 |
| 50964     | OSCAR DE LEON  |       500000 |
| 85963     | ANA PALENCIA   |      1000000 |
+-----------+----------------+--------------+
4 rows in set (0.000 sec)

MariaDB [BDclientevendedor]> Select count(cupo_credito) 'Cantidad_de creditos' from cliente;
+----------------------+
| Cantidad_de creditos |
+----------------------+
|                    4 |
+----------------------+
1 row in set (0.002 sec)

MariaDB [BDclientevendedor]> Select max(cupo_credito) 'Valor_maximo_de creditos' from cliente;
+--------------------------+
| Valor_maximo_de creditos |
+--------------------------+
|                  1200000 |
+--------------------------+
1 row in set (0.000 sec)

MariaDB [BDclientevendedor]> Select min(cupo_credito) 'Valor_minimo_de creditos' from cliente;
+--------------------------+
| Valor_minimo_de creditos |
+--------------------------+
|                   500000 |
+--------------------------+
1 row in set (0.000 sec)

MariaDB [BDclientevendedor]> Select sum(cupo_credito) 'Suma_de creditos' from cliente;
+------------------+
| Suma_de creditos |
+------------------+
|          3400000 |
+------------------+
1 row in set (0.000 sec)

MariaDB [BDclientevendedor]> Select avg(cupo_credito) 'Promeido_de creditos' from cliente;
+----------------------+
| Promeido_de creditos |
+----------------------+
|               850000 |
+----------------------+
1 row in set (0.000 sec)


MariaDB [BDclientevendedor]> Select * from cliente order by (cupo_credito) asc;
+-----------+----------------+--------------+
| Idcliente | nombre         | cupo_credito |
+-----------+----------------+--------------+
| 50964     | OSCAR DE LEON  |       500000 |
| 36259     | SHAMIR BELTRAN |       700000 |
| 85963     | ANA PALENCIA   |      1000000 |
| 25147     | TERESA SUAREZ  |      1200000 |
+-----------+----------------+--------------+
4 rows in set (0.000 sec)

MariaDB [BDclientevendedor]> Select * from vendedor order by nombre desc;
+------------+----------------+------------------------+--------+
| Idvendedor | nombre         | porcentaje_de_comision | zona   |
+------------+----------------+------------------------+--------+
| 003        | SERGIO AGUDELO |                    0.3 | CENTRO |
| 001        | LUIS MEZA      |                    0.5 | NORTE  |
| 004        | LINA OCAMPO    |                    0.5 | SUR    |
| 002        | CAMILO LLERAS  |                    0.6 | CENTRO |
+------------+----------------+------------------------+--------+
4 rows in set (0.000 sec)

MariaDB [BDclientevendedor]> Delete from cliente where cupo_credito<=500000;
Query OK, 1 row affected (0.003 sec)

MariaDB [BDclientevendedor]> select * from cliente;
+-----------+----------------+--------------+
| Idcliente | nombre         | cupo_credito |
+-----------+----------------+--------------+
| 25147     | TERESA SUAREZ  |      1200000 |
| 36259     | SHAMIR BELTRAN |       700000 |
| 85963     | ANA PALENCIA   |      1000000 |
+-----------+----------------+--------------+
3 rows in set (0.000 sec)

MariaDB [BDclientevendedor]> update vendedor set nombre = 'Harold Martinez' where idvendedor = '001';
Query OK, 1 row affected (0.002 sec)
Rows matched: 1  Changed: 1  Warnings: 0

MariaDB [BDclientevendedor]> select * from vendedor;
+------------+-----------------+------------------------+--------+
| Idvendedor | nombre          | porcentaje_de_comision | zona   |
+------------+-----------------+------------------------+--------+
| 001        | Harold Martinez |                    0.5 | NORTE  |
| 002        | CAMILO LLERAS   |                    0.6 | CENTRO |
| 003        | SERGIO AGUDELO  |                    0.3 | CENTRO |
| 004        | LINA OCAMPO     |                    0.5 | SUR    |
+------------+-----------------+------------------------+--------+
4 rows in set (0.000 sec)

MariaDB [BDclientevendedor]> exit