START TRANSACTION;
auto commit mode: off
select
	c_name,
	c_custkey,
	o_orderkey,
	o_orderdate,
	o_totalprice,
	sum(l_quantity)
from
	customer,
	orders,
	lineitem
where
	o_orderkey in (
		select
			l_orderkey
		from
			lineitem
		group by
			l_orderkey having
				sum(l_quantity) > 314
	)
	and c_custkey = o_custkey
	and o_orderkey = l_orderkey
group by
	c_name,
	c_custkey,
	o_orderkey,
	o_orderdate,
	o_totalprice
order by
	o_totalprice desc,
	o_orderdate
LIMIT 100;
+--------+-----------+------------+-------------+--------------+----+
| c_name | c_custkey | o_orderkey | o_orderdate | o_totalprice | L6 |
+========+===========+============+=============+==============+====+
+--------+-----------+------------+-------------+--------------+----+
0 tuples
COMMIT;
auto commit mode: on