MariaDB [tpch]> source Q4.sql
+------+-------------+----------+------+-------------------------------------+---------+---------+------------------------+---------+------------+----------+------------+----------------------------------------------+
| id   | select_type | table    | type | possible_keys                       | key     | key_len | ref                    | rows    | r_rows     | filtered | r_filtered | Extra                                        |
+------+-------------+----------+------+-------------------------------------+---------+---------+------------------------+---------+------------+----------+------------+----------------------------------------------+
|    1 | PRIMARY     | ORDERS   | ALL  | PRIMARY                             | NULL    | NULL    | NULL                   | 1500000 | 1500000.00 |     3.91 |       3.77 | Using where; Using temporary; Using filesort |
|    1 | PRIMARY     | LINEITEM | ref  | PRIMARY,IDX_LINEITEM_ORDERKEY_FKIDX | PRIMARY | 8       | tpch.ORDERS.O_ORDERKEY | 4       | 1.46       |    25.00 |      62.70 | Using where; FirstMatch(ORDERS)              |
+------+-------------+----------+------+-------------------------------------+---------+---------+------------------------+---------+------------+----------+------------+----------------------------------------------+
2 rows in set (0.444 sec)

MariaDB [tpch]> notee