/* Using AND, OR and NOT */

SELECT  *  FROM  student
WHERE  lname  =  'Chan'
  AND  fname  =  'David';

SELECT  *  FROM  student
WHERE  lname  LIKE  'M%'
   OR  fname  LIKE  'C%';

SELECT  *  FROM  student
WHERE  lname  NOT LIKE  'M%';



/* You can always nest them by adding parenthesis */

SELECT  *  FROM  student
WHERE   (lname = 'willis' OR lname = 'milgrom') AND fname = 'anya';

SELECT  *  FROM  student
WHERE  NOT (lname = 'Chan' OR lname = 'Willis');