+------+--------------------+----------+-------+--------------------------------------------+---------------+---------+------------------------+---------+----------+-----------------------------------------------------------------------------------------+
| id   | select_type        | table    | type  | possible_keys                              | key           | key_len | ref                    | rows    | filtered | Extra                                                                                   |
+------+--------------------+----------+-------+--------------------------------------------+---------------+---------+------------------------+---------+----------+-----------------------------------------------------------------------------------------+
|    1 | PRIMARY            | orders   | range | i_o_orderdate                              | i_o_orderdate | 4       | NULL                   | 3443440 |   100.00 | Using index condition; Using where; Rowid-ordered scan; Using temporary; Using filesort |
|    2 | DEPENDENT SUBQUERY | lineitem | ref   | PRIMARY,i_l_orderkey,i_l_orderkey_quantity | PRIMARY       | 4       | dbt3.orders.o_orderkey |       4 |   100.00 | Using where                                                                             |
+------+--------------------+----------+-------+--------------------------------------------+---------------+---------+------------------------+---------+----------+-----------------------------------------------------------------------------------------+
+-------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Level | Code | Message                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
+-------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Note  | 1276 | Field or reference 'dbt3.orders.o_orderkey' of SELECT #2 was resolved in SELECT #1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| Note  | 1003 | select `dbt3`.`orders`.`o_orderpriority` AS `o_orderpriority`,count(0) AS `order_count` from `dbt3`.`orders` where ((`dbt3`.`orders`.`o_orderDATE` >= DATE'1997-05-01') and (`dbt3`.`orders`.`o_orderDATE` < <cache>(('1997-05-01' + interval 3 month))) and <expr_cache><`dbt3`.`orders`.`o_orderkey`>(exists(select 1 from `dbt3`.`lineitem` where ((`dbt3`.`lineitem`.`l_orderkey` = `dbt3`.`orders`.`o_orderkey`) and (`dbt3`.`lineitem`.`l_commitDATE` < `dbt3`.`lineitem`.`l_receiptDATE`))))) group by `dbt3`.`orders`.`o_orderpriority` order by `dbt3`.`orders`.`o_orderpriority` |
+-------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+-----------------+----------+
| Variable_name   | Value    |
+-----------------+----------+
| Last_query_cost | 0.000000 |
+-----------------+----------+