MariaDB [turismo]>  select * from visitantes;
+----+---------------------------+--------------+-----------+-------------+
| id | nombre                    | ciudad       | sexo      | montocompra |
+----+---------------------------+--------------+-----------+-------------+
|  1 | Juan carlos Perez         | Bogota       | Masculino |     1500000 |
|  2 | Elizabeth Torres          | Bogota       | Femenino  |     1000000 |
|  3 | Carmen  Elvira Montes     | Medellin     | Femenino  |     2000000 |
|  4 | Diana Patricia Garcia     | Medellin     | Femenino  |     2500000 |
|  5 | Juan Alberto Cardona      | Barranquilla | Masculino |     3500000 |
|  6 | Felipe Ardila Castro      | Barranquilla | Masculino |     3000000 |
|  7 | Mariana Ocampo Cifuentes  | Barranquilla | Femenino  |     1800000 |
|  8 | Mirian Ocampo Cifuentes   | Cartagena    | Femenino  |     1600000 |
|  9 | Martha Betancurt Ossa     | Cartagena    | Femenino  |     6000000 |
| 10 | Mateo Vasquez Posada      | Cartagena    | Masculino |     3000000 |
| 11 | Pablo Andres Arboleda     | Cartagena    | Masculino |     1500000 |
| 12 | Ana Maria Guerrero Guasca | cartagena    | femenino  |     5000000 |
+----+---------------------------+--------------+-----------+-------------+
12 rows in set (0.001 sec)

MariaDB [turismo]> select * from visitantes group by ciudad;
+----+-------------------------+--------------+-----------+-------------+
| id | nombre                  | ciudad       | sexo      | montocompra |
+----+-------------------------+--------------+-----------+-------------+
|  5 | Juan Alberto Cardona    | Barranquilla | Masculino |     3500000 |
|  1 | Juan carlos Perez       | Bogota       | Masculino |     1500000 |
|  8 | Mirian Ocampo Cifuentes | Cartagena    | Femenino  |     1600000 |
|  3 | Carmen  Elvira Montes   | Medellin     | Femenino  |     2000000 |
+----+-------------------------+--------------+-----------+-------------+
4 rows in set (0.001 sec)

MariaDB [turismo]> select  ciudad ,count(ciudad) as 'cantidad visitantes' from visitantes group by ciudad;
+--------------+---------------------+
| ciudad       | cantidad visitantes |
+--------------+---------------------+
| Barranquilla |                   3 |
| Bogota       |                   2 |
| Cartagena    |                   5 |
| Medellin     |                   2 |
+--------------+---------------------+
4 rows in set (0.000 sec)

MariaDB [turismo]> describe visitantes;
+-------------+----------------+------+-----+---------+----------------+
| Field       | Type           | Null | Key | Default | Extra          |
+-------------+----------------+------+-----+---------+----------------+
| id          | int(11)        | NO   | PRI | NULL    | auto_increment |
| nombre      | char(40)       | NO   |     | NULL    |                |
| ciudad      | char(15)       | NO   |     | NULL    |                |
| sexo        | char(15)       | NO   |     | NULL    |                |
| montocompra | float unsigned | YES  |     | NULL    |                |
+-------------+----------------+------+-----+---------+----------------+
5 rows in set (0.033 sec)

MariaDB [turismo]> select ciudad,sum(montocompra) as 'total compra por ciudad' from visitantes group by ciudad;
+--------------+-------------------------+
| ciudad       | total compra por ciudad |
+--------------+-------------------------+
| Barranquilla |                 8300000 |
| Bogota       |                 2500000 |
| Cartagena    |                17100000 |
| Medellin     |                 4500000 |
+--------------+-------------------------+
4 rows in set (0.000 sec)

MariaDB [turismo]> select sexo, sum(montocompra) as 'total compra por sexo' from visitantes group by sexo;
+-----------+-----------------------+
| sexo      | total compra por sexo |
+-----------+-----------------------+
| Femenino  |              19900000 |
| Masculino |              12500000 |
+-----------+-----------------------+
2 rows in set (0.000 sec)

MariaDB [turismo]>  select  ciudad ,count(ciudad) as 'cantidad visitantes' from visitantes group by ciudad having count(ciudad)>2;
+--------------+---------------------+
| ciudad       | cantidad visitantes |
+--------------+---------------------+
| Barranquilla |                   3 |
| Cartagena    |                   5 |
+--------------+---------------------+
2 rows in set (0.001 sec)

MariaDB [turismo]> select ciudad,sexo, avg(montocompra) 'promedio de compra' from visitantes group by ciudad,sexo;
+--------------+-----------+--------------------+
| ciudad       | sexo      | promedio de compra |
+--------------+-----------+--------------------+
| Barranquilla | Femenino  |            1800000 |
| Barranquilla | Masculino |            3250000 |
| Bogota       | Femenino  |            1000000 |
| Bogota       | Masculino |            1500000 |
| Cartagena    | Femenino  |            4200000 |
| Cartagena    | Masculino |            2250000 |
| Medellin     | Femenino  |            2250000 |
+--------------+-----------+--------------------+
7 rows in set (0.000 sec)

MariaDB [turismo]> Select  ciudad, sum(montocompra) as 'Mayores_a_5000000' from visitantes group by ciudad having sum(montocompra)>5000000;
+--------------+-------------------+
| ciudad       | Mayores_a_5000000 |
+--------------+-------------------+
| Barranquilla |           8300000 |
| Cartagena    |          17100000 |
+--------------+-------------------+
2 rows in set (0.001 sec)

MariaDB [turismo]> create view visitantesa as select * from visitantes where nombre like '%a';
Query OK, 0 rows affected (0.033 sec)

MariaDB [turismo]> sow tables;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'sow tables' at line 1
MariaDB [turismo]> show tables;
+-------------------+
| Tables_in_turismo |
+-------------------+
| visitantes        |
| visitantesa       |
+-------------------+
2 rows in set (0.001 sec)

MariaDB [turismo]> select * from visitantesa;
+----+---------------------------+--------------+-----------+-------------+
| id | nombre                    | ciudad       | sexo      | montocompra |
+----+---------------------------+--------------+-----------+-------------+
|  4 | Diana Patricia Garcia     | Medellin     | Femenino  |     2500000 |
|  5 | Juan Alberto Cardona      | Barranquilla | Masculino |     3500000 |
|  9 | Martha Betancurt Ossa     | Cartagena    | Femenino  |     6000000 |
| 10 | Mateo Vasquez Posada      | Cartagena    | Masculino |     3000000 |
| 11 | Pablo Andres Arboleda     | Cartagena    | Masculino |     1500000 |
| 12 | Ana Maria Guerrero Guasca | cartagena    | femenino  |     5000000 |
+----+---------------------------+--------------+-----------+-------------+
6 rows in set (0.001 sec)

MariaDB [turismo]> describe visitantes;
+-------------+----------------+------+-----+---------+----------------+
| Field       | Type           | Null | Key | Default | Extra          |
+-------------+----------------+------+-----+---------+----------------+
| id          | int(11)        | NO   | PRI | NULL    | auto_increment |
| nombre      | char(40)       | NO   |     | NULL    |                |
| ciudad      | char(15)       | NO   |     | NULL    |                |
| sexo        | char(15)       | NO   |     | NULL    |                |
| montocompra | float unsigned | YES  |     | NULL    |                |
+-------------+----------------+------+-----+---------+----------------+
5 rows in set (0.062 sec)

MariaDB [turismo]> describe visitantesa;
+-------------+----------------+------+-----+---------+-------+
| Field       | Type           | Null | Key | Default | Extra |
+-------------+----------------+------+-----+---------+-------+
| id          | int(11)        | NO   |     | 0       |       |
| nombre      | char(40)       | NO   |     | NULL    |       |
| ciudad      | char(15)       | NO   |     | NULL    |       |
| sexo        | char(15)       | NO   |     | NULL    |       |
| montocompra | float unsigned | YES  |     | NULL    |       |
+-------------+----------------+------+-----+---------+-------+
5 rows in set (0.004 sec)

MariaDB [turismo]>  insert into visitantes(nombre,ciudad,sexo,montocompra) values('Ana Maria Guerrero Guasca','cartagena','femenino',5000000);
Query OK, 1 row affected (0.060 sec)

MariaDB [turismo]> select * from visitantesa;
+----+---------------------------+--------------+-----------+-------------+
| id | nombre                    | ciudad       | sexo      | montocompra |
+----+---------------------------+--------------+-----------+-------------+
|  4 | Diana Patricia Garcia     | Medellin     | Femenino  |     2500000 |
|  5 | Juan Alberto Cardona      | Barranquilla | Masculino |     3500000 |
|  9 | Martha Betancurt Ossa     | Cartagena    | Femenino  |     6000000 |
| 10 | Mateo Vasquez Posada      | Cartagena    | Masculino |     3000000 |
| 11 | Pablo Andres Arboleda     | Cartagena    | Masculino |     1500000 |
| 12 | Ana Maria Guerrero Guasca | cartagena    | femenino  |     5000000 |
| 13 | Ana Maria Guerrero Guasca | cartagena    | femenino  |     5000000 |
+----+---------------------------+--------------+-----------+-------------+
7 rows in set (0.001 sec)

MariaDB [turismo]> select * from visitantes;
+----+---------------------------+--------------+-----------+-------------+
| id | nombre                    | ciudad       | sexo      | montocompra |
+----+---------------------------+--------------+-----------+-------------+
|  1 | Juan carlos Perez         | Bogota       | Masculino |     1500000 |
|  2 | Elizabeth Torres          | Bogota       | Femenino  |     1000000 |
|  3 | Carmen  Elvira Montes     | Medellin     | Femenino  |     2000000 |
|  4 | Diana Patricia Garcia     | Medellin     | Femenino  |     2500000 |
|  5 | Juan Alberto Cardona      | Barranquilla | Masculino |     3500000 |
|  6 | Felipe Ardila Castro      | Barranquilla | Masculino |     3000000 |
|  7 | Mariana Ocampo Cifuentes  | Barranquilla | Femenino  |     1800000 |
|  8 | Mirian Ocampo Cifuentes   | Cartagena    | Femenino  |     1600000 |
|  9 | Martha Betancurt Ossa     | Cartagena    | Femenino  |     6000000 |
| 10 | Mateo Vasquez Posada      | Cartagena    | Masculino |     3000000 |
| 11 | Pablo Andres Arboleda     | Cartagena    | Masculino |     1500000 |
| 12 | Ana Maria Guerrero Guasca | cartagena    | femenino  |     5000000 |
| 13 | Ana Maria Guerrero Guasca | cartagena    | femenino  |     5000000 |
+----+---------------------------+--------------+-----------+-------------+
13 rows in set (0.000 sec)

MariaDB [turismo]> Drop view visitantesa;
Query OK, 0 rows affected (0.001 sec)

MariaDB [turismo]> show tables;
+-------------------+
| Tables_in_turismo |
+-------------------+
| visitantes        |
+-------------------+
1 row in set (0.001 sec)

MariaDB [turismo]> exit