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

           FROM publishers
           WHERE pub_name= “Binnet & Hardley”)

64) SELECT pub_name
 FROM publishers
 WHERE pub_id IN
          (SELECT pub_id
          FROM titles
          WHERE type= “business”)

65) SELECT pub_name
 FROM publishers p
 WHERE EXISTS
          (SELECT *
          FROM titles t
          WHERE p.pub_id=t.pub_id
                AND type=“popular_comp”)

66) SELECT pub_name
 FROM publishers p
 WHERE NOT EXISTS
          (SELECT *
          FROM titles t
          WHERE p.pub_id=t.pub_id
                AND type=“mod_cook”)

67) SELECT pub_name
 FROM publishers
 WHERE pub_id NOT IN
          (SELECT pub_id
          FROM titles
          WHERE type=“psychology”)

68) SELECT type, price
 FROM titles
 WHERE price < (SELECT AVG(price) FROM titles)



                        24