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

          AND t.pub_id=p.pub_id AND country=’USA’
          AND price=
                     (SELECT MIN(price)
                     FROM titles tt, publishers pp
                     WHERE tt.pub_id=pp.pub_id
                     GROUP BY country
                     HAVING country=’USA’)

    80) SELECT DISTINCT au_lname, au_fname
     FROM authors a, titles t, titleauthor ta
     WHERE a.au_id=ta.au_id AND ta.title_id IN
              (SELECT title_id
              FROM titles
              WHERE ytd_sales=
                            (SELECT MAX(ytd_sales)
                             FROM titles))

81) 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)
     UNION 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)

82) SELECT title, price
     FROM titles t JOIN publishers p ON t.pub_id=p.pub_id
     WHERE p.country= “USA” AND t.price=
                 (SELECT MAX(price)
                      FROM titles tt JOIN publishers pp
                        ON tt.pub_id=pp.pub_id



                              27