xxxxxxxxxx
SELECT column1, column2, FROM table_name WHERE column_name1 = 'value1' AND column_name2 = 'value2';
xxxxxxxxxx
SELECT *
FROM suppliers
WHERE (state = 'California' AND supplier_id <> 900)
OR (supplier_id = 100);
xxxxxxxxxx
SELECT * FROM table WHERE gender = M AND age >= '18' AND age <= '50';
xxxxxxxxxx
SELECT suppliers.suppler_name, orders.order_id
FROM suppliers, orders
WHERE suppliers.supplier_id = orders.supplier_id
AND suppliers.state = 'California';