3.sql

1.
SELECT * FROM ORDERS WHERE (Odate = '1990-10-03' OR Odate = '1990-10-03');
SELECT * FROM ORDERS WHERE Odate IN ('1990-10-03', '1990-10-03');


2.
SELECT *
FROM CUSTOMERS, SALESPEOPLE
WHERE SALESPEOPLE.Snum = CUSTOMERS.Snum AND (Sname = 'Peel' OR Sname = 'Motika');

3.
SELECT * FROM CUSTOMERS WHERE Cname REGEXP '^[A-G, a-g]';

4.
SELECT * FROM CUSTOMERS WHERE Cname REGEXP '^[C]';

5.
SELECT * FROM ORDERS WHERE Amt IS NOT NULL OR Amt != 0;