4. SELECT *
FROM Customers
WHERE cname LIKE 'C%';
5. SELECT *
FROM Orders
WHERE amt < > O
AND (amt IS NOT NULL);
Или
SELECT *
FROM Orders
WHERE NOT (amt = O
OR amt IS NULL);
Глава 6
1. 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
1. SELECT onum, snum, amt * .12
FROM Orders;
2. 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;
Глава 8
SELECT onum, cname
FROM Orders, Customers
WHERE Customers.cnum = Orders.cnum;
SELECT onum, cname, sname
FROM Orders, Customers, Salespeople
WHERE Customers.cnum = Orders.cnum
AND Salespeople.snum = Orders.snum;
SELECT cname, sname, comm
FROM Salespeople, Customers
WHERE Salespeople.snum = Customers.snum
AND comm * .12;
4. SELECT onum, comm * amt
FROM Salespeople, Orders, Customers
WHERE rating > 100
AND Orders.cnum = Customers.cnum
AND Orders.snum = Salespeople.snum;
Глава 9
SELECT first.sname, second.sname
