TABLE 1: Desired results for customer yearly order quantities
custid 2002 2003 2004
A 20 40 10
B 30 20 15
C 20 10 20
D 30 NULL NULL