MariaDB [tpch]> source Q2.sql
+------+--------------------+----------+--------+-----------------------------------------------------+---------+---------+---------------------------+--------+-----------+----------+------------+--------------------------------------------------------+
| id   | select_type        | table    | type   | possible_keys                                       | key     | key_len | ref                       | rows   | r_rows    | filtered | r_filtered | Extra                                                  |
+------+--------------------+----------+--------+-----------------------------------------------------+---------+---------+---------------------------+--------+-----------+----------+------------+--------------------------------------------------------+
|    1 | PRIMARY            | PART     | ALL    | PRIMARY                                             | NULL    | NULL    | NULL                      | 197777 | 200000.00 |   100.00 |       0.39 | Using where; Using temporary; Using filesort           |
|    1 | PRIMARY            | PARTSUPP | ref    | PRIMARY,PARTSUPP_PART_FKIDX,PARTSUPP_SUPPLIER_FKIDX | PRIMARY | 4       | tpch.PART.P_PARTKEY       | 3      | 4.00      |   100.00 |      15.20 | Using where                                            |
|    1 | PRIMARY            | SUPPLIER | eq_ref | PRIMARY,SUPPLIER_NATION_FKIDX                       | PRIMARY | 4       | tpch.PARTSUPP.PS_SUPPKEY  | 1      | 1.00      |   100.00 |     100.00 |                                                        |
|    1 | PRIMARY            | NATION   | ALL    | PRIMARY,NATION_REGIONKEY_FKIDX                      | NULL    | NULL    | NULL                      | 25     | 25.00     |     4.00 |       4.00 | Using where; Using join buffer (flat, BNL join)        |
|    1 | PRIMARY            | REGION   | ALL    | PRIMARY                                             | NULL    | NULL    | NULL                      | 5      | 5.00      |    20.00 |      19.96 | Using where; Using join buffer (incremental, BNL join) |
|    2 | DEPENDENT SUBQUERY | PARTSUPP | ref    | PRIMARY,PARTSUPP_PART_FKIDX,PARTSUPP_SUPPLIER_FKIDX | PRIMARY | 4       | tpch.PART.P_PARTKEY       | 3      | 4.00      |   100.00 |     100.00 |                                                        |
|    2 | DEPENDENT SUBQUERY | SUPPLIER | eq_ref | PRIMARY,SUPPLIER_NATION_FKIDX                       | PRIMARY | 4       | tpch.PARTSUPP.PS_SUPPKEY  | 1      | 1.00      |   100.00 |     100.00 | Using where                                            |
|    2 | DEPENDENT SUBQUERY | NATION   | eq_ref | PRIMARY,NATION_REGIONKEY_FKIDX                      | PRIMARY | 4       | tpch.SUPPLIER.S_NATIONKEY | 1      | 1.00      |   100.00 |     100.00 | Using where                                            |
|    2 | DEPENDENT SUBQUERY | REGION   | eq_ref | PRIMARY                                             | PRIMARY | 4       | tpch.NATION.N_REGIONKEY   | 1      | 1.00      |   100.00 |      21.02 | Using where                                            |
+------+--------------------+----------+--------+-----------------------------------------------------+---------+---------+---------------------------+--------+-----------+----------+------------+--------------------------------------------------------+
9 rows in set (0.064 sec)

MariaDB [tpch]> notee