Работа с базами данных в архитектуре клиент-сервер. Дубинин В.Н. - 19 стр.

28) SELECT phone
 FROM authors
 WHERE address LIKE “%Broadway Av.%”

29) SELECT title, pubdate
 FROM titles
 WHERE pubdate>= “Jun 9 1991 12:00AM”
      AND pubdate< “6/16/91”

30) SELECT type, AVG(price) “avg”, SUM(price) “sum”
 FROM titles
 WHERE type IN (“business”, “psychology”)
 GROUP BY type

31) SELECT type, pub_id, AVG(price) “avg”, SUM(price) “sum”
 FROM titles
 WHERE type IN (“business”, “mod_cook”)
 GROUP BY type, pub_id

32) SELECT type, AVG(price)
 FROM titles
 WHERE price>$11
 GROUP BY type
 HAVING AVG(price)>$19.7

33) SELECT au_id, COUNT(*)
 FROM authors
 GROUP BY au_id
 HAVING COUNT(*)>1

34) SELECT type, MIN(price), MAX(price)
 FROM titles
 GROP BY type
 ORDER BY type

35) SELECT type, MIN(price), MAX(price)



                         19