USE tpch1; Select max(l_shipdate) from lineitem where l_orderkey < 1000000; max(l_shipdate) 1998-12-01