-- When combining these conditions, it is important to use brackets 
-- so that the database knows what order to evaluate each condition.
 
-- Example #1
 
-- The first example that we'll take a look at an example that 
-- combines the AND and OR conditions.
 
SELECT *
FROM suppliers
WHERE (city = 'New York' AND name = 'IBM')
OR (city = 'Newark');
 
-- This would return all suppliers that reside in New York whose 
-- name is IBM and all suppliers that reside in Newark. The brackets 
-- determine what order the AND and OR conditions are evaluated in.
 
 
 
-- Example #2
 
-- The next example takes a look at a more complex statement.
 
-- For example:
 
SELECT supplier_id
FROM suppliers
WHERE (name = 'IBM')
OR (name = 'Hewlett Packard' AND city = 'Atlantic City')
OR (name = 'Gateway' AND status = 'Active' AND city = 'Burma');
 
-- This SQL statement would return all supplier_id values where the 
-- supplier's name is IBM or the name is Hewlett Packard and the 
-- city is Atlantic City or the name is Gateway, the status is 
-- Active, and the city is Burma.