USE tpch1;
select count(*) from part, lineitem
where p_retailprice < 913.65 
and  p_partkey = l_suppkey 
and l_shipdate < '1992-04-09';
count(*)
910