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

     FROM titles t, publishers p
     WHERE t.pub_id=p.pub_id
     GROUP BY pub_name
     HAVING MIN(price)>=ALL
                (SELECT MIN(price)
                FROM titles tt JOIN publishers pp
                      ON tt.pub_id=pp.pub_id
                GROUP BY pub_name)

    87) SELECT *
     FROM publishers
     WHERE pub_id IN
              (SELECT pub_id
              FROM titles
              WHERE type= “psychology” AND pub_id IN
                         (SELECT pub_id
                         FROM publishers
                         WHERE country= “USA”
                              AND state<> “CA”)

88) SELECT au_lname, au_fname
     FROM authors a
     WHERE a.au_id IN
         (SELECT au_id
         FROM titleauthor ta
         WHERE ta.title_id IN
               (SELECT title_id
               FROM titles t
               WHERE “CA”=SOME
                    (SELECT state
                    FROM publishers p
                    WHERE p.pub_id=t.pub_id)))
     ORDER BY au_lname, au_fname

    89) SELECT state, COUNT(*)
     FROM publishers p



                              29