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      | LINEITEM | ALL    | PRIMARY,IDX_LINEITEM_ORDERKEY_FKIDX | NULL    | NULL    | NULL                      | 5950961 | 6000281.00 |   100.00 |      30.41 | Using where; Using temporary; Using filesort |
|    1 | SIMPLE      | SUPPLIER | eq_ref | PRIMARY,SUPPLIER_NATION_FKIDX       | PRIMARY | 4       | tpch.LINEITEM.L_SUPPKEY   | 1       | 1.00       |   100.00 |     100.00 | Using where                                  |
|    1 | SIMPLE      | ORDERS   | eq_ref | PRIMARY,ORDERS_FK1                  | PRIMARY | 8       | tpch.LINEITEM.L_ORDERKEY  | 1       | 1.00       |   100.00 |     100.00 |                                              |
|    1 | SIMPLE      | CUSTOMER | eq_ref | PRIMARY,CUSTOMER_NATION_FKIDX       | PRIMARY | 4       | tpch.ORDERS.O_CUSTKEY     | 1       | 1.00       |   100.00 |     100.00 | Using where                                  |
|    1 | SIMPLE      | n2       | eq_ref | PRIMARY                             | PRIMARY | 4       | tpch.CUSTOMER.C_NATIONKEY | 1       | 1.00       |   100.00 |       8.20 | Using where                                  |
|    1 | SIMPLE      | n1       | eq_ref | PRIMARY                             | PRIMARY | 4       | tpch.SUPPLIER.S_NATIONKEY | 1       | 1.00       |   100.00 |       3.98 | Using where                                  |
+------+-------------+----------+--------+-------------------------------------+---------+---------+---------------------------+---------+------------+----------+------------+----------------------------------------------+
6 rows in set (11.940 sec)

MariaDB [tpch]> notee