/*
For each supplier, show his supplier number and
        the project number of the project that receives
        the highest number of shipment from this supplier.

Hint: you need to group by (snum, jnum)
*/



select snum, jnum, count(*)
from   spj X
group by snum, jnum
having count(*) >= ALL (select count(*)     /*# shipments to projs from X*/
                        from   spj
			where  snum=X.snum
			group by snum, jnum
                       )
