mysql> SELECT * FROM phrase_or_demo WHERE MATCH('"(happy | sad | angry) customer"');
--------------
SELECT * FROM phrase_or_demo WHERE MATCH('"(happy | sad | angry) customer"')
--------------

+------+---------------------------+---------------------------------------------------+------------+
| id   | title                     | content                                           | category   |
+------+---------------------------+---------------------------------------------------+------------+
|    2 | Sad Customer Feedback     | I am a very sad customer with poor experience     | reviews    |
|    4 | Angry Customer Complaint  | I am an angry customer demanding refund           | complaints |
|    1 | Happy Customer Review     | I am a very happy customer with excellent service | reviews    |
|   10 | Customer Happy Experience | The happy customer left positive feedback         | feedback   |
+------+---------------------------+---------------------------------------------------+------------+
4 rows in set (0.00 sec)

mysql> desc all_orders;
--------------
desc all_orders
--------------

+--------------+-------+
| Agent        | Type  |
+--------------+-------+
| orders_north | local |
| orders_south | local |
+--------------+-------+
2 rows in set (0.00 sec)

mysql> desc all_customers;
--------------
desc all_customers
--------------

+-----------------+-------+
| Agent           | Type  |
+-----------------+-------+
| customers_north | local |
| customers_south | local |
+-----------------+-------+
2 rows in set (0.00 sec)

mysql> SELECT all_customers.name, all_customers.email, SUM(amount) total_spent, COUNT(*) order_count FROM all_orders INNER JOIN all_customers ON all_orders.customer_id = all_customers.id WHERE amount > 50 GROUP BY all_customers.id, all_customers.name, all_customers.email HAVING total_spent > 200 ORDER BY total_spent DESC
--------------

+--------------------+---------------------+-------------+-------------+
| all_customers.name | all_customers.email | total_spent | order_count |
+--------------------+---------------------+-------------+-------------+
| Alice Johnson      | alice@email.com     | 1224.989990 |           3 |
| Carol Davis        | carol@email.com     |  419.989990 |           2 |
| David Wilson       | david@email.com     |  350.000000 |           1 |
+--------------------+---------------------+-------------+-------------+
3 rows in set (0.00 sec)