Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
Description
git.commit.id.abbrev=caa8b78
select
c.c_name,
c.c_custkey,
o.o_orderkey,
o.o_orderdate,
o.o_totalprice,
sum(l.l_quantity)
from
customer c,
orders o,
lineitem l
where
o.o_orderkey in (
select
l_orderkey
from
lineitem
group by
l_orderkey having
sum(l_quantity) > 300
)
and c.c_custkey = o.o_custkey
and o.o_orderkey = l.l_orderkey
group by
c.c_name,
c.c_custkey,
o.o_orderkey,
o.o_orderdate,
o.o_totalprice
order by
o.o_totalprice desc,
o.o_orderdate
limit 100
I attached the error logs and the sql used to create the views. Let me know if you need anything else