Select all except some rows

Question

let's say i have table with this structure:

  id      model       color
------  --------    ----------
   1      Ford           yellow
   2      Ford           green
   3      Ford           red
   4      Ford           yellow
   5      Subaru         yellow
   6      Subaru         red

I need to make a query, which returns me every car in list, except for yellow ford's. Can somebody help?

Answer 1

... WHERE NOT (model = 'Ford' AND color = 'yellow')