Find the pid of all parts whose color is red.

Find the pid of all parts whose color is red and cost >= 1000 .

Find the pid of all parts whose color is red but not cost >=1000.