could anyone please share a query using the 'in' operator?

Answer 1

SELECT *FROM CUSTOMERS WHERE CITY IN('LOS ANGELES','NEW YORK');

Answer 2

SELECT * FROM CUSTOMER WHERE ID IN (SELECT DISTINT(CUSTOMERID) FROM ORDERS)

Answer 3

SELECT *
FROM SDET
WHERE TOOL IN ('MFG123', 'MFG245', 'MFG300')
AND TESTDATE BETWEEN '04/23/2016' TO '05/02/2016'