/*
Get snum of suppliers who have at least 3 shipments
       to the project 'j4'.
*/

select sname, count(jnum)
from supplier, spj
where supplier.snum = spj.snum
  and jnum='j4'
group by supplier.snum
having count(jnum) >= 3
order by sname

