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

    69) SELECT type, AVG(price)
     FROM titles
     GROUP BY type
     HAVING AVG(price) < (SELECT AVG(price) FROM titles)

    70) SELECT DISTINCT a.city, a.state
     FROM authors a
     WHERE NOT EXISTS
              (SELECT *
              FROM publishers p
              WHERE a.city=p.city AND a.state=p.state)

71) SELECT DISTINCT p.city, p.state
     FROM publishers p
     WHERE NOT EXISTS
                   (SELECT *
                   FROM authors a
                   WHERE p.city=a.city AND p.state=a.state)

    72) SELECT MIN(price)
         FROM titles t
         WHERE t.pub_id IN
              (SELECT pub_id
              FROM publishers
              WHERE country=’USA’)

    73) SELECT title, type, price
     FROM titles
     WHERE price>ALL
                (SELECT price
                FROM titles
                WHERE type= “psychology”)

    74) SELECT COUNT(DISTINCT city)
     FROM publishers



                             25