add facility including
in (const)
case...when
and change the expression calculation in project
eg:
select * from LINEITEM where (row_id,L_QUANTITY,L_RETURNFLAG,L_SHIPDATE)
in ((1,36.0,'N','1996-04-2'),(3,28.0,'N','1996-04-21'));

SELECT
L_RETURNFLAG,L_LINESTATUS,
SUM(L_QUANTITY),SUM(L_EXTENDEDPRICE),SUM(L_EXTENDEDPRICE*(1-L_DISCOUNT)),SUM(L_EXTENDEDPRICE*(1-L_DISCOUNT)*(1+L_TEX)),
avg(L_QUANTITY),avg(L_EXTENDEDPRICE),avg(L_DISCOUNT) ,
count(*)
FROM LINEITEM  
WHERE L_SHIPDATE <= DATE_ADD('1998-12-01',INTERVAL 3 DAY)
GROUP BY L_RETURNFLAG,L_LINESTATUS 
ORDER BY L_RETURNFLAG,L_LINESTATUS;

select row_id,upper(case when row_id<10 then 'a' when row_id<20 then 'b'
else 'c' end ),trim(L_COMMENT) from LINEITEM where row_id<23;
2014.8.23