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

scale$1.$lineitem

where

l$\_$shipdate $<=$ date $\text{'}1998-12-01\text{'}-$ interval $\text{'}90\text{'}$ day

group by

l$\_$returnflag,

l$\_$linestatus

order by

l$\_$returnflag,

l$\_$linestatus;

this is the query plan based on the query above:

Finalize GroupAggregate $($cost$=231151\mathrm{.}60.\mathrm{.}231153\mathrm{.}55$ rows$=6$ width$=236)$

Group Key: l$\_$returnflag, l$\_$linestatus

$->$ Gather Merge $($cost$=231151\mathrm{.}60.\mathrm{.}231153\mathrm{.}00$ rows$=12$ width$=236)$

Workers Planned: $2$

$->$ Sort $($cost$=230151\mathrm{.}58.\mathrm{.}230151\mathrm{.}59$ rows$=6$ width$=236)$

Sort Key: l$\_$returnflag, l$\_$linestatus

$->$ Partial HashAggregate $($cost$=230151\mathrm{.}36.\mathrm{.}230151\mathrm{.}50$ rows$=6$ width$=236)$

Group Key: l$\_$returnflag, l$\_$linestatus

$->$ Parallel Seq Scan on lineitem $($cost$=0\mathrm{.}00.\mathrm{.}143854\mathrm{.}94$ rows$=2465612$ width$=25)$

Filter: $($l$\_$shipdate $<=\text{'}1998-09-0200$:$00$:$00\text{'}$::timestamp without time zone$)$

Provide an sketch of a query plan for the column$-$based approach using late materialization.