MariaDB [tpch]> source Q7.sql;
+------+-------------+----------+--------+-------------------------------------+-----------------------+---------+-------------------------+------+---------+----------+------------+-------------------------------------------------+
| id   | select_type | table    | type   | possible_keys                       | key                   | key_len | ref                     | rows | r_rows  | filtered | r_filtered | Extra                                           |
+------+-------------+----------+--------+-------------------------------------+-----------------------+---------+-------------------------+------+---------+----------+------------+-------------------------------------------------+
|    1 | SIMPLE      | n2       | ALL    | PRIMARY                             | NULL                  | NULL    | NULL                    | 25   | 25.00   |     8.00 |       8.00 | Using where; Using temporary; Using filesort    |
|    1 | SIMPLE      | CUSTOMER | ref    | PRIMARY,CUSTOMER_NATION_FKIDX       | CUSTOMER_NATION_FKIDX | 5       | tpch.n2.N_NATIONKEY     | 6000 | 6050.00 |   100.00 |     100.00 | Using index                                     |
|    1 | SIMPLE      | ORDERS   | ref    | PRIMARY,ORDERS_FK1                  | ORDERS_FK1            | 4       | tpch.CUSTOMER.C_CUSTKEY | 15   | 10.06   |   100.00 |     100.00 | Using index                                     |
|    1 | SIMPLE      | LINEITEM | ref    | PRIMARY,IDX_LINEITEM_ORDERKEY_FKIDX | PRIMARY               | 8       | tpch.ORDERS.O_ORDERKEY  | 4    | 4.00    |    29.92 |      30.75 | Using where                                     |
|    1 | SIMPLE      | SUPPLIER | eq_ref | PRIMARY,SUPPLIER_NATION_FKIDX       | PRIMARY               | 4       | tpch.LINEITEM.L_SUPPKEY | 1    | 1.00    |   100.00 |     100.00 |                                                 |
|    1 | SIMPLE      | n1       | ALL    | PRIMARY                             | NULL                  | NULL    | NULL                    | 25   | 25.00   |     4.00 |       0.16 | Using where; Using join buffer (flat, BNL join) |
+------+-------------+----------+--------+-------------------------------------+-----------------------+---------+-------------------------+------+---------+----------+------------+-------------------------------------------------+
6 rows in set (0.676 sec)

MariaDB [tpch]> notee