How many of the items are instructed to be delivered in person?
instructed to be delivered in person refers to l_shipinstruct = 'DELIVER IN PERSON'
SELECT COUNT(l_linenumber) FROM lineitem WHERE l_shipinstruct = 'DELIVER IN PERSON'