How many items were shipped on 4th December, 1993?
items shipped on 4th December, 1993 refer to l_linenumber where l_shipdate = '1993-12-04';
SELECT COUNT(l_linenumber) FROM lineitem WHERE l_shipdate = '1993-12-04'