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      | ORDERS   | index  | PRIMARY,ORDERS_FK1                  | ORDERS_FK1 | 4       | NULL                      | 1494525 | 1500000.00 |   100.00 |     100.00 | Using index; Using temporary; Using filesort |
|    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.11 | Using where                                  |
|    1 | SIMPLE      | LINEITEM | ref    | PRIMARY,IDX_LINEITEM_ORDERKEY_FKIDX | PRIMARY    | 8       | tpch.ORDERS.O_ORDERKEY    | 4       | 4.00       |    75.00 |      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 | 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 (18.925 sec)

MariaDB [tpch]> notee