SELECT *
FROM Orders
WHERE odate IN (10/03/1990,10/04/1990);
и
SELECT *
FROM Orders
WHERE odate BETWEEN 10/03/1990 AND 10/04,1990;
SELECT *
FROM Customers
WHERE snum IN (1001,1004);
SELECT *
FROM Customers
WHERE cname BETWEEN 'A' AND 'H';
ПРИМЕЧАНИЕ: В ASCII базовой системе Hoffman не будет выведен из-за конечных пробелов после H. По той же самой причине вторая граница не может быть G, поскольку она не выведет имена Giovanni и Grass. G может использоваться в сопровождении с Z, так чтобы следовать за другими символами в алфавитном Заказе, а не предшествовать им, как это делают пробелы.
SELECT *
FROM Customers
WHERE cname LIKE 'C%';
SELECT *
FROM Orders
WHERE amt <> 0 AND (amt IS NOT NULL);
или
SELECT *
FROM Orders
WHERE NOT (amt = 0 OR amt IS NULL);
Глава 6
SELECT COUNT(*)
FROM Orders
WHERE odate = 10/03/1990;
SELECT COUNT (DISTINCT city)
FROM Customers;
SELECT cnum, MIN (amt)
FROM Orders
GROUP BY cnum;
SELECT MIN (cname)
FROM Customers
WHERE cname LIKE 'G%';
SELECT city, MAX (rating)
FROM Customers
GROUP BY city;
SELECT odate, count (DISTINCT snum)
FROM Orders
GROUP BY odate;
Глава 7
SELECT onum, snum, amt * .12
FROM Orders;
SELECT 'For the city ', city, ', the highest rating is ', MAX (rating)
FROM Customers
GROUP BY city;
SELECT rating, cname, cnum
FROM Customers
ORDER BY rating DESC;
SELECT odate, SUM (amt)
FROM Orders
GROUP BY odate
ORDER BY 2 DESC;
