ch01

[superhail]

maybe date should be toDate now? Below is my revised ch01.

select
	l_returnflag,
	l_linestatus,
	sum(l_quantity) as sum_qty,
	sum(l_extendedprice) as sum_base_price,
	sum(l_extendedprice * (1 - l_discount)) as sum_disc_price,
	sum(l_extendedprice * (1 - l_discount) * (1 + l_tax)) as sum_charge,
	avg(l_quantity) as avg_qty,
	avg(l_extendedprice) as avg_price,
	avg(l_discount) as avg_disc,
	count(*) as count_order
from
	lineitem
where
	l_shipdate <= toDate('1998-12-01') - interval '90' day
group by
	l_returnflag,
	l_linestatus
order by
	l_returnflag,
	l_linestatus;

[sstalin]

Seems Clickhouse internally converts it toDate function implicitly.

:) select date'2022-12-12';

SELECT toDate('2022-12-12')

Query id: e6714a6d-ecce-449d-9fb8-bae90adcbccc

┌─toDate('2022-12-12')─┐
│           2022-12-12 │
└──────────────────────┘

1 row in set. Elapsed: 0.001 sec.