mysql> SELECT COUNT(*) FROM utilisateur;
+----------+
| COUNT(*) |
+----------+
|        5 |
+----------+
1 row in set (0.03 sec)

mysql> SELECT COUNT(DISTINCT email) FROM utilisateur;
+-----------------------+
| COUNT(DISTINCT email) |
+-----------------------+
|                     3 |
+-----------------------+
1 row in set (0.01 sec)

mysql> SELECT AVG(age) FROM utilisateur;
+----------+
| AVG(age) |
+----------+
|  29.3333 |
+----------+
1 row in set (0.00 sec)

mysql> SELECT MAX(age) FROM utilisateur;
+----------+
| MAX(age) |
+----------+
|       34 |
+----------+
1 row in set (0.01 sec)

mysql> SELECT MIN(age) FROM utilisateur;
+----------+
| MIN(age) |
+----------+
|       25 |
+----------+
1 row in set (0.00 sec)

mysql> SELECT COUNT(*) FROM commande;
+----------+
| COUNT(*) |
+----------+
|        5 |
+----------+
1 row in set (0.00 sec)

mysql> SELECT SUM(montant) FROM commande;
+--------------+
| SUM(montant) |
+--------------+
|       770.50 |
+--------------+
1 row in set (0.00 sec)

mysql> SELECT avg(montant) FROM commande;
+--------------+
| avg(montant) |
+--------------+
|   192.625000 |
+--------------+
1 row in set (0.00 sec)

mysql> SELECT COUNT(montant) FROM commande;
+----------------+
| COUNT(montant) |
+----------------+
|              4 |
+----------------+
1 row in set (0.00 sec)

mysql> SELECT MAX(date_commande) FROM commande;
+--------------------+
| MAX(date_commande) |
+--------------------+
| 2024-03-01         |
+--------------------+
1 row in set (0.00 sec)

mysql> SELECT COUNT(DISTINCT utilisateur_id) FROM commande;
+--------------------------------+
| COUNT(DISTINCT utilisateur_id) |
+--------------------------------+
|                              4 |
+--------------------------------+
1 row in set (0.01 sec)










