Мартин грубер понимание sql перевод Лебедева В. Н. Под редакцией Булычева В. Н. Москва, 1993 martin gruber

SELECT *
FROM Orders
WHERE NOT (amt = 0 OR amt IS NULL);
Глава 6

0. 
   

SELECT COUNT(*)
FROM Orders
WHERE odate = 10/03/1990;

0. 
   

SELECT COUNT (DISTINCT city)
FROM Customers;

0. 
   

SELECT cnum, MIN (amt)
FROM Orders
GROUP BY cnum;

0. 
   

SELECT MIN (cname)
FROM Customers
WHERE cname LIKE 'G%';

0. 
   

SELECT city, MAX (rating)
FROM Customers
GROUP BY city;

0. 
   

SELECT odate, count (DISTINCT snum)
FROM Orders
GROUP BY odate;
Глава 7

0. 
   

SELECT onum, snum, amt * .12
FROM Orders;

0. 
   

SELECT 'For the city ', city, ', the highest rating is ', MAX (rating)
FROM Customers
GROUP BY city;

0. 
   

SELECT rating, cname, cnum
FROM Customers
ORDER BY rating DESC;

0. 
   

SELECT odate, SUM (amt)
FROM Orders
GROUP BY odate
ORDER BY 2 DESC;
Глава 8

0. 
   

SELECT onum, cname
FROM Orders, Customers
WHERE Customers.cnum = Orders.cnum;

0. 
   

SELECT onum, cname, sname
FROM Orders, Customers, Salespeople
WHERE Customers.cnum = Orders.cnum AND Salespeople.snum = Orders.snum;

0. 
   

SELECT cname, sname, comm
FROM Salespeople, Customers
WHERE Salespeople.snum = Customers.snum AND comm * .12;

0. 
   

SELECT onum, comm * amt
FROM Salespeople, Orders, Customers
WHERE rating > 100 AND
Orders.cnum = Customers.cnum AND
Orders.snum = Salespeople.snum;
Глава 9

0.