SELECT officeCode, city, phone FROM offices WHERE country IN ('USA', 'France');
SELECT officeCode, city, phone FROM offices WHERE country = 'USA' OR country = 'France';
SELECT officeCode, city, phone FROM offices WHERE country NOT IN ('USA', 'France');
SELECT orderNumber, customerNumber, status, shippedDate FROM orders WHERE orderNumber IN (SELECT orderNumber FROM orderdetails GROUP BY orderNumber HAVING SUM(quantityOrdered * priceEach) > 60000);
SELECT orderNumber FROM orderdetails GROUP BY orderNumber HAVING SUM(quantityOrdered * priceEach) > 60000;
SELECT orderNumber, customerNumber, STATUS, shippedDate FROM orders WHERE orderNumber IN (10165, 10287, 10310);