select p.pnum
from   part p
where  p.color = 'Red'
  and  p.city  = 'London'
