sql multiple if code example

Example: where sql multiple conditions

SELECT *
FROM suppliers
WHERE (state = 'California' AND supplier_id <> 900)
OR (supplier_id = 100);